--------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| --------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 90 | 14 (15)| | 1 | HASH GROUP BY | | 1 | 90 | 14 (15)| | 2 | NESTED LOOPS | | 1 | 90 | 13 (8)| | 3 | NESTED LOOPS | | 1 | 79 | 11 (10)| | 4 | NESTED LOOPS | | 1 | 60 | 8 (13)| | 5 | SORT UNIQUE | | 1 | 22 | 4 (0)| |* 6 | INDEX RANGE SCAN | PK_PRJ_TIMELOG_STAGE | 1 | 22 | 4 (0)| |* 7 | TABLE ACCESS BY INDEX ROWID| PROJECTTIMELOGSSTAGE | 1 | 38 | 4 (0)| |* 8 | INDEX RANGE SCAN | TEMP003 | 1 | | 3 (0)| |* 9 | TABLE ACCESS BY INDEX ROWID | PROJECTTIMESHEETITEM | 1 | 19 | 3 (0)| |* 10 | INDEX RANGE SCAN | PROJTSI_IDX3 | 1 | | 2 (0)| |* 11 | INDEX RANGE SCAN | TIMESHEET_IDX2 | 1 | 11 | 2 (0)| --------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 6 - access("PTLS1"."TIMESHEETID"=TO_NUMBER(:B3) AND "PTLS1"."PROJECTID"=TO_NUMBER(:B2)) filter("ITEMTYPE"<>'OtherTsk' AND "ITEMTYPE"<>'NewTsk' AND "ITEMTYPE"<>'Loc' AND "ITEMTYPE"<>'Glb') 7 - filter("PTLS"."PROJECTID"=TO_NUMBER(:B2)) 8 - access("PTLS"."ITEMTYPE"="ITEMTYPE" AND "PTLS"."ITEMID"="ITEMID") filter("PTLS"."ITEMTYPE"<>'OtherTsk' AND "PTLS"."ITEMTYPE"<>'NewTsk' AND "PTLS"."ITEMTYPE"<>'Loc' AND "PTLS"."ITEMTYPE"<>'Glb') 9 - filter(("PTSI"."ISPWFITEM"='N' OR "PTSI"."ISPWFITEM" IS NULL) AND "PTSI"."TIMESHEETID"="PTLS"."TIMESHEETID") 10 - access("PTSI"."ITEMTYPE"="PTLS"."ITEMTYPE" AND "PTSI"."ITEMID"="PTLS"."ITEMID") filter("PTSI"."ITEMTYPE"<>'OtherTsk' AND "PTSI"."ITEMTYPE"<>'NewTsk' AND "PTSI"."ITEMTYPE"<>'Loc' AND "PTSI"."ITEMTYPE"<>'Glb') 11 - access("TS"."USERID"=TO_NUMBER(:B1) AND "TS"."TIMESHEETID"="PTSI"."TIMESHEETID")