--------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| --------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 155 | | 390K (1)| | 1 | TABLE ACCESS BY INDEX ROWID BATCHED | FND_LOOKUP_VALUES | 1 | 51 | | 4 (0)| |* 2 | INDEX RANGE SCAN | FND_LOOKUP_VALUES_U1 | 1 | | | 3 (0)| | 3 | NESTED LOOPS ANTI | | 1 | 155 | | 390K (1)| | 4 | NESTED LOOPS | | 1 | 141 | | 390K (1)| |* 5 | HASH JOIN OUTER | | 1 | 114 | | 390K (1)| |* 6 | HASH JOIN | | 1 | 88 | 26M| 390K (1)| | 7 | NESTED LOOPS | | 1 | 88 | 26M| 390K (1)| | 8 | NESTED LOOPS | | | | | | | 9 | STATISTICS COLLECTOR | | | | | | |* 10 | HASH JOIN | | 346K| 22M| 12M| 300K (1)| | 11 | NESTED LOOPS | | 346K| 22M| 12M| 300K (1)| | 12 | STATISTICS COLLECTOR | | | | | | |* 13 | TABLE ACCESS FULL | AP_INVOICES_ALL | 260K| 9914K| | 27542 (2)| |* 14 | TABLE ACCESS BY INDEX ROWID BATCHED| ZX_LINES_DET_FACTORS | 1 | 28 | | 270K (1)| |* 15 | INDEX RANGE SCAN | ZX_LINES_DET_FACTORS_N2 | | | | | |* 16 | TABLE ACCESS FULL | ZX_LINES_DET_FACTORS | 2372K| 63M| | 270K (1)| |* 17 | INDEX UNIQUE SCAN | AP_INVOICE_LINES_U1 | | | | | | 18 | TABLE ACCESS BY INDEX ROWID | AP_INVOICE_LINES_ALL | 1 | 21 | | 83326 (1)| | 19 | TABLE ACCESS FULL | AP_INVOICE_LINES_ALL | 10M| 212M| | 83326 (1)| |* 20 | TABLE ACCESS FULL | XXEBTAX_EXCEPTION_TAB | 262 | 6812 | | 10 (0)| | 21 | TABLE ACCESS BY INDEX ROWID | AP_SUPPLIERS | 1 | 27 | | 1 (0)| |* 22 | INDEX UNIQUE SCAN | AP_SUPPLIERS_U1 | 1 | | | 0 (0)| |* 23 | TABLE ACCESS BY INDEX ROWID BATCHED | ZX_LINES | 82386 | 1126K| | 3 (0)| |* 24 | INDEX RANGE SCAN | ZX_LINES_N4 | 1 | | | 2 (0)| --------------------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 2 - access("LOOKUP_TYPE"='XXAR_UK_TAX_QT_MT' AND "LOOKUP_CODE"=TO_CHAR(:B1,'MON-YYYY') AND "LANGUAGE"=USERENV('LANG') AND "ZD_EDITION_NAME"='SET1') filter("LOOKUP_CODE"=TO_CHAR(:B1,'MON-YYYY') AND "LANGUAGE"=USERENV('LANG') AND "ZD_EDITION_NAME"='SET1') 5 - access("XXEBTAX_EXCEPTION_TAB"."TRX_NUM"(+)="AP"."INVOICE_NUM" AND "XXEBTAX_EXCEPTION_TAB"."LINE_NUM"(+)="A3"."LINE_NUMBER" AND "XXEBTAX_EXCEPTION_TAB"."ORG_ID"(+)="AP"."ORG_ID") 6 - access("A3"."INVOICE_ID"="AP"."INVOICE_ID" AND "ZLD"."TRX_LINE_ID"="A3"."LINE_NUMBER") 10 - access("ZLD"."TRX_ID"="AP"."INVOICE_ID") 13 - filter("AP"."ORG_ID"=126 AND "CANCELLED_DATE" IS NULL AND "BATCH_ID"<>2160103 AND "AP"."INVOICE_NUM"<>'SCCUKLTD1' AND "AP"."INVOICE_NUM"<>'002P523506' AND "AP"."INVOICE_NUM"<>'1410011398DD') 14 - filter("ZLD"."INTERNAL_ORGANIZATION_ID"=126 AND "ZLD"."LINE_AMT"<>0) 15 - access("ZLD"."TRX_ID"="AP"."INVOICE_ID") 16 - filter("ZLD"."INTERNAL_ORGANIZATION_ID"=126 AND "ZLD"."LINE_AMT"<>0) 17 - access("A3"."INVOICE_ID"="AP"."INVOICE_ID" AND "ZLD"."TRX_LINE_ID"="A3"."LINE_NUMBER") 20 - filter("ORG_ID"(+)=126 AND "XXEBTAX_EXCEPTION_TAB"."TRX_NUM"(+)<>'SCCUKLTD1' AND "XXEBTAX_EXCEPTION_TAB"."TRX_NUM"(+)<>'002P523506' AND "XXEBTAX_EXCEPTION_TAB"."TRX_NUM"(+)<>'1410011398DD') 22 - access("AP"."VENDOR_ID"="APS"."VENDOR_ID") 23 - filter("ZL"."INTERNAL_ORGANIZATION_ID"=126) 24 - access("ZLD"."TRX_ID"="ZL"."TRX_ID" AND "ZLD"."TRX_LINE_ID"="ZL"."TRX_LINE_ID") filter("ZLD"."TRX_LINE_ID"="ZL"."TRX_LINE_ID") Note ----- - 'PLAN_TABLE' is old version