Skip to content

Instantly share code, notes, and snippets.

@febridev

febridev/gist:c7044ba125132f334e5807253dfb1a79

Created October 26, 2020 10:14
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save febridev/c7044ba125132f334e5807253dfb1a79 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save febridev/c7044ba125132f334e5807253dfb1a79 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
PLAN_TABLE_OUTPUT
Plan hash value: 3233107407
---------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
---------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 7 | 9093 | 11069 (1)| 00:00:01 |
| 1 | SORT ORDER BY | | 7 | 9093 | 11069 (1)| 00:00:01 |
|* 2 | HASH JOIN RIGHT OUTER | | 7 | 9093 | 11068 (1)| 00:00:01 |
|* 3 | TABLE ACCESS FULL | TGOSPEMPFAVORITE | 1 | 80 | 2 (0)| 00:00:01 |
| 4 | NESTED LOOPS OUTER | | 7 | 8533 | 11066 (1)| 00:00:01 |
| 5 | NESTED LOOPS OUTER | | 4 | 4472 | 11062 (1)| 00:00:01 |
| 6 | NESTED LOOPS OUTER | | 4 | 4012 | 11050 (1)| 00:00:01 |
| 7 | NESTED LOOPS | | 4 | 3732 | 11046 (1)| 00:00:01 |
| 8 | NESTED LOOPS | | 4 | 3664 | 11042 (1)| 00:00:01 |
|* 9 | HASH JOIN OUTER | | 4 | 3624 | 11042 (1)| 00:00:01 |
| 10 | NESTED LOOPS | | 4 | 416 | 41 (0)| 00:00:01 |
| 11 | NESTED LOOPS | | 4 | 416 | 41 (0)| 00:00:01 |
| 12 | NESTED LOOPS | | 4 | 272 | 33 (0)| 00:00:01 |
|* 13 | TABLE ACCESS FULL | TEODEMPPATH | 4 | 92 | 29 (0)| 00:00:01 |
| 14 | TABLE ACCESS BY INDEX ROWID | TEOMEMPPERSONAL | 1 | 45 | 1 (0)| 00:00:01 |
|* 15 | INDEX UNIQUE SCAN | SYS_C0053801 | 1 | | 0 (0)| 00:00:01 |
|* 16 | INDEX RANGE SCAN | IDX_EMPLOYEE_ALL | 1 | | 1 (0)| 00:00:01 |
|* 17 | TABLE ACCESS BY INDEX ROWID | TEODEMPCOMPANY | 1 | 36 | 2 (0)| 00:00:01 |
| 18 | VIEW | VIEW_ATTENDANCE | 1962 | 1536K| 11001 (1)| 00:00:01 |
| 19 | NESTED LOOPS | | 1962 | 335K| 11001 (1)| 00:00:01 |
| 20 | NESTED LOOPS | | 78880 | 335K| 11001 (1)| 00:00:01 |
| 21 | TABLE ACCESS FULL | TTAMSHIFTDAILY | 58 | 3538 | 4 (0)| 00:00:01 |
|* 22 | INDEX RANGE SCAN | IX_TUNED_TTADATTENDANCE_1 | 1360 | | 123 (2)| 00:00:01 |
|* 23 | TABLE ACCESS BY INDEX ROWID | TTADATTENDANCE | 34 | 3876 | 190 (2)| 00:00:01 |
|* 24 | INDEX UNIQUE SCAN | SYS_C0053949 | 1 | 10 | 0 (0)| 00:00:01 |
| 25 | TABLE ACCESS BY INDEX ROWID | TCLMUSER | 1 | 17 | 1 (0)| 00:00:01 |
|* 26 | INDEX UNIQUE SCAN | SYS_C0053882 | 1 | | 0 (0)| 00:00:01 |
| 27 | TABLE ACCESS BY INDEX ROWID | TEOMPOSITION | 1 | 70 | 1 (0)| 00:00:01 |
|* 28 | INDEX UNIQUE SCAN | SYS_C0053959 | 1 | | 0 (0)| 00:00:01 |
| 29 | TABLE ACCESS BY INDEX ROWID BATCHED| TTADATTSTATUSDETAIL | 1 | 115 | 3 (0)| 00:00:01 |
|* 30 | INDEX RANGE SCAN | SYS_C0053316 | 1 | | 2 (0)| 00:00:01 |
| 31 | TABLE ACCESS BY INDEX ROWID | TTAMATTSTATUS | 1 | 101 | 1 (0)| 00:00:01 |
|* 32 | INDEX UNIQUE SCAN | SYS_C0053743 | 1 | | 0 (0)| 00:00:01 |
---------------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
2 - access("tgospempfavorite"."FAVORITE_ID"(+)="P"."EMP_ID")
3 - filter("tgospempfavorite"."EMP_ID"(+)='DO197621' AND "tgospempfavorite"."FAVORITE_ID"(+)<>'DO197621'
AND "tgospempfavorite"."FAVORITE_ID"(+)<>'DO192138' AND ("tgospempfavorite"."FAVORITE_ID"(+)='DO190057' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190058' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190059' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190060' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190061' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190062' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190063' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190064' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190065' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190066' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190067' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190068' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190070' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190071' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190072' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190073' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190074' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190075' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190076' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190077' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190078' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190079' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190080' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190081' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190082' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190083' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190084' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190085' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190086' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190087' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190088' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190089' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190090' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190091' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190092' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190093' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190094' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190095' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190096' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190097' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190098' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190099' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190100' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190101' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190102' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190103' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190104' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190105' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190106' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190107' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190108' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190109' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190110' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190111' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190112' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190113' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190114' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190115' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190116' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190117' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190118' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190119' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190120' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190121' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190122' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190123' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190124' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190125' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190126' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190127' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190128' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190129' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190130' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190131' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190132' OR
"tgospempfavorite"."FAVORITE_ID"(+)='DO190133' OR "tgospempfavorite"."FAVORITE_ID"(+)='DO190135' O)
9 - access("viewAttendance"."EMP_ID"(+)="P"."EMP_ID")
13 - filter("H"."SPV_PARENT"='DO197621' AND ("H"."EMP_ID"='DO190057' OR "H"."EMP_ID"='DO190058' OR
"H"."EMP_ID"='DO190059' OR "H"."EMP_ID"='DO190060' OR "H"."EMP_ID"='DO190061' OR "H"."EMP_ID"='DO190062' OR
"H"."EMP_ID"='DO190063' OR "H"."EMP_ID"='DO190064' OR "H"."EMP_ID"='DO190065' OR "H"."EMP_ID"='DO190066' OR
"H"."EMP_ID"='DO190067' OR "H"."EMP_ID"='DO190068' OR "H"."EMP_ID"='DO190070' OR "H"."EMP_ID"='DO190071' OR
"H"."EMP_ID"='DO190072' OR "H"."EMP_ID"='DO190073' OR "H"."EMP_ID"='DO190074' OR "H"."EMP_ID"='DO190075' OR
"H"."EMP_ID"='DO190076' OR "H"."EMP_ID"='DO190077' OR "H"."EMP_ID"='DO190078' OR "H"."EMP_ID"='DO190079' OR
"H"."EMP_ID"='DO190080' OR "H"."EMP_ID"='DO190081' OR "H"."EMP_ID"='DO190082' OR "H"."EMP_ID"='DO190083' OR
"H"."EMP_ID"='DO190084' OR "H"."EMP_ID"='DO190085' OR "H"."EMP_ID"='DO190086' OR "H"."EMP_ID"='DO190087' OR
"H"."EMP_ID"='DO190088' OR "H"."EMP_ID"='DO190089' OR "H"."EMP_ID"='DO190090' OR "H"."EMP_ID"='DO190091' OR
"H"."EMP_ID"='DO190092' OR "H"."EMP_ID"='DO190093' OR "H"."EMP_ID"='DO190094' OR "H"."EMP_ID"='DO190095' OR
"H"."EMP_ID"='DO190096' OR "H"."EMP_ID"='DO190097' OR "H"."EMP_ID"='DO190098' OR "H"."EMP_ID"='DO190099' OR
"H"."EMP_ID"='DO190100' OR "H"."EMP_ID"='DO190101' OR "H"."EMP_ID"='DO190102' OR "H"."EMP_ID"='DO190103' OR
"H"."EMP_ID"='DO190104' OR "H"."EMP_ID"='DO190105' OR "H"."EMP_ID"='DO190106' OR "H"."EMP_ID"='DO190107' OR
"H"."EMP_ID"='DO190108' OR "H"."EMP_ID"='DO190109' OR "H"."EMP_ID"='DO190110' OR "H"."EMP_ID"='DO190111' OR
"H"."EMP_ID"='DO190112' OR "H"."EMP_ID"='DO190113' OR "H"."EMP_ID"='DO190114' OR "H"."EMP_ID"='DO190115' OR
"H"."EMP_ID"='DO190116' OR "H"."EMP_ID"='DO190117' OR "H"."EMP_ID"='DO190118' OR "H"."EMP_ID"='DO190119' OR
"H"."EMP_ID"='DO190120' OR "H"."EMP_ID"='DO190121' OR "H"."EMP_ID"='DO190122' OR "H"."EMP_ID"='DO190123' OR
"H"."EMP_ID"='DO190124' OR "H"."EMP_ID"='DO190125' OR "H"."EMP_ID"='DO190126' OR "H"."EMP_ID"='DO190127' OR
"H"."EMP_ID"='DO190128' OR "H"."EMP_ID"='DO190129' OR "H"."EMP_ID"='DO190130' OR "H"."EMP_ID"='DO190131' OR
"H"."EMP_ID"='DO190132' OR "H"."EMP_ID"='DO190133' OR "H"."EMP_ID"='DO190135' OR "H"."EMP_ID"='DO190136' OR
"H"."EMP_ID"='DO190137' OR "H"."EMP_ID"='DO190138' OR "H"."EMP_ID"='DO190139' OR "H"."EMP_ID"='DO190141' OR
"H"."EMP_ID"='DO190142' OR "H"."EMP_ID"='DO190143' OR "H"."EMP_ID"='DO190144' OR "H"."EMP_ID"='DO190145' OR
"H"."EMP_ID"='DO190146' OR "H"."EMP_ID"='DO190147' OR "H"."EMP_ID"='DO190148' OR "H"."EMP_ID"='DO190149' OR
"H"."EMP_ID"='DO190150' OR "H"."EMP_ID"='DO190151' OR "H"."EMP_ID"='DO190152' OR "H"."EMP_ID"='DO190153' OR
"H"."EMP_ID"='DO190154' OR "H"."EMP_ID"='DO190155' OR "H"."EMP_ID"='DO190156' OR "H"."EMP_ID"='DO190157' OR
"H"."EMP_ID"='DO190158' OR "H"."EMP_ID"='DO190159' OR "H"."EMP_ID"='DO190160' OR "H"."EMP_ID"='DO190161' OR
"H"."EMP_ID"='DO190162' OR "H"."EMP_ID"='DO190163' OR "H"."EMP_ID"='DO190164' OR "H"."EMP_ID"='DO190165' OR
"H"."EMP_ID"='DO190166' OR "H"."EMP_ID"='DO190167' OR "H"."EMP_ID"='DO190168' OR "H"."EMP_ID"='DO190169' OR
"H"."EMP_ID"='DO190171' OR "H"."EMP_ID"='DO190172' OR "H"."EMP_ID"='DO190173' OR "H"."EMP_ID"='DO190174' OR
"H"."EMP_ID"='DO190175' OR "H"."EMP_ID"='DO190176' OR "H"."EMP_ID"='DO190177' OR "H"."EMP_ID"='DO190179' OR
"H"."EMP_ID"='DO190180' OR "H"."EMP_ID"='DO190181' OR "H"."EMP_ID"='DO190182' OR "H"."EMP_ID"='DO190183' OR
"H"."EMP_ID"='DO190184' OR "H"."EMP_ID"='DO190186' OR "H"."EMP_ID"='DO190187' OR "H"."EMP_ID"='DO190188' OR
"H"."EMP_ID"='DO190189' OR "H"."EMP_ID"='DO190190' OR "H"."EMP_ID"='DO190191' OR "H"."EMP_ID"='DO190192' OR
"H"."EMP_ID"='DO190193' OR "H"."EMP_ID"='DO190194' OR "H"."EMP_ID"='DO190195' OR "H"."EMP_ID"='DO190196' OR
"H"."EMP_ID"='DO190197' OR "H"."EMP_ID"='DO190198' OR "H"."EMP_ID"='DO190199' OR "H"."EMP_ID"='DO190200' OR
"H"."EMP_ID"='DO190201' OR "H"."EMP_ID"='DO190203' OR "H"."EMP_ID"='DO190205' OR "H"."EMP_ID"='DO190206' OR
"H"."EMP_ID"='DO190207' OR "H"."EMP_ID"='DO190208' OR "H"."EMP_ID"='DO190209' OR "H"."EMP_ID"='DO190210' OR
"H"."EMP_ID"='DO190211' )
15 - access("P"."EMP_ID"="H"."EMP_ID")
filter(("P"."EMP_ID"='DO190057' OR "P"."EMP_ID"='DO190058' OR "P"."EMP_ID"='DO190059' OR
"P"."EMP_ID"='DO190060' OR "P"."EMP_ID"='DO190061' OR "P"."EMP_ID"='DO190062' OR "P"."EMP_ID"='DO190063' OR
"P"."EMP_ID"='DO190064' OR "P"."EMP_ID"='DO190065' OR "P"."EMP_ID"='DO190066' OR "P"."EMP_ID"='DO190067' OR
"P"."EMP_ID"='DO190068' OR "P"."EMP_ID"='DO190070' OR "P"."EMP_ID"='DO190071' OR "P"."EMP_ID"='DO190072' OR
"P"."EMP_ID"='DO190073' OR "P"."EMP_ID"='DO190074' OR "P"."EMP_ID"='DO190075' OR "P"."EMP_ID"='DO190076' OR
"P"."EMP_ID"='DO190077' OR "P"."EMP_ID"='DO190078' OR "P"."EMP_ID"='DO190079' OR "P"."EMP_ID"='DO190080' OR
"P"."EMP_ID"='DO190081' OR "P"."EMP_ID"='DO190082' OR "P"."EMP_ID"='DO190083' OR "P"."EMP_ID"='DO190084' OR
"P"."EMP_ID"='DO190085' OR "P"."EMP_ID"='DO190086' OR "P"."EMP_ID"='DO190087' OR "P"."EMP_ID"='DO190088' OR
"P"."EMP_ID"='DO190089' OR "P"."EMP_ID"='DO190090' OR "P"."EMP_ID"='DO190091' OR "P"."EMP_ID"='DO190092' OR
"P"."EMP_ID"='DO190093' OR "P"."EMP_ID"='DO190094' OR "P"."EMP_ID"='DO190095' OR "P"."EMP_ID"='DO190096' OR
"P"."EMP_ID"='DO190097' OR "P"."EMP_ID"='DO190098' OR "P"."EMP_ID"='DO190099' OR "P"."EMP_ID"='DO190100' OR
"P"."EMP_ID"='DO190101' OR "P"."EMP_ID"='DO190102' OR "P"."EMP_ID"='DO190103' OR "P"."EMP_ID"='DO190104' OR
"P"."EMP_ID"='DO190105' OR "P"."EMP_ID"='DO190106' OR "P"."EMP_ID"='DO190107' OR "P"."EMP_ID"='DO190108' OR
"P"."EMP_ID"='DO190109' OR "P"."EMP_ID"='DO190110' OR "P"."EMP_ID"='DO190111' OR "P"."EMP_ID"='DO190112' OR
"P"."EMP_ID"='DO190113' OR "P"."EMP_ID"='DO190114' OR "P"."EMP_ID"='DO190115' OR "P"."EMP_ID"='DO190116' OR
"P"."EMP_ID"='DO190117' OR "P"."EMP_ID"='DO190118' OR "P"."EMP_ID"='DO190119' OR "P"."EMP_ID"='DO190120' OR
"P"."EMP_ID"='DO190121' OR "P"."EMP_ID"='DO190122' OR "P"."EMP_ID"='DO190123' OR "P"."EMP_ID"='DO190124' OR
"P"."EMP_ID"='DO190125' OR "P"."EMP_ID"='DO190126' OR "P"."EMP_ID"='DO190127' OR "P"."EMP_ID"='DO190128' OR
"P"."EMP_ID"='DO190129' OR "P"."EMP_ID"='DO190130' OR "P"."EMP_ID"='DO190131' OR "P"."EMP_ID"='DO190132' OR
"P"."EMP_ID"='DO190133' OR "P"."EMP_ID"='DO190135' OR "P"."EMP_ID"='DO190136' OR "P"."EMP_ID"='DO190137' OR
"P"."EMP_ID"='DO190138' OR "P"."EMP_ID"='DO190139' OR "P"."EMP_ID"='DO190141' OR "P"."EMP_ID"='DO190142' OR
"P"."EMP_ID"='DO190143' OR "P"."EMP_ID"='DO190144' OR "P"."EMP_ID"='DO190145' OR "P"."EMP_ID"='DO190146' OR
"P"."EMP_ID"='DO190147' OR "P"."EMP_ID"='DO190148' OR "P"."EMP_ID"='DO190149' OR "P"."EMP_ID"='DO190150' OR
"P"."EMP_ID"='DO190151' OR "P"."EMP_ID"='DO190152' OR "P"."EMP_ID"='DO190153' OR "P"."EMP_ID"='DO190154' OR
"P"."EMP_ID"='DO190155' OR "P"."EMP_ID"='DO190156' OR "P"."EMP_ID"='DO190157' OR "P"."EMP_ID"='DO190158' OR
"P"."EMP_ID"='DO190159' OR "P"."EMP_ID"='DO190160' OR "P"."EMP_ID"='DO190161' OR "P"."EMP_ID"='DO190162' OR
"P"."EMP_ID"='DO190163' OR "P"."EMP_ID"='DO190164' OR "P"."EMP_ID"='DO190165' OR "P"."EMP_ID"='DO190166' OR
"P"."EMP_ID"='DO190167' OR "P"."EMP_ID"='DO190168' OR "P"."EMP_ID"='DO190169' OR "P"."EMP_ID"='DO190171' OR
"P"."EMP_ID"='DO190172' OR "P"."EMP_ID"='DO190173' OR "P"."EMP_ID"='DO190174' OR "P"."EMP_ID"='DO190175' OR
"P"."EMP_ID"='DO190176' OR "P"."EMP_ID"='DO190177' OR "P"."EMP_ID"='DO190179' OR "P"."EMP_ID"='DO190180' OR
"P"."EMP_ID"='DO190181' OR "P"."EMP_ID"='DO190182' OR "P"."EMP_ID"='DO190183' OR "P"."EMP_ID"='DO190184' OR
"P"."EMP_ID"='DO190186' OR "P"."EMP_ID"='DO190187' OR "P"."EMP_ID"='DO190188' OR "P"."EMP_ID"='DO190189' OR
"P"."EMP_ID"='DO190190' OR "P"."EMP_ID"='DO190191' OR "P"."EMP_ID"='DO190192' OR "P"."EMP_ID"='DO190193' OR
"P"."EMP_ID"='DO190194' OR "P"."EMP_ID"='DO190195' OR "P"."EMP_ID"='DO190196' OR "P"."EMP_ID"='DO190197' OR
"P"."EMP_ID"='DO190198' OR "P"."EMP_ID"='DO190199' OR "P"."EMP_ID"='DO190200' OR "P"."EMP_ID"='DO190201' OR
"P"."EMP_ID"='DO190203' OR "P"."EMP_ID"='DO190205' OR "P"."EMP_ID"='DO190206' OR "P"."EMP_ID"='DO190207' OR
"P"."EMP_ID"='DO190208' OR "P"."EMP_ID"='DO190209' OR "P"."EMP_ID"='DO190210' OR "P"."EMP_ID"='DO190211' OR
"P"."EMP_ID"='DO190212' OR "P)
16 - access("P"."EMP_ID"="C"."EMP_ID" AND "C"."COMPANY_ID"=18898)
filter(("C"."EMP_ID"='DO190057' OR "C"."EMP_ID"='DO190058' OR "C"."EMP_ID"='DO190059' OR
"C"."EMP_ID"='DO190060' OR "C"."EMP_ID"='DO190061' OR "C"."EMP_ID"='DO190062' OR "C"."EMP_ID"='DO190063' OR
"C"."EMP_ID"='DO190064' OR "C"."EMP_ID"='DO190065' OR "C"."EMP_ID"='DO190066' OR "C"."EMP_ID"='DO190067' OR
"C"."EMP_ID"='DO190068' OR "C"."EMP_ID"='DO190070' OR "C"."EMP_ID"='DO190071' OR "C"."EMP_ID"='DO190072' OR
"C"."EMP_ID"='DO190073' OR "C"."EMP_ID"='DO190074' OR "C"."EMP_ID"='DO190075' OR "C"."EMP_ID"='DO190076' OR
"C"."EMP_ID"='DO190077' OR "C"."EMP_ID"='DO190078' OR "C"."EMP_ID"='DO190079' OR "C"."EMP_ID"='DO190080' OR
"C"."EMP_ID"='DO190081' OR "C"."EMP_ID"='DO190082' OR "C"."EMP_ID"='DO190083' OR "C"."EMP_ID"='DO190084' OR
"C"."EMP_ID"='DO190085' OR "C"."EMP_ID"='DO190086' OR "C"."EMP_ID"='DO190087' OR "C"."EMP_ID"='DO190088' OR
"C"."EMP_ID"='DO190089' OR "C"."EMP_ID"='DO190090' OR "C"."EMP_ID"='DO190091' OR "C"."EMP_ID"='DO190092' OR
"C"."EMP_ID"='DO190093' OR "C"."EMP_ID"='DO190094' OR "C"."EMP_ID"='DO190095' OR "C"."EMP_ID"='DO190096' OR
"C"."EMP_ID"='DO190097' OR "C"."EMP_ID"='DO190098' OR "C"."EMP_ID"='DO190099' OR "C"."EMP_ID"='DO190100' OR
"C"."EMP_ID"='DO190101' OR "C"."EMP_ID"='DO190102' OR "C"."EMP_ID"='DO190103' OR "C"."EMP_ID"='DO190104' OR
"C"."EMP_ID"='DO190105' OR "C"."EMP_ID"='DO190106' OR "C"."EMP_ID"='DO190107' OR "C"."EMP_ID"='DO190108' OR
"C"."EMP_ID"='DO190109' OR "C"."EMP_ID"='DO190110' OR "C"."EMP_ID"='DO190111' OR "C"."EMP_ID"='DO190112' OR
"C"."EMP_ID"='DO190113' OR "C"."EMP_ID"='DO190114' OR "C"."EMP_ID"='DO190115' OR "C"."EMP_ID"='DO190116' OR
"C"."EMP_ID"='DO190117' OR "C"."EMP_ID"='DO190118' OR "C"."EMP_ID"='DO190119' OR "C"."EMP_ID"='DO190120' OR
"C"."EMP_ID"='DO190121' OR "C"."EMP_ID"='DO190122' OR "C"."EMP_ID"='DO190123' OR "C"."EMP_ID"='DO190124' OR
"C"."EMP_ID"='DO190125' OR "C"."EMP_ID"='DO190126' OR "C"."EMP_ID"='DO190127' OR "C"."EMP_ID"='DO190128' OR
"C"."EMP_ID"='DO190129' OR "C"."EMP_ID"='DO190130' OR "C"."EMP_ID"='DO190131' OR "C"."EMP_ID"='DO190132' OR
"C"."EMP_ID"='DO190133' OR "C"."EMP_ID"='DO190135' OR "C"."EMP_ID"='DO190136' OR "C"."EMP_ID"='DO190137' OR
"C"."EMP_ID"='DO190138' OR "C"."EMP_ID"='DO190139' OR "C"."EMP_ID"='DO190141' OR "C"."EMP_ID"='DO190142' OR
"C"."EMP_ID"='DO190143' OR "C"."EMP_ID"='DO190144' OR "C"."EMP_ID"='DO190145' OR "C"."EMP_ID"='DO190146' OR
"C"."EMP_ID"='DO190147' OR "C"."EMP_ID"='DO190148' OR "C"."EMP_ID"='DO190149' OR "C"."EMP_ID"='DO190150' OR
"C"."EMP_ID"='DO190151' OR "C"."EMP_ID"='DO190152' OR "C"."EMP_ID"='DO190153' OR "C"."EMP_ID"='DO190154' OR
"C"."EMP_ID"='DO190155' OR "C"."EMP_ID"='DO190156' OR "C"."EMP_ID"='DO190157' OR "C"."EMP_ID"='DO190158' OR
"C"."EMP_ID"='DO190159' OR "C"."EMP_ID"='DO190160' OR "C"."EMP_ID"='DO190161' OR "C"."EMP_ID"='DO190162' OR
"C"."EMP_ID"='DO190163' OR "C"."EMP_ID"='DO190164' OR "C"."EMP_ID"='DO190165' OR "C"."EMP_ID"='DO190166' OR
"C"."EMP_ID"='DO190167' OR "C"."EMP_ID"='DO190168' OR "C"."EMP_ID"='DO190169' OR "C"."EMP_ID"='DO190171' OR
"C"."EMP_ID"='DO190172' OR "C"."EMP_ID"='DO190173' OR "C"."EMP_ID"='DO190174' OR "C"."EMP_ID"='DO190175' OR
"C"."EMP_ID"='DO190176' OR "C"."EMP_ID"='DO190177' OR "C"."EMP_ID"='DO190179' OR "C"."EMP_ID"='DO190180' OR
"C"."EMP_ID"='DO190181' OR "C"."EMP_ID"='DO190182' OR "C"."EMP_ID"='DO190183' OR "C"."EMP_ID"='DO190184' OR
"C"."EMP_ID"='DO190186' OR "C"."EMP_ID"='DO190187' OR "C"."EMP_ID"='DO190188' OR "C"."EMP_ID"='DO190189' OR
"C"."EMP_ID"='DO190190' OR "C"."EMP_ID"='DO190191' OR "C"."EMP_ID"='DO190192' OR "C"."EMP_ID"='DO190193' OR
"C"."EMP_ID"='DO190194' OR "C"."EMP_ID"='DO190195' OR "C"."EMP_ID"='DO190196' OR "C"."EMP_ID"='DO190197' OR
"C"."EMP_ID"='DO190198' OR "C"."EMP_ID"='DO190199' OR "C"."EMP_ID"='DO190200' OR "C"."EMP_ID"='DO190201' OR
"C"."EMP_ID"='DO190203' OR "C"."EMP_ID"='DO190205' OR "C"."EMP_ID"='DO190206' OR "C"."EMP_ID"='DO190207' OR
"C"."EMP_ID"='DO190208' OR "C"."EMP_ID"='DO190209' OR "C"."EMP_ID"='DO190210' OR "C"."EMP_ID"='DO190211' OR
"C"."EMP_ID"='DO190212' OR "C)
17 - filter("C"."END_DATE" IS NULL OR SYSDATE@!+1>=SYSDATE@!)
22 - access("ATT"."SHIFTSTARTTIME"<=SYSDATE@!+NVL("SHIFT"."GRACE_EAI",240)/1440)
filter(INTERNAL_FUNCTION("ATT"."SHIFTENDTIME")+NVL("SHIFT"."GRACE_LTO",660)/1440>='2020-10-26
08:04:12')
23 - filter("SHIFT"."SHIFTDAILYCODE"="ATT"."SHIFTDAILY_CODE" AND ("ATT"."EMP_ID"='DO190057' OR
"ATT"."EMP_ID"='DO190058' OR "ATT"."EMP_ID"='DO190059' OR "ATT"."EMP_ID"='DO190060' OR
"ATT"."EMP_ID"='DO190061' OR "ATT"."EMP_ID"='DO190062' OR "ATT"."EMP_ID"='DO190063' OR
"ATT"."EMP_ID"='DO190064' OR "ATT"."EMP_ID"='DO190065' OR "ATT"."EMP_ID"='DO190066' OR
"ATT"."EMP_ID"='DO190067' OR "ATT"."EMP_ID"='DO190068' OR "ATT"."EMP_ID"='DO190070' OR
"ATT"."EMP_ID"='DO190071' OR "ATT"."EMP_ID"='DO190072' OR "ATT"."EMP_ID"='DO190073' OR
"ATT"."EMP_ID"='DO190074' OR "ATT"."EMP_ID"='DO190075' OR "ATT"."EMP_ID"='DO190076' OR
"ATT"."EMP_ID"='DO190077' OR "ATT"."EMP_ID"='DO190078' OR "ATT"."EMP_ID"='DO190079' OR
"ATT"."EMP_ID"='DO190080' OR "ATT"."EMP_ID"='DO190081' OR "ATT"."EMP_ID"='DO190082' OR
"ATT"."EMP_ID"='DO190083' OR "ATT"."EMP_ID"='DO190084' OR "ATT"."EMP_ID"='DO190085' OR
"ATT"."EMP_ID"='DO190086' OR "ATT"."EMP_ID"='DO190087' OR "ATT"."EMP_ID"='DO190088' OR
"ATT"."EMP_ID"='DO190089' OR "ATT"."EMP_ID"='DO190090' OR "ATT"."EMP_ID"='DO190091' OR
"ATT"."EMP_ID"='DO190092' OR "ATT"."EMP_ID"='DO190093' OR "ATT"."EMP_ID"='DO190094' OR
"ATT"."EMP_ID"='DO190095' OR "ATT"."EMP_ID"='DO190096' OR "ATT"."EMP_ID"='DO190097' OR
"ATT"."EMP_ID"='DO190098' OR "ATT"."EMP_ID"='DO190099' OR "ATT"."EMP_ID"='DO190100' OR
"ATT"."EMP_ID"='DO190101' OR "ATT"."EMP_ID"='DO190102' OR "ATT"."EMP_ID"='DO190103' OR
"ATT"."EMP_ID"='DO190104' OR "ATT"."EMP_ID"='DO190105' OR "ATT"."EMP_ID"='DO190106' OR
"ATT"."EMP_ID"='DO190107' OR "ATT"."EMP_ID"='DO190108' OR "ATT"."EMP_ID"='DO190109' OR
"ATT"."EMP_ID"='DO190110' OR "ATT"."EMP_ID"='DO190111' OR "ATT"."EMP_ID"='DO190112' OR
"ATT"."EMP_ID"='DO190113' OR "ATT"."EMP_ID"='DO190114' OR "ATT"."EMP_ID"='DO190115' OR
"ATT"."EMP_ID"='DO190116' OR "ATT"."EMP_ID"='DO190117' OR "ATT"."EMP_ID"='DO190118' OR
"ATT"."EMP_ID"='DO190119' OR "ATT"."EMP_ID"='DO190120' OR "ATT"."EMP_ID"='DO190121' OR
"ATT"."EMP_ID"='DO190122' OR "ATT"."EMP_ID"='DO190123' OR "ATT"."EMP_ID"='DO190124' OR
"ATT"."EMP_ID"='DO190125' OR "ATT"."EMP_ID"='DO190126' OR "ATT"."EMP_ID"='DO190127' OR
"ATT"."EMP_ID"='DO190128' OR "ATT"."EMP_ID"='DO190129' OR "ATT"."EMP_ID"='DO190130' OR
"ATT"."EMP_ID"='DO190131' OR "ATT"."EMP_ID"='DO190132' OR "ATT"."EMP_ID"='DO190133' OR
"ATT"."EMP_ID"='DO190135' OR "ATT"."EMP_ID"='DO190136' OR "ATT"."EMP_ID"='DO190137' OR
"ATT"."EMP_ID"='DO190138' OR "ATT"."EMP_ID"='DO190139' OR "ATT"."EMP_ID"='DO190141' OR
"ATT"."EMP_ID"='DO190142' OR "ATT"."EMP_ID"='DO190143' OR "ATT"."EMP_ID"='DO190144' OR
"ATT"."EMP_ID"='DO190145' OR "ATT"."EMP_ID"='DO190146' OR "ATT"."EMP_ID"='DO190147' OR
"ATT"."EMP_ID"='DO190148' OR "ATT"."EMP_ID"='DO190149' OR "ATT"."EMP_ID"='DO190150' OR
"ATT"."EMP_ID"='DO190151' OR "ATT"."EMP_ID"='DO190152' OR "ATT"."EMP_ID"='DO190153' OR
"ATT"."EMP_ID"='DO190154' OR "ATT"."EMP_ID"='DO190155' OR "ATT"."EMP_ID"='DO190156' OR
"ATT"."EMP_ID"='DO190157' OR "ATT"."EMP_ID"='DO190158' OR "ATT"."EMP_ID"='DO190159' OR
"ATT"."EMP_ID"='DO190160' OR "ATT"."EMP_ID"='DO190161' OR "ATT"."EMP_ID"='DO190162' OR
"ATT"."EMP_ID"='DO190163' OR "ATT"."EMP_ID"='DO190164' OR "ATT"."EMP_ID"='DO190165' OR
"ATT"."EMP_ID"='DO190166' OR "ATT"."EMP_ID"='DO190167' OR "ATT"."EMP_ID"='DO190168' OR
"ATT"."EMP_ID"='DO190169' OR "ATT"."EMP_ID"='DO190171' OR "ATT"."EMP_ID"='DO190172' OR
"ATT"."EMP_ID"='DO190173' OR "ATT"."EMP_ID"='DO190174' OR "ATT"."EMP_ID"='DO190175' OR
"ATT"."EMP_ID"='DO190176' OR "ATT"."EMP_ID"='DO190177' OR "ATT"."EMP_ID"='DO190179' OR
"ATT"."EMP_ID"='DO190180' OR "ATT"."EMP_ID"='DO190181' OR "ATT"."EMP_ID"='DO190182' OR
"ATT"."EMP_ID"='DO190183' OR "ATT"."EMP_ID"='DO190184' OR "ATT"."EMP_ID"='DO190186' OR
"ATT"."EMP_ID"='DO190187' OR "ATT"."EMP_ID"='DO190188' OR "ATT"."EMP_ID"='DO190189' OR
"ATT"."EMP_ID"='DO190190' OR "ATT"."EMP_ID"='DO190191' OR "ATT"."EMP_ID"='DO190192' OR
"ATT"."EMP_ID"='DO190193' OR "ATT"."EMP_ID"='DO190194' OR "ATT"."EMP_ID"='DO190195' OR
"ATT"."EMP_ID"='DO190196' OR "ATT"."EMP_ID"='DO190197' OR "ATT"."EMP_ID"='DO190198' OR ")
24 - access("PS"."EMP_ID"="P"."EMP_ID")
filter(("PS"."EMP_ID"='DO190057' OR "PS"."EMP_ID"='DO190058' OR "PS"."EMP_ID"='DO190059' OR
"PS"."EMP_ID"='DO190060' OR "PS"."EMP_ID"='DO190061' OR "PS"."EMP_ID"='DO190062' OR "PS"."EMP_ID"='DO190063'
OR "PS"."EMP_ID"='DO190064' OR "PS"."EMP_ID"='DO190065' OR "PS"."EMP_ID"='DO190066' OR
"PS"."EMP_ID"='DO190067' OR "PS"."EMP_ID"='DO190068' OR "PS"."EMP_ID"='DO190070' OR "PS"."EMP_ID"='DO190071'
OR "PS"."EMP_ID"='DO190072' OR "PS"."EMP_ID"='DO190073' OR "PS"."EMP_ID"='DO190074' OR
"PS"."EMP_ID"='DO190075' OR "PS"."EMP_ID"='DO190076' OR "PS"."EMP_ID"='DO190077' OR "PS"."EMP_ID"='DO190078'
OR "PS"."EMP_ID"='DO190079' OR "PS"."EMP_ID"='DO190080' OR "PS"."EMP_ID"='DO190081' OR
"PS"."EMP_ID"='DO190082' OR "PS"."EMP_ID"='DO190083' OR "PS"."EMP_ID"='DO190084' OR "PS"."EMP_ID"='DO190085'
OR "PS"."EMP_ID"='DO190086' OR "PS"."EMP_ID"='DO190087' OR "PS"."EMP_ID"='DO190088' OR
"PS"."EMP_ID"='DO190089' OR "PS"."EMP_ID"='DO190090' OR "PS"."EMP_ID"='DO190091' OR "PS"."EMP_ID"='DO190092'
OR "PS"."EMP_ID"='DO190093' OR "PS"."EMP_ID"='DO190094' OR "PS"."EMP_ID"='DO190095' OR
"PS"."EMP_ID"='DO190096' OR "PS"."EMP_ID"='DO190097' OR "PS"."EMP_ID"='DO190098' OR "PS"."EMP_ID"='DO190099'
OR "PS"."EMP_ID"='DO190100' OR "PS"."EMP_ID"='DO190101' OR "PS"."EMP_ID"='DO190102' OR
"PS"."EMP_ID"='DO190103' OR "PS"."EMP_ID"='DO190104' OR "PS"."EMP_ID"='DO190105' OR "PS"."EMP_ID"='DO190106'
OR "PS"."EMP_ID"='DO190107' OR "PS"."EMP_ID"='DO190108' OR "PS"."EMP_ID"='DO190109' OR
"PS"."EMP_ID"='DO190110' OR "PS"."EMP_ID"='DO190111' OR "PS"."EMP_ID"='DO190112' OR "PS"."EMP_ID"='DO190113'
OR "PS"."EMP_ID"='DO190114' OR "PS"."EMP_ID"='DO190115' OR "PS"."EMP_ID"='DO190116' OR
"PS"."EMP_ID"='DO190117' OR "PS"."EMP_ID"='DO190118' OR "PS"."EMP_ID"='DO190119' OR "PS"."EMP_ID"='DO190120'
OR "PS"."EMP_ID"='DO190121' OR "PS"."EMP_ID"='DO190122' OR "PS"."EMP_ID"='DO190123' OR
"PS"."EMP_ID"='DO190124' OR "PS"."EMP_ID"='DO190125' OR "PS"."EMP_ID"='DO190126' OR "PS"."EMP_ID"='DO190127'
OR "PS"."EMP_ID"='DO190128' OR "PS"."EMP_ID"='DO190129' OR "PS"."EMP_ID"='DO190130' OR
"PS"."EMP_ID"='DO190131' OR "PS"."EMP_ID"='DO190132' OR "PS"."EMP_ID"='DO190133' OR "PS"."EMP_ID"='DO190135'
OR "PS"."EMP_ID"='DO190136' OR "PS"."EMP_ID"='DO190137' OR "PS"."EMP_ID"='DO190138' OR
"PS"."EMP_ID"='DO190139' OR "PS"."EMP_ID"='DO190141' OR "PS"."EMP_ID"='DO190142' OR "PS"."EMP_ID"='DO190143'
OR "PS"."EMP_ID"='DO190144' OR "PS"."EMP_ID"='DO190145' OR "PS"."EMP_ID"='DO190146' OR
"PS"."EMP_ID"='DO190147' OR "PS"."EMP_ID"='DO190148' OR "PS"."EMP_ID"='DO190149' OR "PS"."EMP_ID"='DO190150'
OR "PS"."EMP_ID"='DO190151' OR "PS"."EMP_ID"='DO190152' OR "PS"."EMP_ID"='DO190153' OR
"PS"."EMP_ID"='DO190154' OR "PS"."EMP_ID"='DO190155' OR "PS"."EMP_ID"='DO190156' OR "PS"."EMP_ID"='DO190157'
OR "PS"."EMP_ID"='DO190158' OR "PS"."EMP_ID"='DO190159' OR "PS"."EMP_ID"='DO190160' OR
"PS"."EMP_ID"='DO190161' OR "PS"."EMP_ID"='DO190162' OR "PS"."EMP_ID"='DO190163' OR "PS"."EMP_ID"='DO190164'
OR "PS"."EMP_ID"='DO190165' OR "PS"."EMP_ID"='DO190166' OR "PS"."EMP_ID"='DO190167' OR
"PS"."EMP_ID"='DO190168' OR "PS"."EMP_ID"='DO190169' OR "PS"."EMP_ID"='DO190171' OR "PS"."EMP_ID"='DO190172'
OR "PS"."EMP_ID"='DO190173' OR "PS"."EMP_ID"='DO190174' OR "PS"."EMP_ID"='DO190175' OR
"PS"."EMP_ID"='DO190176' OR "PS"."EMP_ID"='DO190177' OR "PS"."EMP_ID"='DO190179' OR "PS"."EMP_ID"='DO190180'
OR "PS"."EMP_ID"='DO190181' OR "PS"."EMP_ID"='DO190182' OR "PS"."EMP_ID"='DO190183' OR
"PS"."EMP_ID"='DO190184' OR "PS"."EMP_ID"='DO190186' OR "PS"."EMP_ID"='DO190187' OR "PS"."EMP_ID"='DO190188'
OR "PS"."EMP_ID"='DO190189' OR "PS"."EMP_ID"='DO190190' OR "PS"."EMP_ID"='DO190191' OR
"PS"."EMP_ID"='DO190192' OR "PS"."EMP_ID"='DO190193' OR "PS"."EMP_ID"='DO190194' OR "PS"."EMP_ID"='DO190195'
OR "PS"."EMP_ID"='DO190196' OR "PS"."EMP_ID"='DO190197' OR "PS"."EMP_ID"='DO190198' OR
"PS"."EMP_ID"='DO190199' OR "PS"."EMP_ID"='DO190200' OR "PS"."EMP_ID"='DO190201' OR "PS"."EMP_ID"='DO190203'
OR "PS"."EMP_ID"='DO190205' OR "PS"."EMP_ID"='DO190206' OR "PS"."EMP_ID"='DO19020)
26 - access("U"."USER_ID"="P"."USER_ID")
28 - access("C"."POSITION_ID"="T"."POSITION_ID"(+))
30 - access("ttdttsttsdtls"."ATTEND_ID"(+)="viewAttendance"."ATTEND_ID" AND
"ttdttsttsdtls"."COMPANY_ID"(+)=18898)
filter("ttdttsttsdtls"."ATTEND_CODE"(+)='ANL' OR "ttdttsttsdtls"."ATTEND_CODE"(+)='CAP_DDR' OR
"ttdttsttsdtls"."ATTEND_CODE"(+)='CAP_KBA' OR "ttdttsttsdtls"."ATTEND_CODE"(+)='CAP_KIM' OR
"ttdttsttsdtls"."ATTEND_CODE"(+)='CAP_KISK' OR "ttdttsttsdtls"."ATTEND_CODE"(+)='CAP_MP' OR
"ttdttsttsdtls"."ATTEND_CODE"(+)='CAP_MSC' OR "ttdttsttsdtls"."ATTEND_CODE"(+)='FCM' OR
"ttdttsttsdtls"."ATTEND_CODE"(+)='LOL' OR "ttdttsttsdtls"."ATTEND_CODE"(+)='MAT' OR
"ttdttsttsdtls"."ATTEND_CODE"(+)='OFF' OR "ttdttsttsdtls"."ATTEND_CODE"(+)='OVT_MEAL_HD' OR
"ttdttsttsdtls"."ATTEND_CODE"(+)='OVT_MEAL_WD' OR "ttdttsttsdtls"."ATTEND_CODE"(+)='PFP' OR
"ttdttsttsdtls"."ATTEND_CODE"(+)='PIL' OR "ttdttsttsdtls"."ATTEND_CODE"(+)='PL' OR
"ttdttsttsdtls"."ATTEND_CODE"(+)='PNI' OR "ttdttsttsdtls"."ATTEND_CODE"(+)='SDC' OR
"ttdttsttsdtls"."ATTEND_CODE"(+)='SWC' OR "ttdttsttsdtls"."ATTEND_CODE"(+)='TOTAL_MENIT_LTI' OR
"ttdttsttsdtls"."ATTEND_CODE"(+)='TRANSPORT_LEMBUR' OR "ttdttsttsdtls"."ATTEND_CODE"(+)='VLD')
32 - access("ttamattstatus"."ATTEND_CODE"(+)="ttdttsttsdtls"."ATTEND_CODE")
Note
-----
- this is an adaptive plan
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment