PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- Plan hash value: 387100176 ---------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Byte ---------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 3628 | 1 | PX COORDINATOR | | | | 2 | PX SEND QC (ORDER) | :TQ10020 | 1 | 3628 | 3 | VIEW | PRONELT_METALIC_V | 1 | 3628 | 4 | SORT GROUP BY | | 1 | 109 | 5 | PX RECEIVE | | 1 | 109 PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- | 6 | PX SEND RANGE | :TQ10019 | 1 | 109 | 7 | SORT GROUP BY | | 1 | 109 | 8 | NESTED LOOPS | | 1 | 109 | 9 | NESTED LOOPS | | 1 | 105 |* 10 | HASH JOIN OUTER | | 1 | 101 | 11 | PX RECEIVE | | 1 | 97 | 12 | PX SEND HASH | :TQ10018 | 1 | 97 |* 13 | HASH JOIN | | 1 | 97 |* 14 | HASH JOIN OUTER | | 1 | 95 |* 15 | HASH JOIN OUTER | | 1 | 90 | 16 | PX RECEIVE | | 1 | 87 PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- | 17 | PX SEND HASH | :TQ10016 | 1 | 87 | 18 | NESTED LOOPS OUTER | | 1 | 87 |* 19 | HASH JOIN OUTER | | 1 | 86 | 20 | PX RECEIVE | | 1 | 82 | 21 | PX SEND HASH | :TQ10014 | 1 | 82 | 22 | NESTED LOOPS OUTER | | 1 | 82 | 23 | NESTED LOOPS | | 1 | 82 |* 24 | HASH JOIN OUTER | | 1 | 78 | 25 | PX RECEIVE | | 1 | 74 | 26 | PX SEND HASH | :TQ10012 | 1 | 74 | 27 | BUFFER SORT | | 1 | 3628 PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- | 28 | NESTED LOOPS OUTER | | 1 | 74 | 29 | NESTED LOOPS | | 1 | 74 | 30 | NESTED LOOPS | | 1 | 70 | 31 | NESTED LOOPS | | 1 | 69 | 32 | NESTED LOOPS | | 1 | 65 | 33 | NESTED LOOPS OUTER | | 1 | 29 | 34 | NESTED LOOPS | | 1 | 26 |* 35 | HASH JOIN | | 1 | 25 | 36 | PX RECEIVE | | 1 | 22 | 37 | PX SEND HASH | :TQ10010 | 1 | 22 |* 38 | HASH JOIN OUTER | | 1 | 22 PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- | 39 | L PX PARTITION RANGE AL | | 3942 | 58 | 40 | L INDEX ROWID TABLE ACCESS BY LOCA | TRANCHE_BALANCE | 3942 | 58 |* 41 | INDEX RANGE SCAN | TEMP_TRANCHE_BALANCE | 3942 | | 42 | BUFFER SORT | | | | 43 | PX RECEIVE | | 1 | 7 | 44 | PX SEND BROADCAST | :TQ10002 | 1 | 7 | 45 | VIEW | | 1 | 7 | 46 | WINDOW SORT | | 1 | 11 |* 47 | HASH JOIN OUTER | | 1 | 11 | 48 | ITERATOR PARTITION RANGE | | 3942 | 8278 |* 49 | L SCAN INDEX FAST FUL | XIE1_TRANCHE_ACTIVITY | 3942 | 8278 PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- | 50 | VIEW | | 1 | 9 | 51 | SORT GROUP BY | | 1 | 4 | 52 | VIEW | | 1 | 4 | 53 | Y SORT GROUP B | | 1 | 15 | 54 | S BY INDEX ROWID TABLE ACCES | INVESTMENT_CLASS_SUMMARY | 1 | 2 | 55 | PS NESTED LOO | | 1 | 15 | 56 | OPS NESTED LO | | 1 | 13 | 57 | OOPS NESTED L | | 1 | 8 | 58 | LOOPS NESTED | | 1 | 7 | 59 | LOOPS NESTED | | 1 | 6 | 60 | D LOOPS NESTE | | 1 | 3 PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- | 61 | ST ITERATOR INLI | | | |* 62 | LE ACCESS BY INDEX ROWID TAB | AMT_TYPE_RULE | 3 | 8 |* 63 | DEX RANGE SCAN IN | XPKAMT_TYPE_RULE | 4 | |* 64 | X UNIQUE SCAN INDE | XPKAMOUNT_TYPE | 1 | | 65 | ACCESS BY INDEX ROWID TABLE | BALANCE_RULE_DETAIL | 1 | 3 |* 66 | X RANGE SCAN INDE | XIF212BALANCE_RULE_DETAIL | 1 | | 67 | ACCESS BY INDEX ROWID TABLE | GL_ACCOUNT | 1 | 1 |* 68 | UNIQUE SCAN INDEX | XPKGL_ACCOUNT | 1 | | 69 | CCESS BY INDEX ROWID TABLE A | GL_SUB_ACCOUNT | 1 | 1 |* 70 | UNIQUE SCAN INDEX | XPKGL_SUB_ACCOUNT | 1 | | 71 | N RANGE ITERATOR PARTITIO | | 2 | 9 PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- |* 72 | CCESS BY LOCAL INDEX ROWID TABLE A | LEDGER_POSTING_DATE_SUMMARY | 2 | 9 |* 73 | RANGE SCAN INDEX | XIE1LEDGER_POSTING_DATE_SUMM | 1 | |* 74 | GE SCAN INDEX RAN | XAK1INVESTMENT_CLASS_SUMMARY | 1 | | 75 | PX RECEIVE | | 8511 | 22 | 76 | PX SEND HASH | :TQ10011 | 8511 | 22 | 77 | VIEW | TRANCHE_INFO_LOOKUP_V | 8511 | 22 | 78 | SORT GROUP BY | | 8511 | 34 | 79 | PX RECEIVE | | 8511 | 34 | 80 | PX SEND HASH | :TQ10009 | 8511 | 34 | 81 | SORT GROUP BY | | 8511 | 34 | 82 | VIEW | | 8511 | 34 PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- | 83 | UNION-ALL | | | |* 84 | HASH JOIN | | 3942 | 10 | 85 | PX RECEIVE | | 3942 | 6701 | 86 | PX SEND HASH | :TQ10008 | 3942 | 6701 | 87 | RANGE ALL PX PARTITION | | 3942 | 6701 | 88 | S BY LOCAL INDEX ROWID TABLE ACCES | TRANCHE_BALANCE | 3942 | 6701 |* 89 | E SCAN INDEX RANG | TEMP_TRANCHE_BALANCE | 3942 | | 90 | BUFFER SORT | | | | 91 | PX RECEIVE | | 13060 | 14 | 92 | PX SEND HASH | :TQ10000 | 13060 | 14 |* 93 | S FULL TABLE ACCES | TRANCHE | 13060 | 14 PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- | 94 | BUFFER SORT | | | | 95 | PX RECEIVE | | 4569 | 18 | 96 | -ROBIN PX SEND ROUND | :TQ10001 | 4569 | 18 |* 97 | HASH JOIN | | 4569 | 18 | 98 | ANGE ALL PARTITION R | | 4569 | 13 |* 99 | SS FULL TABLE ACCE | TRANCHE_PARTICIPANT_SUMMARY | 4569 | 13 |*100 | S FULL TABLE ACCES | TRANCHE | 13060 | 14 |*101 | ID TABLE ACCESS BY INDEX ROW | TRANCHE | 1 | 1 |*102 | INDEX UNIQUE SCAN | XPKTRANCHE | 1 | |*103 | VIEW PUSHED PREDICATE | | 1 | 3 |*104 | FILTER | | | PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- | 105 | NESTED LOOPS | | 1 | 3 | 106 | OWID TABLE ACCESS BY INDEX R | TRANCHE | 1 | 1 |*107 | INDEX UNIQUE SCAN | XPKTRANCHE | 1 | |*108 | OWID TABLE ACCESS BY INDEX R | SPECIFIC_LOSS_RESERVE | 1 | 2 |*109 | INDEX RANGE SCAN | TMP_IND1 | 1 | | 110 | PARTITION RANGE ITERATOR | | 1 | 35 |*111 | X ROWID TABLE ACCESS BY LOCAL INDE | PROJ_INFO_LOOKUP_MONTHLY | 1 | 35 |*112 | INDEX RANGE SCAN | XIE6PROJ_INFO_LOOKUP_MONTHLY | 1 | | 113 | TABLE ACCESS BY INDEX ROWID | IFC_SECTOR | 1 | 3 |*114 | INDEX UNIQUE SCAN | XPKIFC_SECTOR | 1 | | 115 | TABLE ACCESS BY INDEX ROWID | COUNTRY | 1 | 1 PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- |*116 | INDEX UNIQUE SCAN | XPKCOUNTRY | 1 | | 117 | TABLE ACCESS BY INDEX ROWID | PROJ_INFO_LOOKUP | 1 | 3 |*118 | INDEX UNIQUE SCAN | XPKPROJ_INFO_LOOKUP | 1 | | 119 | TABLE ACCESS BY INDEX ROWID | INSTITUTION_LOSS_RESERVE | 1 | |*120 | INDEX UNIQUE SCAN | XPKINSTITUTION_LOSS_RESERVE | 1 | | 121 | BUFFER SORT | | | | 122 | PX RECEIVE | | 73731 | 280 | 123 | PX SEND HASH | :TQ10003 | 73731 | 280 | 124 | VIEW | | 73731 | 280 | 125 | SORT GROUP BY | | 73731 | 208 |*126 | TABLE ACCESS FULL | AMOUNT_DUE_SUMMARY | 73731 | 208 PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- | 127 | TABLE ACCESS BY INDEX ROWID | INSTITUTION | 1 | 3 |*128 | INDEX UNIQUE SCAN | XPKINSTITUTION | 1 | |*129 | INDEX UNIQUE SCAN | XPKCOUNTRY | 1 | | 130 | BUFFER SORT | | | | 131 | PX RECEIVE | | 155K| 531 | 132 | PX SEND HASH | :TQ10004 | 155K| 531 | 133 | VIEW | CNTRY_LEND_ELIGIBILITY_ALL_V | 155K| 531 |*134 | HASH JOIN OUTER | | 155K| 895 | 135 | TABLE ACCESS BY LOCAL INDEX ROWID | FINANCIAL_PERIOD_DIM | 11 | 13 | 136 | NESTED LOOPS | | 155K| 425 | 137 | VIEW | | 13676 | 21 PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- | 138 | MERGE JOIN CARTESIAN | | 13676 | 25 | 139 | VIEW | | 52 | 67 | 140 | SORT UNIQUE | | 52 | 20 | 141 | INDEX FAST FULL SCAN | XPKCOUNTRY_LENDING_ELIGIBILITY | 13619 | 5447 | 142 | BUFFER SORT | | 263 | 157 |*143 | TABLE ACCESS FULL | COUNTRY | 263 | 157 | 144 | PARTITION RANGE ALL | | 1 | | 145 | PARTITION HASH ALL | | 1 | |*146 | INDEX RANGE SCAN | XAKFINANCIAL_PERIOD_KEY_FY | 1 | | 147 | TABLE ACCESS FULL | COUNTRY_LENDING_ELIGIBILITY | 13619 | 41 | 148 | TABLE ACCESS BY INDEX ROWID | EQUITY_VALUATION_SUMMARY | 1 | 1 PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- |*149 | INDEX UNIQUE SCAN | SYS_C004698 | 1 | | 150 | PX RECEIVE | | 668K| 1 | 151 | PX SEND HASH | :TQ10017 | 668K| 1 | 152 | VIEW | | 668K| 1 | 153 | SORT GROUP BY | | 668K| 66 | 154 | PX RECEIVE | | 668K| 66 | 155 | PX SEND HASH | :TQ10015 | 668K| 66 | 156 | SORT GROUP BY | | 668K| 66 |*157 | VIEW | | 1041K| 102 | 158 | WINDOW SORT | | 1041K| 4 | 159 | PX RECEIVE | | 1041K| 4 PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- | 160 | PX SEND HASH | :TQ10013 | 1041K| 4 | 161 | NESTED LOOPS | | 1041K| 4 | 162 | PX BLOCK ITERATOR | | | | 163 | TABLE ACCESS FULL | SUMMARY_DATE_TABLE | 262 | 209 |*164 | TABLE ACCESS FULL | VALUATION_FEATURE | 3975 | 15 | 165 | BUFFER SORT | | | | 166 | PX RECEIVE | | 751K| 3 | 167 | PX SEND HASH | :TQ10005 | 751K| 3 | 168 | VIEW | COMPANY_CREDIT_RISK_SUMMARY_V | 751K| 3 | 169 | SORT GROUP BY | | 751K| 4 |*170 | VIEW | | 1172K| 7 PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- | 171 | WINDOW SORT | | 1172K| 3 | 172 | MERGE JOIN | | 1172K| 3 | 173 | SORT JOIN | | 262 | 209 | 174 | TABLE ACCESS FULL | SUMMARY_DATE_TABLE | 262 | 209 |*175 | SORT JOIN | | 89484 | 209 | 176 | TABLE ACCESS FULL | COMPANY_CREDIT_RATING_HISTORY | 89484 | 209 | 177 | BUFFER SORT | | | | 178 | PX RECEIVE | | 954K| 1 | 179 | PX SEND HASH | :TQ10006 | 954K| 1 | 180 | VIEW | | 954K| 1 | 181 | SORT GROUP BY | | 954K| 1 PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- | 182 | PARTITION RANGE ALL | | 954K| 1 |*183 | TABLE ACCESS FULL | PROJ_INFO_LOOKUP_MONTHLY | 954K| 1 | 184 | BUFFER SORT | | | | 185 | PX RECEIVE | | 978K| 4 | 186 | PX SEND HASH | :TQ10007 | 978K| 4 | 187 | VIEW | NON_PERFORMING_LOANS_BY_TRCH | 978K| 4 | 188 | VIEW | | 978K| 6 | 189 | SORT GROUP BY | | 978K| 9 |*190 | HASH JOIN | | 978K| 9 |*191 | TABLE ACCESS FULL | TRANCHE | 13034 | 14 |*192 | TABLE ACCESS FULL | LOAN_NONACCRUAL_SUMMARY | 980K| 8 PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- | 193 | TABLE ACCESS BY INDEX ROWID | IFC_SECTOR | 1 | 3 |*194 | INDEX UNIQUE SCAN | XPKIFC_SECTOR | 1 | | 195 | TABLE ACCESS BY INDEX ROWID | IFC_SECTOR | 1 | 3 |*196 | INDEX UNIQUE SCAN | XPKIFC_SECTOR | 1 | ---------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 10 - access("TBV"."SUMMARY_DATE"="NPL"."SUMMARY_DATE"(+) AND "TBV"."PROJECT_ID"="NPL"."PROJECT_ID" "TBV"."CURRENCY_CODE"="NPL"."CURRENCY_CODE"(+)) PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- 13 - access("PILM"."SUMMARY_DATE"="INSTITUTION_STATUS_CODE"."SUMMARY_DATE" AND "PILM"."INSTITUTION 14 - access("PILM"."SUMMARY_DATE"="COMPANY_CREDIT_RISK_SUMMARY_V"."SUMMARY_DATE"(+) AND "PILM"."IN 15 - access("PILM"."SUMMARY_DATE"="IFC_COMPANYCOMMONOWNERSHIP"."SUMMARY_DATE"(+) AND "PILM"."INSTI 19 - access("PILM"."SUMMARY_DATE"="CLEAV"."SUMMARY_DATE"(+) AND "PILM"."COUNTRY_CODE"="CLEAV"."COU 24 - access("PILM"."SUMMARY_DATE"="PROJECT_AMOUNT_DUE_SUMMARY"."SUMMARY_DATE"(+) AND "PILM"."PROJE 35 - access("TRANCHE_INFO_LOOKUP_V"."SUMMARY_DATE"="TBV"."SUMMARY_DATE" AND "TRANCHE_INFO_LOOKUP_V "TRANCHE_INFO_LOOKUP_V"."TRANCHE_NBR"="TBV"."TRANCHE_NBR") 38 - access("TBV"."SUMMARY_DATE"="PROJECT_FYTD_ACTIVITY"."SUMMARY_DATE"(+) AND "TBV"."PROJECT_ID"= "TBV"."TRANCHE_NBR"="PROJECT_FYTD_ACTIVITY"."TRANCHE_NBR"(+) AND "TBV"."CURRENCY_CODE"="PROJE 41 - access("TBV"."TRANCHE_NBR">=0) 47 - access("ICS_1"."PROJECT_ID"="XYZ"."PROJECT_ID"(+) AND "ICS_1"."TRANCHE_NBR"="XYZ"."TRANCHE_NB PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- "ICS_1"."SUMMARY_DATE"="XYZ"."SUMMARY_DATE"(+)) 49 - filter("ICS_1"."SUMMARY_DATE">=TO_DATE(' 1999-07-31 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND 62 - filter("ATR"."INVESTMENT_LEVEL_CODE"='T' AND "ATR"."ACTIVE_IND"='Y') 63 - access("ATR"."AMOUNT_TYPE_CODE"='DIVINC' OR "ATR"."AMOUNT_TYPE_CODE"='IDSB' OR "ATR"."AMOUNT_ 64 - access("ATP"."AMOUNT_TYPE_CODE"="ATR"."AMOUNT_TYPE_CODE") filter("ATP"."AMOUNT_TYPE_CODE"='DIVINC' OR "ATP"."AMOUNT_TYPE_CODE"='IDSB' OR "ATP"."AMOUNT_ 66 - access("ATR"."BALANCE_RULE_NBR"="B"."BALANCE_RULE_NBR" AND "ATR"."SOURCE_SYSTEM_NME"="B"."SOU 68 - access("B"."GL_ACCOUNT_NBR"="A"."GL_ACCOUNT_NBR") 70 - access("B"."GL_ACCOUNT_NBR"="S"."GL_ACCOUNT_NBR" AND "B"."GL_SUB_ACCOUNT_NBR"="S"."GL_SUB_ACC filter("S"."GL_ACCOUNT_NBR"="A"."GL_ACCOUNT_NBR") 72 - filter("LA"."SUMMARY_DATE">=TO_DATE(' 1999-07-31 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "LA PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- 73 - access("LA"."GL_ACCOUNT_NBR"="A"."GL_ACCOUNT_NBR" AND "LA"."GL_SUB_ACCOUNT_NBR"="S"."GL_SUB_A filter("LA"."SUB_ACCOUNT_CODE"=NVL(RPAD(DECODE(TRIM("B"."SUB_ACCOUNT_CODE"),'%','',TRIM("B"." 74 - access("LA"."SUMMARY_DATE"="ICS"."SUMMARY_DATE" AND "LA"."PROJECT_ID"="ICS"."PROJECT_ID" AND filter(NVL("ICS"."OBLIGATION_NBR",0)=0 AND "ICS"."SUMMARY_DATE">=TO_DATE(' 1999-07-31 00:00:0 84 - access("A"."PROJECT_ID"="B"."PROJECT_ID" AND "A"."TRANCHE_NBR"="B"."TRANCHE_NBR") 89 - access("A"."TRANCHE_NBR">=0) 93 - filter("B"."TRANCHE_NBR">=0) 97 - access("X"."PROJECT_ID"="Y"."PROJECT_ID" AND "X"."TRANCHE_NBR"="Y"."TRANCHE_NBR") 99 - filter(("X"."PARTICIPANT_NBR"=6541 OR "X"."PARTICIPANT_NBR"=999999) AND "X"."AMOUNT_TYPE_CODE 100 - filter("Y"."TRANCHE_NBR">=0) 101 - filter("PORTFOLIO_ID"='IF') PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- 102 - access("TBV"."PROJECT_ID"="PROJECT_ID" AND "TBV"."TRANCHE_NBR"="TRANCHE_NBR") filter("TRANCHE_NBR">=0) 103 - filter("TBV"."CURRENCY_CODE"="SLR"."CURRENCY_CODE"(+)) 104 - filter(0<="TBV"."TRANCHE_NBR") 107 - access("T"."PROJECT_ID"="TBV"."PROJECT_ID" AND "T"."TRANCHE_NBR"="TBV"."TRANCHE_NBR") filter("T"."TRANCHE_NBR">=0) 108 - filter("SUMMARY_DATE"="TBV"."SUMMARY_DATE") 109 - access("R"."PROJECT_ID"="T"."PROJECT_ID" AND "R"."TRANCHE_NBR"="T"."TRANCHE_NBR") filter("R"."TRANCHE_NBR"="TBV"."TRANCHE_NBR" AND "R"."PROJECT_ID"="TBV"."PROJECT_ID" AND "R". 111 - filter(("PILM"."PROJECT_CATEGORY_CODE"='F' OR "PILM"."PROJECT_CATEGORY_CODE"='I') AND "PILM". "PILM"."IFC_SECTOR_CODE"<>' ') PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- 112 - access("PILM"."PROJECT_ID"="TBV"."PROJECT_ID" AND "PILM"."SUMMARY_DATE"="TBV"."SUMMARY_DATE") 114 - access("PILM"."IFC_SECTOR_CODE"="SEC"."IFC_SECTOR_CODE") filter("SEC"."IFC_SECTOR_CODE"<>' ' AND LENGTH("SEC"."IFC_SECTOR_CODE")>=4) 116 - access("PILM"."COUNTRY_CODE"="COUNTRY"."COUNTRY_CODE") 118 - access("PILM"."PROJECT_ID"="PROJ_INFO_LOOKUP"."PROJECT_ID") 120 - access("PROJ_INFO_LOOKUP"."INSTITUTION_NBR"="INSTITUTION_LOSS_RESERVE"."INSTITUTION_NBR"(+)) 126 - filter("ADS"."PORTFOLIO_REPORT_IND"='Y' AND ("ADS"."PARTICIPANT_NBR"=1 OR "ADS"."PARTICIPANT_ 128 - access("PILM"."INSTITUTION_NBR"="INSTITUTION"."INSTITUTION_NBR") 129 - access("INSTITUTION"."COUNTRY_CODE"="INSTITUTION_COUNTRY"."COUNTRY_CODE"(+)) 134 - access("COUNTRY_ALL"."COUNTRY_CODE"="COUNTRY_LENDING_ELIGIBILITY"."COUNTRY_CODE"(+) AND "COUN 143 - filter("COUNTRY_END_DATE" IS NULL) PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- 146 - access("COUNTRY_ALL"."FY"="FINANCIAL_PERIOD_DIM"."FY") 149 - access("PILM"."INSTITUTION_NBR"="VALUATION_SUMMARY_V"."INSTITUTION_NBR"(+) AND "PILM"."SUMMAR 157 - filter("VALUE_DATE"="MAX_VALUE_DATE" AND LTRIM("FEATURE_VALUE_TEXT",'0123456789.') IS NULL AN 164 - filter("VF"."VALUE_DATE"<="DT"."SUMMARY_DATE" AND "VF"."SHARE_TYPE_CODE"='COM') 170 - filter("EFFECTIVE_DATE"="MAX_EFFECTIVE_DATE") 175 - access(INTERNAL_FUNCTION("EFFECTIVE_DATE")<=INTERNAL_FUNCTION("S"."SUMMARY_DATE")) filter(INTERNAL_FUNCTION("EFFECTIVE_DATE")<=INTERNAL_FUNCTION("S"."SUMMARY_DATE")) 183 - filter(("PILM"."PROJECT_CATEGORY_CODE"='F' OR "PILM"."PROJECT_CATEGORY_CODE"='I') AND "PILM". 190 - access("LAS"."PROJECT_ID"="T"."PROJECT_ID" AND "LAS"."TRANCHE_NBR"="T"."TRANCHE_NBR") 191 - filter("T"."PORTFOLIO_ID"='IF' AND "T"."TRANCHE_NBR">=0 AND "T"."TRANCHE_NBR"<>90) 192 - filter("LAS"."TRANCHE_NBR">=0 AND "LAS"."TRANCHE_NBR"<>90) PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- 194 - access("SSEC"."IFC_SECTOR_CODE"=SUBSTR("SEC"."IFC_SECTOR_CODE",1,3)) 196 - access("MSEC"."IFC_SECTOR_CODE"=SUBSTR("SSEC"."IFC_SECTOR_CODE",1,1)) Note ----- - cpu costing is off (consider enabling it) 281 rows selected. Execution Plan ---------------------------------------------------------- Plan hash value: 3013799171 ----------------------------------------------------- | Id | Operation | Name | ----------------------------------------------------- | 0 | SELECT STATEMENT | | | 1 | COLLECTION ITERATOR PICKLER FETCH| DISPLAY | ----------------------------------------------------- Note ----- - rule based optimizer used (consider using cbo) SQL>