Plan hash value: 2737311892 ----------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ----------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 3976 | 96 (9)| 00:00:02 | | 1 | NESTED LOOPS OUTER | | 1 | 3976 | 96 (9)| 00:00:02 | | 2 | NESTED LOOPS OUTER | | 1 | 3636 | 19 (0)| 00:00:01 | | 3 | NESTED LOOPS | | 1 | 219 | 10 (0)| 00:00:01 | | 4 | NESTED LOOPS | | 1 | 130 | 6 (0)| 00:00:01 | | 5 | NESTED LOOPS | | 1 | 110 | 5 (0)| 00:00:01 | | 6 | TABLE ACCESS BY INDEX ROWID | FAX_HEADER | 1 | 102 | 4 (0)| 00:00:01 | |* 7 | INDEX RANGE SCAN | FAX_HEADER_IDX4 | 1 | | 3 (0)| 00:00:01 | | 8 | TABLE ACCESS BY INDEX ROWID | FAX_SOURCE | 1 | 8 | 1 (0)| 00:00:01 | |* 9 | INDEX UNIQUE SCAN | PK_FAX_SOURCE | 1 | | 0 (0)| 00:00:01 | | 10 | TABLE ACCESS BY INDEX ROWID | GLOBAL_BU_MAPPING | 1 | 20 | 1 (0)| 00:00:01 | |* 11 | INDEX RANGE SCAN | GLOBAL_BU_MAPPING_BUID | 1 | | 0 (0)| 00:00:01 | | 12 | TABLE ACCESS BY INDEX ROWID | FAX_OFFER_DETAIL | 1 | 89 | 4 (0)| 00:00:01 | |* 13 | INDEX RANGE SCAN | FAX_OFFER_DETAIL_IDX1 | 1 | | 2 (0)| 00:00:01 | | 14 | VIEW PUSHED PREDICATE | FAX_LAST_TRANSITION_V | 1 | 3417 | 9 (0)| 00:00:01 | | 15 | NESTED LOOPS | | 1 | 199 | 9 (0)| 00:00:01 | | 16 | NESTED LOOPS | | 1 | 168 | 8 (0)| 00:00:01 | | 17 | NESTED LOOPS | | 1 | 137 | 7 (0)| 00:00:01 | | 18 | NESTED LOOPS | | 1 | 124 | 6 (0)| 00:00:01 | | 19 | NESTED LOOPS | | 1 | 73 | 5 (0)| 00:00:01 | | 20 | TABLE ACCESS BY INDEX ROWID | FAX_HEADER | 1 | 12 | 3 (0)| 00:00:01 | |* 21 | INDEX UNIQUE SCAN | PK_FAX_HEADER | 1 | | 2 (0)| 00:00:01 | | 22 | TABLE ACCESS BY INDEX ROWID | FAX_TRANSITION_HISTORY | 3019K| 175M| 2 (0)| 00:00:01 | |* 23 | INDEX UNIQUE SCAN | PK_FAX_TRANSITION_HISTORY | 1 | | 1 (0)| 00:00:01 | | 24 | TABLE ACCESS BY INDEX ROWID | WORKGROUP_TRANSITION_REASON | 10754 | 535K| 1 (0)| 00:00:01 | |* 25 | INDEX UNIQUE SCAN | PK_WORKGROUP_TRANSITION_REASON | 1 | | 0 (0)| 00:00:01 | | 26 | TABLE ACCESS BY INDEX ROWID | WORKGROUP_TRANSITION | 6193 | 80509 | 1 (0)| 00:00:01 | |* 27 | INDEX UNIQUE SCAN | PK_WORKGROUP_TRANSITION | 1 | | 0 (0)| 00:00:01 | | 28 | TABLE ACCESS BY INDEX ROWID | WORKGROUP | 1388 | 43028 | 1 (0)| 00:00:01 | |* 29 | INDEX UNIQUE SCAN | PK_WORKGROUP | 1 | | 0 (0)| 00:00:01 | | 30 | TABLE ACCESS BY INDEX ROWID | WORKGROUP | 1388 | 43028 | 1 (0)| 00:00:01 | |* 31 | INDEX UNIQUE SCAN | PK_WORKGROUP | 1 | | 0 (0)| 00:00:01 | | 32 | VIEW | SALESPERSON_V | 1 | 340 | 77 (11)| 00:00:01 | | 33 | UNION ALL PUSHED PREDICATE | | | | | | | 34 | SORT UNIQUE | | 1 | 178 | 10 (10)| 00:00:01 | | 35 | NESTED LOOPS OUTER | | 1 | 178 | 9 (0)| 00:00:01 | | 36 | NESTED LOOPS | | 1 | 170 | 8 (0)| 00:00:01 | | 37 | NESTED LOOPS | | 1 | 143 | 7 (0)| 00:00:01 | | 38 | NESTED LOOPS | | 1 | 114 | 6 (0)| 00:00:01 | | 39 | NESTED LOOPS | | 1 | 98 | 5 (0)| 00:00:01 | |* 40 | TABLE ACCESS BY INDEX ROWID| GEDIS_SALESPERSON | 1 | 72 | 3 (0)| 00:00:01 | |* 41 | INDEX RANGE SCAN | GEDIS_SALESPERSON_N1 | 3 | | 1 (0)| 00:00:01 | |* 42 | TABLE ACCESS BY INDEX ROWID| GEDIS_USER_LINK | 1 | 26 | 2 (0)| 00:00:01 | |* 43 | INDEX RANGE SCAN | GEDIS_USER_LINK_PK | 1 | | 1 (0)| 00:00:01 | |* 44 | TABLE ACCESS BY INDEX ROWID | GEDIS_USER_ROLE | 1 | 16 | 1 (0)| 00:00:01 | |* 45 | INDEX UNIQUE SCAN | GEDIS_USER_ROLE_PK | 1 | | 0 (0)| 00:00:01 | |* 46 | TABLE ACCESS BY INDEX ROWID | GEDIS_RESPONSIBILITY | 1 | 29 | 1 (0)| 00:00:01 | |* 47 | INDEX UNIQUE SCAN | PK_GEDIS_RESPONSIBILITY | 1 | | 0 (0)| 00:00:01 | | 48 | TABLE ACCESS BY INDEX ROWID | GEDIS_USER_GROUP | 1 | 27 | 1 (0)| 00:00:01 | |* 49 | INDEX UNIQUE SCAN | GEDIS_USER_GROUP_PK | 1 | | 0 (0)| 00:00:01 | |* 50 | INDEX SKIP SCAN | UK_BU_DEPARTMENT_SALPER | 1 | 8 | 1 (0)| 00:00:01 | | 51 | SORT UNIQUE | | 1 | 179 | 9 (12)| 00:00:01 | | 52 | NESTED LOOPS OUTER | | 1 | 179 | 8 (0)| 00:00:01 | | 53 | NESTED LOOPS | | 1 | 171 | 7 (0)| 00:00:01 | | 54 | NESTED LOOPS | | 1 | 144 | 6 (0)| 00:00:01 | | 55 | NESTED LOOPS | | 1 | 115 | 5 (0)| 00:00:01 | | 56 | NESTED LOOPS | | 1 | 97 | 4 (0)| 00:00:01 | |* 57 | TABLE ACCESS BY INDEX ROWID| GEDIS_SALESPERSON | 1 | 71 | 2 (0)| 00:00:01 | |* 58 | INDEX RANGE SCAN | GEDIS_SALESPERSON_N1 | 3 | | 1 (0)| 00:00:01 | |* 59 | TABLE ACCESS BY INDEX ROWID| GEDIS_USER_LINK | 1 | 26 | 2 (0)| 00:00:01 | |* 60 | INDEX RANGE SCAN | GEDIS_USER_LINK_PK | 1 | | 1 (0)| 00:00:01 | |* 61 | TABLE ACCESS BY INDEX ROWID | GEDIS_USER_ROLE | 1 | 18 | 1 (0)| 00:00:01 | |* 62 | INDEX UNIQUE SCAN | GEDIS_USER_ROLE_PK | 1 | | 0 (0)| 00:00:01 | |* 63 | TABLE ACCESS BY INDEX ROWID | GEDIS_RESPONSIBILITY | 1 | 29 | 1 (0)| 00:00:01 | |* 64 | INDEX UNIQUE SCAN | PK_GEDIS_RESPONSIBILITY | 1 | | 0 (0)| 00:00:01 | | 65 | TABLE ACCESS BY INDEX ROWID | GEDIS_USER_GROUP | 1 | 27 | 1 (0)| 00:00:01 | |* 66 | INDEX UNIQUE SCAN | GEDIS_USER_GROUP_PK | 1 | | 0 (0)| 00:00:01 | |* 67 | INDEX SKIP SCAN | UK_BU_DEPARTMENT_SALPER | 1 | 8 | 1 (0)| 00:00:01 | | 68 | SORT UNIQUE | | 1 | 180 | 10 (10)| 00:00:01 | | 69 | NESTED LOOPS OUTER | | 1 | 180 | 9 (0)| 00:00:01 | | 70 | NESTED LOOPS | | 1 | 172 | 8 (0)| 00:00:01 | | 71 | NESTED LOOPS | | 1 | 145 | 7 (0)| 00:00:01 | | 72 | NESTED LOOPS | | 1 | 116 | 6 (0)| 00:00:01 | | 73 | NESTED LOOPS | | 1 | 98 | 5 (0)| 00:00:01 | |* 74 | TABLE ACCESS BY INDEX ROWID| GEDIS_SALESPERSON | 1 | 72 | 3 (0)| 00:00:01 | |* 75 | INDEX RANGE SCAN | GEDIS_SALESPERSON_N1 | 3 | | 1 (0)| 00:00:01 | |* 76 | TABLE ACCESS BY INDEX ROWID| GEDIS_USER_LINK | 1 | 26 | 2 (0)| 00:00:01 | |* 77 | INDEX RANGE SCAN | GEDIS_USER_LINK_PK | 1 | | 1 (0)| 00:00:01 | |* 78 | TABLE ACCESS BY INDEX ROWID | GEDIS_USER_ROLE | 1 | 18 | 1 (0)| 00:00:01 | |* 79 | INDEX UNIQUE SCAN | GEDIS_USER_ROLE_PK | 1 | | 0 (0)| 00:00:01 | |* 80 | TABLE ACCESS BY INDEX ROWID | GEDIS_RESPONSIBILITY | 1 | 29 | 1 (0)| 00:00:01 | |* 81 | INDEX UNIQUE SCAN | PK_GEDIS_RESPONSIBILITY | 1 | | 0 (0)| 00:00:01 | | 82 | TABLE ACCESS BY INDEX ROWID | GEDIS_USER_GROUP | 1 | 27 | 1 (0)| 00:00:01 | |* 83 | INDEX UNIQUE SCAN | GEDIS_USER_GROUP_PK | 1 | | 0 (0)| 00:00:01 | |* 84 | INDEX SKIP SCAN | UK_BU_DEPARTMENT_SALPER | 1 | 8 | 1 (0)| 00:00:01 | | 85 | SORT UNIQUE | | 1 | 179 | 9 (12)| 00:00:01 | | 86 | NESTED LOOPS OUTER | | 1 | 179 | 8 (0)| 00:00:01 | | 87 | NESTED LOOPS | | 1 | 171 | 7 (0)| 00:00:01 | | 88 | NESTED LOOPS | | 1 | 145 | 6 (0)| 00:00:01 | | 89 | NESTED LOOPS | | 1 | 116 | 5 (0)| 00:00:01 | | 90 | NESTED LOOPS | | 1 | 98 | 4 (0)| 00:00:01 | |* 91 | TABLE ACCESS BY INDEX ROWID| GEDIS_SALESPERSON | 1 | 72 | 2 (0)| 00:00:01 | |* 92 | INDEX RANGE SCAN | GEDIS_SALESPERSON_N1 | 3 | | 1 (0)| 00:00:01 | |* 93 | TABLE ACCESS BY INDEX ROWID| GEDIS_USER_LINK | 1 | 26 | 2 (0)| 00:00:01 | |* 94 | INDEX RANGE SCAN | GEDIS_USER_LINK_PK | 1 | | 1 (0)| 00:00:01 | |* 95 | TABLE ACCESS BY INDEX ROWID | GEDIS_USER_ROLE | 1 | 18 | 1 (0)| 00:00:01 | |* 96 | INDEX UNIQUE SCAN | GEDIS_USER_ROLE_PK | 1 | | 0 (0)| 00:00:01 | |* 97 | TABLE ACCESS BY INDEX ROWID | GEDIS_RESPONSIBILITY | 1 | 29 | 1 (0)| 00:00:01 | |* 98 | INDEX UNIQUE SCAN | PK_GEDIS_RESPONSIBILITY | 1 | | 0 (0)| 00:00:01 | | 99 | TABLE ACCESS BY INDEX ROWID | GEDIS_USER_GROUP | 1 | 26 | 1 (0)| 00:00:01 | |*100 | INDEX UNIQUE SCAN | GEDIS_USER_GROUP_PK | 1 | | 0 (0)| 00:00:01 | |*101 | INDEX SKIP SCAN | UK_BU_DEPARTMENT_SALPER | 1 | 8 | 1 (0)| 00:00:01 | | 102 | SORT UNIQUE | | 1 | 177 | 10 (10)| 00:00:01 | | 103 | NESTED LOOPS OUTER | | 1 | 177 | 9 (0)| 00:00:01 | | 104 | NESTED LOOPS | | 1 | 169 | 8 (0)| 00:00:01 | | 105 | NESTED LOOPS | | 1 | 145 | 7 (0)| 00:00:01 | | 106 | NESTED LOOPS | | 1 | 116 | 6 (0)| 00:00:01 | | 107 | NESTED LOOPS | | 1 | 98 | 5 (0)| 00:00:01 | |*108 | TABLE ACCESS BY INDEX ROWID| GEDIS_SALESPERSON | 1 | 72 | 3 (0)| 00:00:01 | |*109 | INDEX RANGE SCAN | GEDIS_SALESPERSON_N1 | 3 | | 1 (0)| 00:00:01 | |*110 | TABLE ACCESS BY INDEX ROWID| GEDIS_USER_LINK | 1 | 26 | 2 (0)| 00:00:01 | |*111 | INDEX RANGE SCAN | GEDIS_USER_LINK_PK | 1 | | 1 (0)| 00:00:01 | |*112 | TABLE ACCESS BY INDEX ROWID | GEDIS_USER_ROLE | 1 | 18 | 1 (0)| 00:00:01 | |*113 | INDEX UNIQUE SCAN | GEDIS_USER_ROLE_PK | 1 | | 0 (0)| 00:00:01 | |*114 | TABLE ACCESS BY INDEX ROWID | GEDIS_RESPONSIBILITY | 1 | 29 | 1 (0)| 00:00:01 | |*115 | INDEX UNIQUE SCAN | PK_GEDIS_RESPONSIBILITY | 1 | | 0 (0)| 00:00:01 | | 116 | TABLE ACCESS BY INDEX ROWID | GEDIS_USER_GROUP | 1 | 24 | 1 (0)| 00:00:01 | |*117 | INDEX UNIQUE SCAN | GEDIS_USER_GROUP_PK | 1 | | 0 (0)| 00:00:01 | |*118 | INDEX SKIP SCAN | UK_BU_DEPARTMENT_SALPER | 1 | 8 | 1 (0)| 00:00:01 | | 119 | SORT UNIQUE | | 1 | 175 | 9 (12)| 00:00:01 | | 120 | NESTED LOOPS OUTER | | 1 | 175 | 8 (0)| 00:00:01 | | 121 | NESTED LOOPS | | 1 | 167 | 7 (0)| 00:00:01 | | 122 | NESTED LOOPS | | 1 | 144 | 6 (0)| 00:00:01 | | 123 | NESTED LOOPS | | 1 | 115 | 5 (0)| 00:00:01 | | 124 | NESTED LOOPS | | 1 | 99 | 4 (0)| 00:00:01 | |*125 | TABLE ACCESS BY INDEX ROWID| GEDIS_SALESPERSON | 1 | 72 | 2 (0)| 00:00:01 | |*126 | INDEX RANGE SCAN | GEDIS_SALESPERSON_N1 | 3 | | 1 (0)| 00:00:01 | |*127 | TABLE ACCESS BY INDEX ROWID| GEDIS_USER_LINK | 1 | 27 | 2 (0)| 00:00:01 | |*128 | INDEX RANGE SCAN | GEDIS_USER_LINK_PK | 1 | | 1 (0)| 00:00:01 | |*129 | TABLE ACCESS BY INDEX ROWID | GEDIS_USER_ROLE | 1 | 16 | 1 (0)| 00:00:01 | |*130 | INDEX UNIQUE SCAN | GEDIS_USER_ROLE_PK | 1 | | 0 (0)| 00:00:01 | |*131 | TABLE ACCESS BY INDEX ROWID | GEDIS_RESPONSIBILITY | 1 | 29 | 1 (0)| 00:00:01 | |*132 | INDEX UNIQUE SCAN | PK_GEDIS_RESPONSIBILITY | 1 | | 0 (0)| 00:00:01 | | 133 | TABLE ACCESS BY INDEX ROWID | GEDIS_USER_GROUP | 1 | 23 | 1 (0)| 00:00:01 | |*134 | INDEX UNIQUE SCAN | GEDIS_USER_GROUP_PK | 1 | | 0 (0)| 00:00:01 | |*135 | INDEX SKIP SCAN | UK_BU_DEPARTMENT_SALPER | 1 | 8 | 1 (0)| 00:00:01 | | 136 | SORT UNIQUE | | 1 | 175 | 10 (10)| 00:00:01 | | 137 | NESTED LOOPS OUTER | | 1 | 175 | 9 (0)| 00:00:01 | | 138 | NESTED LOOPS | | 1 | 167 | 8 (0)| 00:00:01 | | 139 | NESTED LOOPS | | 1 | 144 | 7 (0)| 00:00:01 | | 140 | NESTED LOOPS | | 1 | 115 | 6 (0)| 00:00:01 | | 141 | NESTED LOOPS | | 1 | 99 | 5 (0)| 00:00:01 | |*142 | TABLE ACCESS BY INDEX ROWID| GEDIS_SALESPERSON | 1 | 72 | 3 (0)| 00:00:01 | |*143 | INDEX RANGE SCAN | GEDIS_SALESPERSON_N1 | 3 | | 1 (0)| 00:00:01 | |*144 | TABLE ACCESS BY INDEX ROWID| GEDIS_USER_LINK | 1 | 27 | 2 (0)| 00:00:01 | |*145 | INDEX RANGE SCAN | GEDIS_USER_LINK_PK | 1 | | 1 (0)| 00:00:01 | |*146 | TABLE ACCESS BY INDEX ROWID | GEDIS_USER_ROLE | 1 | 16 | 1 (0)| 00:00:01 | |*147 | INDEX UNIQUE SCAN | GEDIS_USER_ROLE_PK | 1 | | 0 (0)| 00:00:01 | |*148 | TABLE ACCESS BY INDEX ROWID | GEDIS_RESPONSIBILITY | 1 | 29 | 1 (0)| 00:00:01 | |*149 | INDEX UNIQUE SCAN | PK_GEDIS_RESPONSIBILITY | 1 | | 0 (0)| 00:00:01 | | 150 | TABLE ACCESS BY INDEX ROWID | GEDIS_USER_GROUP | 1 | 23 | 1 (0)| 00:00:01 | |*151 | INDEX UNIQUE SCAN | GEDIS_USER_GROUP_PK | 1 | | 0 (0)| 00:00:01 | |*152 | INDEX SKIP SCAN | UK_BU_DEPARTMENT_SALPER | 1 | 8 | 1 (0)| 00:00:01 | | 153 | SORT UNIQUE | | 1 | 175 | 10 (10)| 00:00:01 | | 154 | NESTED LOOPS OUTER | | 1 | 175 | 9 (0)| 00:00:01 | | 155 | NESTED LOOPS | | 1 | 167 | 8 (0)| 00:00:01 | | 156 | NESTED LOOPS | | 1 | 144 | 7 (0)| 00:00:01 | | 157 | NESTED LOOPS | | 1 | 115 | 6 (0)| 00:00:01 | | 158 | NESTED LOOPS | | 1 | 99 | 5 (0)| 00:00:01 | |*159 | TABLE ACCESS BY INDEX ROWID| GEDIS_SALESPERSON | 1 | 72 | 3 (0)| 00:00:01 | |*160 | INDEX RANGE SCAN | GEDIS_SALESPERSON_N1 | 3 | | 1 (0)| 00:00:01 | |*161 | TABLE ACCESS BY INDEX ROWID| GEDIS_USER_LINK | 1 | 27 | 2 (0)| 00:00:01 | |*162 | INDEX RANGE SCAN | GEDIS_USER_LINK_PK | 1 | | 1 (0)| 00:00:01 | |*163 | TABLE ACCESS BY INDEX ROWID | GEDIS_USER_ROLE | 1 | 16 | 1 (0)| 00:00:01 | |*164 | INDEX UNIQUE SCAN | GEDIS_USER_ROLE_PK | 1 | | 0 (0)| 00:00:01 | |*165 | TABLE ACCESS BY INDEX ROWID | GEDIS_RESPONSIBILITY | 1 | 29 | 1 (0)| 00:00:01 | |*166 | INDEX UNIQUE SCAN | PK_GEDIS_RESPONSIBILITY | 1 | | 0 (0)| 00:00:01 | | 167 | TABLE ACCESS BY INDEX ROWID | GEDIS_USER_GROUP | 1 | 23 | 1 (0)| 00:00:01 | |*168 | INDEX UNIQUE SCAN | GEDIS_USER_GROUP_PK | 1 | | 0 (0)| 00:00:01 | |*169 | INDEX SKIP SCAN | UK_BU_DEPARTMENT_SALPER | 1 | 8 | 1 (0)| 00:00:01 | ----------------------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 7 - access("FH"."DATE_RECEIVED">SYSDATE@!-8) 9 - access("FS"."ID"="FH"."FAX_SOURCE") 11 - access("BU_MAPPING"."BU_ID"="FS"."BUID") filter("BU_MAPPING"."BU_ID" IS NOT NULL) 13 - access("FH"."ID"="FOD"."FAX_ID") 21 - access("FH"."ID"="FH"."ID") 23 - access("FH"."LAST_TRANSITION_ID"="FTH"."ID") 25 - access("WTR"."ID"="FTH"."TRANSITION_REASON_ID") 27 - access("WTR"."WORKGROUP_TRANSITION_ID"="WT"."ID") 29 - access("WT"."NEXT_WORKGROUP_ID"="TOW"."ID") 31 - access("WT"."CURRENT_WORKGROUP_ID"="FROMW"."ID") 40 - filter(INTERNAL_FUNCTION("SP"."EFFECTIVE_START_DATE")SYS_EXTRACT_UTC(SYSTIMESTAMP(6))) 41 - access("SP"."SALESPERSON_ID"="FH"."SALES_PERSON") 42 - filter((INTERNAL_FUNCTION("UL"."START_DATE_ACTIVE")SYS_EXTRACT_UTC(SYSTIMESTAMP(6)))) 43 - access("UL"."USER_ID"="FH"."SALES_PERSON") filter("SP"."SALESPERSON_ID"="UL"."USER_ID") 44 - filter(UPPER("UR"."ROLE_NAME")='ORL_MEMBER') 45 - access("UL"."ROLE_ID"="UR"."ROLE_ID") 46 - filter("GR"."RESPONSIBILITY_KEY" LIKE 'ORL%') 47 - access("SP"."RESPONSIBILITY_ID"="GR"."RESPONSIBILITY_ID") 49 - access("UL"."GROUP_ID"="UGR"."GROUP_ID") 50 - access("DS"."USER_ID"(+)="FH"."SALES_PERSON") filter("DS"."USER_ID"(+)="FH"."SALES_PERSON" AND "SP"."SALESPERSON_ID"="DS"."USER_ID"(+)) 57 - filter(INTERNAL_FUNCTION("SP"."EFFECTIVE_START_DATE")SYS_EXTRACT_UTC(SYSTIMESTAMP(6))) 58 - access("SP"."SALESPERSON_ID"="FH"."SALES_PERSON") 59 - filter((INTERNAL_FUNCTION("UL"."START_DATE_ACTIVE")SYS_EXTRACT_UTC(SYSTIMESTAMP(6)))) 60 - access("UL"."USER_ID"="FH"."SALES_PERSON") filter("SP"."SALESPERSON_ID"="UL"."USER_ID") 61 - filter(UPPER("UR"."ROLE_NAME")='ORL_MEMBER') 62 - access("UL"."ROLE_ID"="UR"."ROLE_ID") 63 - filter("GR"."RESPONSIBILITY_KEY" LIKE 'ORL%') 64 - access("SP"."RESPONSIBILITY_ID"="GR"."RESPONSIBILITY_ID") 66 - access("UL"."GROUP_ID"="UGR"."GROUP_ID") 67 - access("DS"."USER_ID"(+)="FH"."SALES_PERSON") filter("DS"."USER_ID"(+)="FH"."SALES_PERSON" AND "SP"."SALESPERSON_ID"="DS"."USER_ID"(+)) 74 - filter(INTERNAL_FUNCTION("SP"."EFFECTIVE_START_DATE")SYS_EXTRACT_UTC(SYSTIMESTAMP(6))) 75 - access("SP"."SALESPERSON_ID"="FH"."SALES_PERSON") 76 - filter((INTERNAL_FUNCTION("UL"."START_DATE_ACTIVE")SYS_EXTRACT_UTC(SYSTIMESTAMP(6)))) 77 - access("UL"."USER_ID"="FH"."SALES_PERSON") filter("SP"."SALESPERSON_ID"="UL"."USER_ID") 78 - filter(UPPER("UR"."ROLE_NAME")='ORL_MEMBER') 79 - access("UL"."ROLE_ID"="UR"."ROLE_ID") 80 - filter("GR"."RESPONSIBILITY_KEY" LIKE 'ORL%') 81 - access("SP"."RESPONSIBILITY_ID"="GR"."RESPONSIBILITY_ID") 83 - access("UL"."GROUP_ID"="UGR"."GROUP_ID") 84 - access("DS"."USER_ID"(+)="FH"."SALES_PERSON") filter("DS"."USER_ID"(+)="FH"."SALES_PERSON" AND "SP"."SALESPERSON_ID"="DS"."USER_ID"(+)) 91 - filter(INTERNAL_FUNCTION("SP"."EFFECTIVE_START_DATE")SYS_EXTRACT_UTC(SYSTIMESTAMP(6))) 92 - access("SP"."SALESPERSON_ID"="FH"."SALES_PERSON") 93 - filter((INTERNAL_FUNCTION("UL"."START_DATE_ACTIVE")SYS_EXTRACT_UTC(SYSTIMESTAMP(6)))) 94 - access("UL"."USER_ID"="FH"."SALES_PERSON") filter("SP"."SALESPERSON_ID"="UL"."USER_ID") 95 - filter(UPPER("UR"."ROLE_NAME")='ORL_MEMBER') 96 - access("UL"."ROLE_ID"="UR"."ROLE_ID") 97 - filter("GR"."RESPONSIBILITY_KEY" LIKE 'ORL%') 98 - access("SP"."RESPONSIBILITY_ID"="GR"."RESPONSIBILITY_ID") 100 - access("UL"."GROUP_ID"="UGR"."GROUP_ID") 101 - access("DS"."USER_ID"(+)="FH"."SALES_PERSON") filter("DS"."USER_ID"(+)="FH"."SALES_PERSON" AND "SP"."SALESPERSON_ID"="DS"."USER_ID"(+)) 108 - filter(INTERNAL_FUNCTION("SP"."EFFECTIVE_START_DATE")SYS_EXTRACT_UTC(SYSTIMESTAMP(6))) 109 - access("SP"."SALESPERSON_ID"="FH"."SALES_PERSON") 110 - filter((INTERNAL_FUNCTION("UL"."START_DATE_ACTIVE")SYS_EXTRACT_UTC(SYSTIMESTAMP(6)))) 111 - access("UL"."USER_ID"="FH"."SALES_PERSON") filter("SP"."SALESPERSON_ID"="UL"."USER_ID") 112 - filter(UPPER("UR"."ROLE_NAME")='ORL_MEMBER') 113 - access("UL"."ROLE_ID"="UR"."ROLE_ID") 114 - filter("GR"."RESPONSIBILITY_KEY" LIKE 'ORL%') 115 - access("SP"."RESPONSIBILITY_ID"="GR"."RESPONSIBILITY_ID") 117 - access("UL"."GROUP_ID"="UGR"."GROUP_ID") 118 - access("DS"."USER_ID"(+)="FH"."SALES_PERSON") filter("DS"."USER_ID"(+)="FH"."SALES_PERSON" AND "SP"."SALESPERSON_ID"="DS"."USER_ID"(+)) 125 - filter(INTERNAL_FUNCTION("SP"."EFFECTIVE_START_DATE")SYS_EXTRACT_UTC(SYSTIMESTAMP(6))) 126 - access("SP"."SALESPERSON_ID"="FH"."SALES_PERSON") 127 - filter((INTERNAL_FUNCTION("UL"."START_DATE_ACTIVE")SYS_EXTRACT_UTC(SYSTIMESTAMP(6)))) 128 - access("UL"."USER_ID"="FH"."SALES_PERSON") filter("SP"."SALESPERSON_ID"="UL"."USER_ID") 129 - filter(UPPER("UR"."ROLE_NAME")='ORL_MEMBER') 130 - access("UL"."ROLE_ID"="UR"."ROLE_ID") 131 - filter("GR"."RESPONSIBILITY_KEY" LIKE 'ORL%') 132 - access("SP"."RESPONSIBILITY_ID"="GR"."RESPONSIBILITY_ID") 134 - access("UL"."GROUP_ID"="UGR"."GROUP_ID") 135 - access("DS"."USER_ID"(+)="FH"."SALES_PERSON") filter("DS"."USER_ID"(+)="FH"."SALES_PERSON" AND "SP"."SALESPERSON_ID"="DS"."USER_ID"(+)) 142 - filter(INTERNAL_FUNCTION("SP"."EFFECTIVE_START_DATE")SYS_EXTRACT_UTC(SYSTIMESTAMP(6))) 143 - access("SP"."SALESPERSON_ID"="FH"."SALES_PERSON") 144 - filter((INTERNAL_FUNCTION("UL"."START_DATE_ACTIVE")SYS_EXTRACT_UTC(SYSTIMESTAMP(6)))) 145 - access("UL"."USER_ID"="FH"."SALES_PERSON") filter("SP"."SALESPERSON_ID"="UL"."USER_ID") 146 - filter(UPPER("UR"."ROLE_NAME")='ORL_MEMBER') 147 - access("UL"."ROLE_ID"="UR"."ROLE_ID") 148 - filter("GR"."RESPONSIBILITY_KEY" LIKE 'ORL%') 149 - access("SP"."RESPONSIBILITY_ID"="GR"."RESPONSIBILITY_ID") 151 - access("UL"."GROUP_ID"="UGR"."GROUP_ID") 152 - access("DS"."USER_ID"(+)="FH"."SALES_PERSON") filter("DS"."USER_ID"(+)="FH"."SALES_PERSON" AND "SP"."SALESPERSON_ID"="DS"."USER_ID"(+)) 159 - filter(INTERNAL_FUNCTION("SP"."EFFECTIVE_START_DATE")SYS_EXTRACT_UTC(SYSTIMESTAMP(6))) 160 - access("SP"."SALESPERSON_ID"="FH"."SALES_PERSON") 161 - filter((INTERNAL_FUNCTION("UL"."START_DATE_ACTIVE")SYS_EXTRACT_UTC(SYSTIMESTAMP(6)))) 162 - access("UL"."USER_ID"="FH"."SALES_PERSON") filter("SP"."SALESPERSON_ID"="UL"."USER_ID") 163 - filter(UPPER("UR"."ROLE_NAME")='ORL_MEMBER') 164 - access("UL"."ROLE_ID"="UR"."ROLE_ID") 165 - filter("GR"."RESPONSIBILITY_KEY" LIKE 'ORL%') 166 - access("SP"."RESPONSIBILITY_ID"="GR"."RESPONSIBILITY_ID") 168 - access("UL"."GROUP_ID"="UGR"."GROUP_ID") 169 - access("DS"."USER_ID"(+)="FH"."SALES_PERSON") filter("DS"."USER_ID"(+)="FH"."SALES_PERSON" AND "SP"."SALESPERSON_ID"="DS"."USER_ID"(+)) 311 rows selected.