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