erp里10几张表关联，表数据量都不大，有个表 CE.CE_PAYMENT_DOCUMENTS 数据量只有19528，条件过滤后只有906条记录，sql过滤条件中payment_document_name Like 'SW%' 走了索引，现在就是走了这个索引就好慢，不走索引就快，从执行计划中找不出原因，望各位大侠帮小妹看看，谢谢了！
慢的执行计划：
SQL_IDaf1z3yu7bj8xs, child number 0
-------------------------------------
/*CREATE OR REPLACE VIEW HW_SWIFT_PAYMENT_ALL_V AS*/SELECT
BOOK.DESCRIPTION as companyName,BOOK.SET_OF_BOOKS_ID as
setOfBookID,payment.Check_Id As checkid,
PAYMENT.STATUS_LOOKUP_CODE As erpstatus,
VENDOR.VENDOR_TYPE_LOOKUP_CODE as vendorType,
iepa.delivery_channel_code as deliveryChannel,VENDOR.SEGMENT1
as vendorCode,VENDOR_SITE.VENDOR_SITE_CODE as vendorSiteName,
DECODE(BOOK.CURRENCY_CODE,
'RMB',
'CNY',
BOOK.CURRENCY_CODE) as bookCurrency,
DECODE(BATCH.CHECKRUN_ID,
NULL,
TO_CHAR(PAYMENT.CHECK_NUMBER),
BATCH.CHECKRUN_NAME) as
paymentBatchName,PAYMENT_DOCUMENT.PAYMENT_DOCUMENT_NAME as
paymentDoucumentName,TO_CHAR(DECODE(BATCH.CHECKRUN_ID,
NULL,
NVL(PAYMENT.ANTICIPATED_VALUE_DATE,
PAYMENT.CHECK_DATE),
NVL(BATCH.ANTICIPATED_VALUE_D
Plan hash value: 4074448643
-----------------------------------------------------------------------------------------------------------------------------------
| Id| Operation
| Name
| Rows| Bytes | Cost (%CPU)| Time |
-----------------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT
|
| | |3502 (100)|
|
| 1 |NESTED LOOPS OUTER
|
| 1 |2059 |3502 (1)| 00:00:43 |
| 2 | NESTED LOOPS
|
| 1 |1056 |3475 (1)| 00:00:42 |
| 3 |NESTED LOOPS OUTER
|
| 1 |1029 |3473 (1)| 00:00:42 |
|*4 | HASH JOIN OUTER
|
| 1 | 956 |3472 (1)| 00:00:42 |
| 5 |NESTED LOOPS OUTER
|
| 1 | 945 |2681 (1)| 00:00:33 |
| 6 | NESTED LOOPS
|
| 1 | 917 |2678 (1)| 00:00:33 |
| 7 |NESTED LOOPS OUTER
|
| 1 | 890 |2676 (1)| 00:00:33 |
| 8 | NESTED LOOPS OUTER
|
| 1 | 860 |2673 (1)| 00:00:33 |
| 9 |
NESTED LOOPS
|
| 1 | 833 |2670 (1)| 00:00:33 |
|10 | NESTED LOOPS OUTER
|
| 1 | 810 |2667 (1)| 00:00:33 |
|11 |
NESTED LOOPS
|
| 1 | 766 |2665 (1)| 00:00:32 |
|12 |
NESTED LOOPS
|
| 1 | 710 |2662 (1)| 00:00:32 |
|13 |
NESTED LOOPS
|
| 1 | 651 |2660 (1)| 00:00:32 |
|14 |
NESTED LOOPS
|
| 1 | 595 |2657 (1)| 00:00:32 |
|15 |
NESTED LOOPS
|
| 1 | 516 |2654 (1)| 00:00:32 |
|16 |
NESTED LOOPS
|
| 1 | 463 |2651 (1)| 00:00:32 |
|17 |
NESTED LOOPS
|
| 1 | 398 |2650 (1)| 00:00:32 |
|18 |
NESTED LOOPS OUTER
|
| 1 | 388 |2649 (1)| 00:00:32 |
|19 |
NESTED LOOPS
|
| 1 | 228 | 171 (1)| 00:00:03 |
|20 |
NESTED LOOPS
|
| 3 | 540 | 168 (1)| 00:00:03 |
|* 21 |
HASH JOIN
|
| 3 | 483 | 162 (1)| 00:00:02 |
|22 |
TABLE ACCESS BY INDEX ROWID| CE_PAYMENT_DOCUMENTS | 3 |57 | 5 (0)| 00:00:01 |
|* 23 |
INDEX RANGE SCAN
| CE_PAYMENT_DOCUMENTS_N1| 3 | | 2 (0)| 00:00:01 |
|24 |
TABLE ACCESS BY INDEX ROWID| AP_CHECKS_ALL
|1345 | 186K| 156 (0)| 00:00:02 |
|* 25 |
INDEX RANGE SCAN
| AP_CHECKS_N1
|1345 | |10 (0)| 00:00:01 |
|26 |
TABLE ACCESS BY INDEX ROWID | HR_ORGANIZATION_INFORMATION| 1 |19 | 2 (0)| 00:00:01 |
|* 27 |
INDEX RANGE SCAN | HR_ORGANIZATION_INFORMATIO_FK2 | 1 | | 1 (0)| 00:00:01 |
|* 28 |
TABLE ACCESS BY INDEX ROWID| GL_LEDGERS
| 1 |48 | 1 (0)| 00:00:01 |
|* 29 |
INDEX UNIQUE SCAN | GL_LEDGERS_U2
| 1 | | 0 (0)|
|
|30 |
VIEW PUSHED PREDICATE | HW_AP_PAYMENTCHECKRUN_V| 1 | 160 |2478 (1)| 00:00:30 |
|31 |
NESTED LOOPS
|
| 1 |45 |2478 (1)| 00:00:30 |
|32 |
TABLE ACCESS BY INDEX ROWID | AP_INV_SELECTION_CRITERIA_ALL| 1 |33 | 2 (0)| 00:00:01 |
|* 33 |
INDEX UNIQUE SCAN
| AP_INV_SELECTION_CRITERIA_U2 | 1 | | 1 (0)| 00:00:01 |
|* 34 |
TABLE ACCESS FULL | IBY_PAY_SERVICE_REQUESTS | 1 |12 |2476 (1)| 00:00:30 |
|35 |
TABLE ACCESS BY INDEX ROWID| CE_BANK_ACCT_USES_ALL
| 1 |10 | 1 (0)| 00:00:01 |
|* 36 |
INDEX UNIQUE SCAN
| CE_BANK_ACCT_USES_U1 | 1 | | 0 (0)|
|
|37 |
TABLE ACCESS BY INDEX ROWID | CE_BANK_ACCOUNTS
| 1 |65 | 1 (0)| 00:00:01 |
|* 38 |
INDEX UNIQUE SCAN
| CE_BANK_ACCOUNTS_U1
| 1 | | 0 (0)|
|
|* 39 |
TABLE ACCESS BY INDEX ROWID| HZ_ORGANIZATION_PROFILES | 1 |53 | 3 (0)| 00:00:01 |
|* 40 |
INDEX RANGE SCAN
| HZ_ORGANIZATION_PROFILES_N1| 1 | | 2 (0)| 00:00:01 |
|* 41 |
TABLE ACCESS BY INDEX ROWID | HZ_RELATIONSHIPS
| 1 |79 | 3 (0)| 00:00:01 |
|* 42 |
INDEX RANGE SCAN
| HZ_RELATIONSHIPS_N6
| 2 | | 2 (0)| 00:00:01 |
|* 43 |
TABLE ACCESS BY INDEX ROWID| HZ_CODE_ASSIGNMENTS
| 1 |56 | 3 (0)| 00:00:01 |
|* 44 |
INDEX RANGE SCAN
| HZ_CODE_ASSIGNMENTS_U2 | 1 | | 2 (0)| 00:00:01 |
|* 45 |
TABLE ACCESS BY INDEX ROWID | HZ_PARTIES
| 1 |59 | 2 (0)| 00:00:01 |
|* 46 |
INDEX UNIQUE SCAN
| HZ_PARTIES_U1
| 1 | | 1 (0)| 00:00:01 |
|* 47 |
TABLE ACCESS BY INDEX ROWID
| HZ_CODE_ASSIGNMENTS
| 1 |56 | 3 (0)| 00:00:01 |
|* 48 |
INDEX RANGE SCAN
| HZ_CODE_ASSIGNMENTS_U2 | 1 | | 2 (0)| 00:00:01 |
|* 49 |
TABLE ACCESS BY INDEX ROWID | HZ_CODE_ASSIGNMENTS
| 1 |44 | 2 (0)| 00:00:01 |
|* 50 |
INDEX RANGE SCAN
| HZ_CODE_ASSIGNMENTS_U2 | 1 | | 2 (0)| 00:00:01 |
|* 51 | TABLE ACCESS BY INDEX ROWID
| HZ_ORGANIZATION_PROFILES | 1 |23 | 3 (0)| 00:00:01 |
|* 52 |
INDEX RANGE SCAN
| HZ_ORGANIZATION_PROFILES_N1| 1 | | 2 (0)| 00:00:01 |
|* 53 |
TABLE ACCESS BY INDEX ROWID
| HZ_CONTACT_POINTS
| 1 |27 | 3 (0)| 00:00:01 |
|* 54 | INDEX RANGE SCAN
| HZ_CONTACT_POINTS_N6 | 1 | | 2 (0)| 00:00:01 |
|* 55 | TABLE ACCESS BY INDEX ROWID
| HZ_CONTACT_POINTS
| 1 |30 | 3 (0)| 00:00:01 |
|* 56 |
INDEX RANGE SCAN
| HZ_CONTACT_POINTS_N6 | 1 | | 2 (0)| 00:00:01 |
|57 |TABLE ACCESS BY INDEX ROWID
| AP_SUPPLIER_SITES_ALL
| 1 |27 | 2 (0)| 00:00:01 |
|* 58 | INDEX UNIQUE SCAN
| AP_SUPPLIER_SITES_U1 | 1 | | 1 (0)| 00:00:01 |
|59 | TABLE ACCESS BY INDEX ROWID
| IBY_EXTERNAL_PAYEES_ALL| 1 |28 | 3 (0)| 00:00:01 |
|* 60 |INDEX RANGE SCAN
| IBY_EXTERNAL_PAYEES_ALL_N7 | 1 | | 2 (0)| 00:00:01 |
|61 |TABLE ACCESS FULL
| IBY_PMT_INSTR_USES_ALL | 169K|1822K| 789 (1)| 00:00:10 |
|62 | TABLE ACCESS BY INDEX ROWID
| IBY_EXT_BANK_ACCOUNTS
| 1 |73 | 1 (0)| 00:00:01 |
|* 63 |INDEX UNIQUE SCAN
| IBY_EXT_BANK_ACCOUNTS_U1 | 1 | | 0 (0)|
|
|64 |TABLE ACCESS BY INDEX ROWID
| AP_SUPPLIERS
| 1 |27 | 2 (0)| 00:00:01 |
|* 65 | INDEX UNIQUE SCAN
| AP_SUPPLIERS_U1
| 1 | | 1 (0)| 00:00:01 |
|66 | VIEW PUSHED PREDICATE
| CE_BANK_BRANCHES_V
| 1 |1003 |27 (0)| 00:00:01 |
|* 67 |FILTER
|
| | |
|
|
|68 | MERGE JOIN CARTESIAN
|
| 1 | 438 |27 (0)| 00:00:01 |
|69 |MERGE JOIN CARTESIAN
|
| 1 | 382 |24 (0)| 00:00:01 |
|70 | NESTED LOOPS OUTER
|
| 1 | 359 |21 (0)| 00:00:01 |
|71 |NESTED LOOPS OUTER
|
| 1 | 315 |18 (0)| 00:00:01 |
|72 | NESTED LOOPS OUTER
|
| 1 | 285 |15 (0)| 00:00:01 |
|73 |
NESTED LOOPS
|
| 1 | 258 |12 (0)| 00:00:01 |
|74 | NESTED LOOPS
|
| 1 | 179 | 9 (0)| 00:00:01 |
|75 |
NESTED LOOPS
|
| 1 | 128 | 6 (0)| 00:00:01 |
|* 76 |
TABLE ACCESS BY INDEX ROWID
| HZ_PARTIES
| 1 |72 | 3 (0)| 00:00:01 |
|* 77 |
INDEX UNIQUE SCAN
| HZ_PARTIES_U1
| 1 | | 2 (0)| 00:00:01 |
|* 78 |
TABLE ACCESS BY INDEX ROWID
| HZ_CODE_ASSIGNMENTS
| 1 |56 | 3 (0)| 00:00:01 |
|* 79 |
INDEX RANGE SCAN
| HZ_CODE_ASSIGNMENTS_U2 | 1 | | 2 (0)| 00:00:01 |
|* 80 |
TABLE ACCESS BY INDEX ROWID | HZ_ORGANIZATION_PROFILES | 1 |51 | 3 (0)| 00:00:01 |
|* 81 |
INDEX RANGE SCAN
| HZ_ORGANIZATION_PROFILES_N1| 1 | | 2 (0)| 00:00:01 |
|* 82 | TABLE ACCESS BY INDEX ROWID
| HZ_RELATIONSHIPS
| 1 |79 | 3 (0)| 00:00:01 |
|* 83 |
INDEX RANGE SCAN
| HZ_RELATIONSHIPS_N2
| 1 | | 2 (0)| 00:00:01 |
|* 84 |
TABLE ACCESS BY INDEX ROWID
| HZ_CONTACT_POINTS
| 1 |27 | 3 (0)| 00:00:01 |
|* 85 | INDEX RANGE SCAN
| HZ_CONTACT_POINTS_N6 | 1 | | 2 (0)| 00:00:01 |
|* 86 | TABLE ACCESS BY INDEX ROWID
| HZ_CONTACT_POINTS
| 1 |30 | 3 (0)| 00:00:01 |
|* 87 |
INDEX RANGE SCAN
| HZ_CONTACT_POINTS_N6 | 1 | | 2 (0)| 00:00:01 |
|* 88 |TABLE ACCESS BY INDEX ROWID
| HZ_CODE_ASSIGNMENTS
| 1 |44 | 3 (0)| 00:00:01 |
|* 89 | INDEX RANGE SCAN
| HZ_CODE_ASSIGNMENTS_U2 | 1 | | 2 (0)| 00:00:01 |
|90 | BUFFER SORT
|
| 1 |23 |21 (0)| 00:00:01 |
|* 91 |TABLE ACCESS BY INDEX ROWID
| HZ_ORGANIZATION_PROFILES | 1 |23 | 3 (0)| 00:00:01 |
|* 92 | INDEX RANGE SCAN
| HZ_ORGANIZATION_PROFILES_N1| 1 | | 2 (0)| 00:00:01 |
|93 |BUFFER SORT
|
| 1 |56 |24 (0)| 00:00:01 |
|* 94 | TABLE ACCESS BY INDEX ROWID
| HZ_CODE_ASSIGNMENTS
| 1 |56 | 3 (0)| 00:00:01 |
|* 95 |INDEX RANGE SCAN
| HZ_CODE_ASSIGNMENTS_U2 | 1 | | 2 (0)| 00:00:01 |
-----------------------------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
4 - access("IEPA"."EXT_PAYEE_ID"="IBYU"."EXT_PMT_PARTY_ID")
21 - access("PAYMENT"."PAYMENT_DOCUMENT_ID"="PAYMENT_DOCUMENT"."PAYMENT_DOCUMENT_ID")
23 - access("PAYMENT_DOCUMENT"."PAYMENT_DOCUMENT_NAME" LIKE 'SW%')
filter("PAYMENT_DOCUMENT"."PAYMENT_DOCUMENT_NAME" LIKE 'SW%')
25 - access("PAYMENT"."CHECK_DATE">=SYSDATE@!-7)
27 - access("ORG"."ORGANIZATION_ID"="PAYMENT"."ORG_ID" AND "ORG"."ORG_INFORMATION_CONTEXT"='Operating Unit Information')
28 - filter(("OBJECT_TYPE_CODE"='L' AND NVL("COMPLETE_FLAG",'Y')='Y'))
29 - access("LGR"."LEDGER_ID"=TO_NUMBER("ORG"."ORG_INFORMATION3"))
33 - access("AISC"."CHECKRUN_ID"="PAYMENT"."CHECKRUN_ID")
34 - filter("IPSR"."CALL_APP_PAY_SERVICE_REQ_CODE"="AISC"."CHECKRUN_NAME")
36 - access("PAYMENT"."CE_BANK_ACCT_USE_ID"="CBAU"."BANK_ACCT_USE_ID")
38 - access("CBAU"."BANK_ACCOUNT_ID"="BANK_ACCOUNT"."BANK_ACCOUNT_ID")
39 - filter((TRUNC(INTERNAL_FUNCTION("EFFECTIVE_START_DATE"))=SYSDATE@! AND "ACTUAL_CONTENT_SOURCE"='SST'))
40 - access("BANK_ACCOUNT"."BANK_ID"="PARTY_ID")
41 - filter(("BRREL"."RELATIONSHIP_TYPE"='BANK_AND_BRANCH' AND "BRREL"."STATUS"='A' AND
"BRREL"."SUBJECT_TABLE_NAME"='HZ_PARTIES' AND "BRREL"."SUBJECT_TYPE"='ORGANIZATION' AND
"BRREL"."OBJECT_TYPE"='ORGANIZATION'))
42 - access("PARTY_ID"="BRREL"."OBJECT_ID" AND "BRREL"."OBJECT_TABLE_NAME"='HZ_PARTIES' AND
"BRREL"."RELATIONSHIP_CODE"='BRANCH_OF')
43 - filter(("BANKCA"."STATUS"='A' OR "BANKCA"."STATUS" IS NULL))
44 - access("BANKCA"."OWNER_TABLE_ID"="PARTY_ID" AND "BANKCA"."OWNER_TABLE_NAME"='HZ_PARTIES' AND
"BANKCA"."CLASS_CATEGORY"='BANK_INSTITUTION_TYPE')
filter(("BANKCA"."CLASS_CATEGORY"='BANK_INSTITUTION_TYPE' AND INTERNAL_FUNCTION("BANKCA"."CLASS_CODE") AND
"BANKCA"."OWNER_TABLE_NAME"='HZ_PARTIES'))
45 - filter(("BRANCHPARTY"."PARTY_TYPE"='ORGANIZATION' AND "BRANCHPARTY"."STATUS"='A'))
46 - access("BRREL"."SUBJECT_ID"="BRANCHPARTY"."PARTY_ID")
filter("BANK_ACCOUNT"."BANK_BRANCH_ID"="BRANCHPARTY"."PARTY_ID")
47 - filter(("BRANCHCA"."STATUS"='A' OR "BRANCHCA"."STATUS" IS NULL))
48 - access("BRANCHCA"."OWNER_TABLE_ID"="BRANCHPARTY"."PARTY_ID" AND "BRANCHCA"."OWNER_TABLE_NAME"='HZ_PARTIES' AND
"BRANCHCA"."CLASS_CATEGORY"='BANK_INSTITUTION_TYPE')
filter(("BRANCHCA"."CLASS_CATEGORY"='BANK_INSTITUTION_TYPE' AND INTERNAL_FUNCTION("BRANCHCA"."CLASS_CODE") AND
"BRANCHCA"."OWNER_TABLE_NAME"='HZ_PARTIES'))
49 - filter(("BRANCHTYPECA"."PRIMARY_FLAG"='Y' AND "BRANCHTYPECA"."STATUS"='A'))
50 - access("BRANCHTYPECA"."OWNER_TABLE_ID"="BRANCHPARTY"."PARTY_ID" AND "BRANCHTYPECA"."OWNER_TABLE_NAME"='HZ_PARTIES'
AND "BRANCHTYPECA"."CLASS_CATEGORY"='BANK_BRANCH_TYPE')
filter(("BRANCHTYPECA"."CLASS_CATEGORY"='BANK_BRANCH_TYPE' AND "BRANCHTYPECA"."OWNER_TABLE_NAME"='HZ_PARTIES'))
51 - filter((TRUNC(INTERNAL_FUNCTION("EFFECTIVE_START_DATE"))=SYSDATE@! AND "ACTUAL_CONTENT_SOURCE"='SST'))
52 - access("PARTY_ID"="BRANCHPARTY"."PARTY_ID")
53 - filter("EDICP"."STATUS"='A')
54 - access("EDICP"."OWNER_TABLE_ID"="BRANCHPARTY"."PARTY_ID" AND "EDICP"."OWNER_TABLE_NAME"='HZ_PARTIES' AND
"EDICP"."CONTACT_POINT_TYPE"='EDI')
55 - filter("BRANCHCP"."STATUS"='A')
56 - access("BRANCHCP"."OWNER_TABLE_ID"="BRANCHPARTY"."PARTY_ID" AND "BRANCHCP"."OWNER_TABLE_NAME"='HZ_PARTIES' AND
"BRANCHCP"."CONTACT_POINT_TYPE"='EFT')
58 - access("PAYMENT"."VENDOR_SITE_ID"="VENDOR_SITE"."VENDOR_SITE_ID")
60 - access("VENDOR_SITE"."VENDOR_SITE_ID"="IEPA"."SUPPLIER_SITE_ID")
filter("IEPA"."SUPPLIER_SITE_ID" IS NOT NULL)
63 - access("IBYU"."INSTRUMENT_ID"="BANK_ACCOUNT_VENDOR"."EXT_BANK_ACCOUNT_ID")
65 - access("VENDOR"."VENDOR_ID"="VENDOR_SITE"."VENDOR_ID")
67 - filter(("BANK_ACCOUNT_VENDOR"."BANK_ID"="BANK_ACCOUNT_VENDOR"."BANK_ID" AND
"BANK_ACCOUNT_VENDOR"."BRANCH_ID"="BANK_ACCOUNT_VENDOR"."BRANCH_ID"))
76 - filter(("BRANCHPARTY"."PARTY_TYPE"='ORGANIZATION' AND "BRANCHPARTY"."STATUS"='A'))
77 - access("BRANCHPARTY"."PARTY_ID"="BANK_ACCOUNT_VENDOR"."BRANCH_ID")
78 - filter(("BANKCA"."STATUS"='A' OR "BANKCA"."STATUS" IS NULL))
79 - access("BANKCA"."OWNER_TABLE_ID"="BANK_ACCOUNT_VENDOR"."BANK_ID" AND "BANKCA"."OWNER_TABLE_NAME"='HZ_PARTIES' AND
"BANKCA"."CLASS_CATEGORY"='BANK_INSTITUTION_TYPE')
filter(("BANKCA"."CLASS_CATEGORY"='BANK_INSTITUTION_TYPE' AND INTERNAL_FUNCTION("BANKCA"."CLASS_CODE") AND
"BANKCA"."OWNER_TABLE_NAME"='HZ_PARTIES' AND "BANKCA"."OWNER_TABLE_ID"="BANK_ACCOUNT_VENDOR"."BANK_ID"))
80 - filter((TRUNC(INTERNAL_FUNCTION("EFFECTIVE_START_DATE"))=SYSDATE@! AND "ACTUAL_CONTENT_SOURCE"='SST'))
81 - access("PARTY_ID"="BANK_ACCOUNT_VENDOR"."BANK_ID")
filter(("BANKCA"."OWNER_TABLE_ID"="PARTY_ID" AND "PARTY_ID"="BANK_ACCOUNT_VENDOR"."BANK_ID"))
82 - filter(("BRREL"."RELATIONSHIP_TYPE"='BANK_AND_BRANCH' AND "BRREL"."RELATIONSHIP_CODE"='BRANCH_OF' AND
"BRREL"."STATUS"='A' AND "BRREL"."SUBJECT_TABLE_NAME"='HZ_PARTIES' AND "BRREL"."OBJECT_TABLE_NAME"='HZ_PARTIES'))
83 - access("BRREL"."OBJECT_ID"="BANK_ACCOUNT_VENDOR"."BANK_ID" AND "BRREL"."OBJECT_TYPE"='ORGANIZATION' AND
"BRREL"."SUBJECT_ID"="BANK_ACCOUNT_VENDOR"."BRANCH_ID" AND "BRREL"."SUBJECT_TYPE"='ORGANIZATION')
filter(("PARTY_ID"="BRREL"."OBJECT_ID" AND "BRREL"."OBJECT_ID"="BANK_ACCOUNT_VENDOR"."BANK_ID"))
84 - filter("EDICP"."STATUS"='A')
85 - access("EDICP"."OWNER_TABLE_ID"="BANK_ACCOUNT_VENDOR"."BRANCH_ID" AND "EDICP"."OWNER_TABLE_NAME"='HZ_PARTIES' AND
"EDICP"."CONTACT_POINT_TYPE"='EDI')
filter(("EDICP"."OWNER_TABLE_ID"="BRANCHPARTY"."PARTY_ID" AND
"EDICP"."OWNER_TABLE_ID"="BANK_ACCOUNT_VENDOR"."BRANCH_ID"))
86 - filter("BRANCHCP"."STATUS"='A')
87 - access("BRANCHCP"."OWNER_TABLE_ID"="BANK_ACCOUNT_VENDOR"."BRANCH_ID" AND "BRANCHCP"."OWNER_TABLE_NAME"='HZ_PARTIES'
AND "BRANCHCP"."CONTACT_POINT_TYPE"='EFT')
filter(("BRANCHCP"."OWNER_TABLE_ID"="BRANCHPARTY"."PARTY_ID" AND
"BRANCHCP"."OWNER_TABLE_ID"="BANK_ACCOUNT_VENDOR"."BRANCH_ID"))
88 - filter(("BRANCHTYPECA"."PRIMARY_FLAG"='Y' AND "BRANCHTYPECA"."STATUS"='A'))
89 - access("BRANCHTYPECA"."OWNER_TABLE_ID"="BANK_ACCOUNT_VENDOR"."BRANCH_ID" AND
"BRANCHTYPECA"."OWNER_TABLE_NAME"='HZ_PARTIES' AND "BRANCHTYPECA"."CLASS_CATEGORY"='BANK_BRANCH_TYPE')
filter(("BRANCHTYPECA"."CLASS_CATEGORY"='BANK_BRANCH_TYPE' AND "BRANCHTYPECA"."OWNER_TABLE_NAME"='HZ_PARTIES' AND
"BRANCHTYPECA"."OWNER_TABLE_ID"="BRANCHPARTY"."PARTY_ID" AND "BRANCHTYPECA"."OWNER_TABLE_ID"="BANK_ACCOUNT_VENDOR"."BRANCH_
ID"))
91 - filter((TRUNC(INTERNAL_FUNCTION("EFFECTIVE_START_DATE"))=SYSDATE@! AND "ACTUAL_CONTENT_SOURCE"='SST'))
92 - access("PARTY_ID"="BANK_ACCOUNT_VENDOR"."BRANCH_ID")
94 - filter(("BRANCHCA"."STATUS"='A' OR "BRANCHCA"."STATUS" IS NULL))
95 - access("BRANCHCA"."OWNER_TABLE_ID"="BANK_ACCOUNT_VENDOR"."BRANCH_ID" AND "BRANCHCA"."OWNER_TABLE_NAME"='HZ_PARTIES'
AND "BRANCHCA"."CLASS_CATEGORY"='BANK_INSTITUTION_TYPE')
filter(("BRANCHCA"."CLASS_CATEGORY"='BANK_INSTITUTION_TYPE' AND INTERNAL_FUNCTION("BRANCHCA"."CLASS_CODE") AND
"BRANCHCA"."OWNER_TABLE_NAME"='HZ_PARTIES'))
复制代码
快的执行计划：
SQL_ID0kvpb12t9b317, child number 0
-------------------------------------
/*CREATE OR REPLACE VIEW HW_SWIFT_PAYMENT_ALL_V AS*/SELECT
BOOK.DESCRIPTION as companyName,BOOK.SET_OF_BOOKS_ID as
setOfBookID,payment.Check_Id As checkid,
PAYMENT.STATUS_LOOKUP_CODE As erpstatus,
VENDOR.VENDOR_TYPE_LOOKUP_CODE as vendorType,
iepa.delivery_channel_code as deliveryChannel,VENDOR.SEGMENT1
as vendorCode,VENDOR_SITE.VENDOR_SITE_CODE as vendorSiteName,
DECODE(BOOK.CURRENCY_CODE,
'RMB',
'CNY',
BOOK.CURRENCY_CODE) as bookCurrency,
DECODE(BATCH.CHECKRUN_ID,
NULL,
TO_CHAR(PAYMENT.CHECK_NUMBER),
BATCH.CHECKRUN_NAME) as
paymentBatchName,PAYMENT_DOCUMENT.PAYMENT_DOCUMENT_NAME as
paymentDoucumentName,TO_CHAR(DECODE(BATCH.CHECKRUN_ID,
NULL,
NVL(PAYMENT.ANTICIPATED_VALUE_DATE,
PAYMENT.CHECK_DATE),
NVL(BATCH.ANTICIPATED_VALUE_D
Plan hash value: 2770800619
------------------------------------------------------------------------------------------------------------------------------------
| Id| Operation
| Name
| Rows| Bytes | Cost (%CPU)| Time |
------------------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT
|
| | |3517 (100)|
|
| 1 |NESTED LOOPS OUTER
|
| 1 |2059 |3517 (1)| 00:00:43 |
| 2 | NESTED LOOPS OUTER
|
| 1 |1899 |1039 (1)| 00:00:13 |
| 3 |NESTED LOOPS OUTER
|
| 1 | 896 |1012 (1)| 00:00:13 |
|*4 | HASH JOIN OUTER
|
| 1 | 823 |1011 (1)| 00:00:13 |
| 5 |NESTED LOOPS
|
| | |
|
|
| 6 | NESTED LOOPS
|
| 1 | 812 | 220 (1)| 00:00:03 |
| 7 |NESTED LOOPS
|
| 1 | 756 | 217 (1)| 00:00:03 |
| 8 | NESTED LOOPS OUTER
|
| 1 | 700 | 215 (1)| 00:00:03 |
| 9 |
NESTED LOOPS OUTER
|
| 1 | 656 | 212 (1)| 00:00:03 |
|10 | NESTED LOOPS OUTER
|
| 1 | 626 | 209 (1)| 00:00:03 |
|11 |
NESTED LOOPS
|
| 1 | 599 | 206 (1)| 00:00:03 |
|12 |
NESTED LOOPS OUTER
|
| 1 | 580 | 204 (1)| 00:00:03 |
|13 |
NESTED LOOPS
|
| 1 | 552 | 201 (1)| 00:00:03 |
|14 |
NESTED LOOPS
|
| 1 | 525 | 199 (1)| 00:00:03 |
|15 |
NESTED LOOPS
|
| 1 | 498 | 197 (1)| 00:00:03 |
|16 |
NESTED LOOPS
|
| 1 | 445 | 194 (1)| 00:00:03 |
|17 |
NESTED LOOPS
|
| 1 | 422 | 191 (1)| 00:00:03 |
|18 |
NESTED LOOPS
|
| 3 |1029 | 183 (1)| 00:00:03 |
|19 |
NESTED LOOPS
|
| 3 | 852 | 177 (1)| 00:00:03 |
|20 |
NESTED LOOPS
|
| 3 | 657 | 174 (1)| 00:00:03 |
|21 |
NESTED LOOPS
|
| 3 | 627 | 171 (1)| 00:00:03 |
|* 22 |
HASH JOIN
|
| 1 |67 |16 (7)| 00:00:01 |
|23 |
TABLE ACCESS BY INDEX ROWID| HR_ORGANIZATION_INFORMATION| 162 |3078 |10 (0)| 00:00:01 |
|* 24 |
INDEX RANGE SCAN
| HR_ORGANIZATION_INFORMATIO_FK1 | 162 | | 3 (0)| 00:00:01 |
|* 25 |
TABLE ACCESS FULL
| GL_LEDGERS
| 193 |9264 | 5 (0)| 00:00:01 |
|* 26 |
TABLE ACCESS BY INDEX ROWID | AP_CHECKS_ALL
| 4 | 568 | 155 (0)| 00:00:02 |
|* 27 |
INDEX RANGE SCAN | AP_CHECKS_N1
|1345 | | 9 (0)| 00:00:01 |
|28 |
TABLE ACCESS BY INDEX ROWID| CE_BANK_ACCT_USES_ALL
| 1 |10 | 1 (0)| 00:00:01 |
|* 29 |
INDEX UNIQUE SCAN | CE_BANK_ACCT_USES_U1 | 1 | | 0 (0)|
|
|30 |
TABLE ACCESS BY INDEX ROWID | CE_BANK_ACCOUNTS
| 1 |65 | 1 (0)| 00:00:01 |
|* 31 |
INDEX UNIQUE SCAN
| CE_BANK_ACCOUNTS_U1
| 1 | | 0 (0)|
|
|* 32 |
TABLE ACCESS BY INDEX ROWID| HZ_PARTIES
| 1 |59 | 2 (0)| 00:00:01 |
|* 33 |
INDEX UNIQUE SCAN
| HZ_PARTIES_U1
| 1 | | 1 (0)| 00:00:01 |
|* 34 |
TABLE ACCESS BY INDEX ROWID | HZ_RELATIONSHIPS
| 1 |79 | 4 (0)| 00:00:01 |
|* 35 |
INDEX RANGE SCAN
| HZ_RELATIONSHIPS_N5
| 2 | | 2 (0)| 00:00:01 |
|* 36 |
TABLE ACCESS BY INDEX ROWID| HZ_ORGANIZATION_PROFILES | 1 |23 | 3 (0)| 00:00:01 |
|* 37 |
INDEX RANGE SCAN
| HZ_ORGANIZATION_PROFILES_N1| 1 | | 2 (0)| 00:00:01 |
|* 38 |
TABLE ACCESS BY INDEX ROWID | HZ_ORGANIZATION_PROFILES | 1 |53 | 3 (0)| 00:00:01 |
|* 39 |
INDEX RANGE SCAN
| HZ_ORGANIZATION_PROFILES_N1| 1 | | 2 (0)| 00:00:01 |
|40 |
TABLE ACCESS BY INDEX ROWID| AP_SUPPLIER_SITES_ALL
| 1 |27 | 2 (0)| 00:00:01 |
|* 41 |
INDEX UNIQUE SCAN
| AP_SUPPLIER_SITES_U1 | 1 | | 1 (0)| 00:00:01 |
|42 |
TABLE ACCESS BY INDEX ROWID | AP_SUPPLIERS
| 1 |27 | 2 (0)| 00:00:01 |
|* 43 |
INDEX UNIQUE SCAN
| AP_SUPPLIERS_U1
| 1 | | 1 (0)| 00:00:01 |
|44 |
TABLE ACCESS BY INDEX ROWID
| IBY_EXTERNAL_PAYEES_ALL| 1 |28 | 3 (0)| 00:00:01 |
|* 45 |
INDEX RANGE SCAN
| IBY_EXTERNAL_PAYEES_ALL_N7 | 1 | | 2 (0)| 00:00:01 |
|* 46 |
TABLE ACCESS BY INDEX ROWID | CE_PAYMENT_DOCUMENTS | 1 |19 | 2 (0)| 00:00:01 |
|* 47 |
INDEX RANGE SCAN
| CE_PAYMENT_DOCUMENTS_N2| 1 | | 1 (0)| 00:00:01 |
|* 48 |
TABLE ACCESS BY INDEX ROWID
| HZ_CONTACT_POINTS
| 1 |27 | 3 (0)| 00:00:01 |
|* 49 |
INDEX RANGE SCAN
| HZ_CONTACT_POINTS_N6 | 1 | | 2 (0)| 00:00:01 |
|* 50 | TABLE ACCESS BY INDEX ROWID
| HZ_CONTACT_POINTS
| 1 |30 | 3 (0)| 00:00:01 |
|* 51 |
INDEX RANGE SCAN
| HZ_CONTACT_POINTS_N6 | 1 | | 2 (0)| 00:00:01 |
|* 52 |
TABLE ACCESS BY INDEX ROWID
| HZ_CODE_ASSIGNMENTS
| 1 |44 | 3 (0)| 00:00:01 |
|* 53 | INDEX RANGE SCAN
| HZ_CODE_ASSIGNMENTS_U2 | 1 | | 2 (0)| 00:00:01 |
|* 54 | TABLE ACCESS BY INDEX ROWID
| HZ_CODE_ASSIGNMENTS
| 1 |56 | 2 (0)| 00:00:01 |
|* 55 |
INDEX RANGE SCAN
| HZ_CODE_ASSIGNMENTS_U2 | 1 | | 2 (0)| 00:00:01 |
|* 56 |INDEX RANGE SCAN
| HZ_CODE_ASSIGNMENTS_U2 | 1 | | 2 (0)| 00:00:01 |
|* 57 | TABLE ACCESS BY INDEX ROWID
| HZ_CODE_ASSIGNMENTS
| 1 |56 | 3 (0)| 00:00:01 |
|58 |TABLE ACCESS FULL
| IBY_PMT_INSTR_USES_ALL | 169K|1822K| 789 (1)| 00:00:10 |
|59 | TABLE ACCESS BY INDEX ROWID
| IBY_EXT_BANK_ACCOUNTS
| 1 |73 | 1 (0)| 00:00:01 |
|* 60 |INDEX UNIQUE SCAN
| IBY_EXT_BANK_ACCOUNTS_U1 | 1 | | 0 (0)|
|
|61 |VIEW PUSHED PREDICATE
| CE_BANK_BRANCHES_V
| 1 |1003 |27 (0)| 00:00:01 |
|* 62 | FILTER
|
| | |
|
|
|63 |MERGE JOIN CARTESIAN
|
| 1 | 438 |27 (0)| 00:00:01 |
|64 | MERGE JOIN CARTESIAN
|
| 1 | 382 |24 (0)| 00:00:01 |
|65 |NESTED LOOPS OUTER
|
| 1 | 359 |21 (0)| 00:00:01 |
|66 | NESTED LOOPS OUTER
|
| 1 | 315 |18 (0)| 00:00:01 |
|67 |
NESTED LOOPS OUTER
|
| 1 | 285 |15 (0)| 00:00:01 |
|68 | NESTED LOOPS
|
| 1 | 258 |12 (0)| 00:00:01 |
|69 |
NESTED LOOPS
|
| 1 | 179 | 9 (0)| 00:00:01 |
|70 |
NESTED LOOPS
|
| 1 | 128 | 6 (0)| 00:00:01 |
|* 71 |
TABLE ACCESS BY INDEX ROWID
| HZ_PARTIES
| 1 |72 | 3 (0)| 00:00:01 |
|* 72 |
INDEX UNIQUE SCAN
| HZ_PARTIES_U1
| 1 | | 2 (0)| 00:00:01 |
|* 73 |
TABLE ACCESS BY INDEX ROWID
| HZ_CODE_ASSIGNMENTS
| 1 |56 | 3 (0)| 00:00:01 |
|* 74 |
INDEX RANGE SCAN
| HZ_CODE_ASSIGNMENTS_U2 | 1 | | 2 (0)| 00:00:01 |
|* 75 |
TABLE ACCESS BY INDEX ROWID | HZ_ORGANIZATION_PROFILES | 1 |51 | 3 (0)| 00:00:01 |
|* 76 |
INDEX RANGE SCAN
| HZ_ORGANIZATION_PROFILES_N1| 1 | | 2 (0)| 00:00:01 |
|* 77 |
TABLE ACCESS BY INDEX ROWID
| HZ_RELATIONSHIPS
| 1 |79 | 3 (0)| 00:00:01 |
|* 78 |
INDEX RANGE SCAN
| HZ_RELATIONSHIPS_N2
| 1 | | 2 (0)| 00:00:01 |
|* 79 | TABLE ACCESS BY INDEX ROWID
| HZ_CONTACT_POINTS
| 1 |27 | 3 (0)| 00:00:01 |
|* 80 |
INDEX RANGE SCAN
| HZ_CONTACT_POINTS_N6 | 1 | | 2 (0)| 00:00:01 |
|* 81 |
TABLE ACCESS BY INDEX ROWID
| HZ_CONTACT_POINTS
| 1 |30 | 3 (0)| 00:00:01 |
|* 82 | INDEX RANGE SCAN
| HZ_CONTACT_POINTS_N6 | 1 | | 2 (0)| 00:00:01 |
|* 83 | TABLE ACCESS BY INDEX ROWID
| HZ_CODE_ASSIGNMENTS
| 1 |44 | 3 (0)| 00:00:01 |
|* 84 |
INDEX RANGE SCAN
| HZ_CODE_ASSIGNMENTS_U2 | 1 | | 2 (0)| 00:00:01 |
|85 |BUFFER SORT
|
| 1 |23 |21 (0)| 00:00:01 |
|* 86 | TABLE ACCESS BY INDEX ROWID
| HZ_ORGANIZATION_PROFILES | 1 |23 | 3 (0)| 00:00:01 |
|* 87 |
INDEX RANGE SCAN
| HZ_ORGANIZATION_PROFILES_N1| 1 | | 2 (0)| 00:00:01 |
|88 | BUFFER SORT
|
| 1 |56 |24 (0)| 00:00:01 |
|* 89 |TABLE ACCESS BY INDEX ROWID
| HZ_CODE_ASSIGNMENTS
| 1 |56 | 3 (0)| 00:00:01 |
|* 90 | INDEX RANGE SCAN
| HZ_CODE_ASSIGNMENTS_U2 | 1 | | 2 (0)| 00:00:01 |
|91 | VIEW PUSHED PREDICATE
| HW_AP_PAYMENTCHECKRUN_V| 1 | 160 |2478 (1)| 00:00:30 |
|92 |NESTED LOOPS
|
| 1 |45 |2478 (1)| 00:00:30 |
|93 | TABLE ACCESS BY INDEX ROWID
| AP_INV_SELECTION_CRITERIA_ALL| 1 |33 | 2 (0)| 00:00:01 |
|* 94 |INDEX UNIQUE SCAN
| AP_INV_SELECTION_CRITERIA_U2 | 1 | | 1 (0)| 00:00:01 |
|* 95 | TABLE ACCESS FULL
| IBY_PAY_SERVICE_REQUESTS | 1 |12 |2476 (1)| 00:00:30 |
------------------------------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
4 - access("IEPA"."EXT_PAYEE_ID"="IBYU"."EXT_PMT_PARTY_ID")
22 - access("LGR"."LEDGER_ID"=TO_NUMBER("ORG"."ORG_INFORMATION3"))
24 - access("ORG"."ORG_INFORMATION_CONTEXT"='Operating Unit Information')
25 - filter(("OBJECT_TYPE_CODE"='L' AND NVL("COMPLETE_FLAG",'Y')='Y'))
26 - filter("ORG"."ORGANIZATION_ID"="PAYMENT"."ORG_ID")
27 - access("PAYMENT"."CHECK_DATE">=SYSDATE@!-7)
29 - access("PAYMENT"."CE_BANK_ACCT_USE_ID"="CBAU"."BANK_ACCT_USE_ID")
31 - access("CBAU"."BANK_ACCOUNT_ID"="BANK_ACCOUNT"."BANK_ACCOUNT_ID")
32 - filter(("BRANCHPARTY"."PARTY_TYPE"='ORGANIZATION' AND "BRANCHPARTY"."STATUS"='A'))
33 - access("BANK_ACCOUNT"."BANK_BRANCH_ID"="BRANCHPARTY"."PARTY_ID")
34 - filter(("BRREL"."RELATIONSHIP_CODE"='BRANCH_OF' AND "BRREL"."SUBJECT_TYPE"='ORGANIZATION' AND
"BRREL"."OBJECT_TABLE_NAME"='HZ_PARTIES' AND "BRREL"."OBJECT_TYPE"='ORGANIZATION'))
35 - access("BRREL"."SUBJECT_ID"="BRANCHPARTY"."PARTY_ID" AND "BRREL"."SUBJECT_TABLE_NAME"='HZ_PARTIES' AND
"BRREL"."RELATIONSHIP_TYPE"='BANK_AND_BRANCH' AND "BRREL"."STATUS"='A')
36 - filter((TRUNC(INTERNAL_FUNCTION("EFFECTIVE_START_DATE"))=SYSDATE@! AND "ACTUAL_CONTENT_SOURCE"='SST'))
37 - access("PARTY_ID"="BRANCHPARTY"."PARTY_ID")
38 - filter((TRUNC(INTERNAL_FUNCTION("EFFECTIVE_START_DATE"))=SYSDATE@! AND "ACTUAL_CONTENT_SOURCE"='SST'))
39 - access("PARTY_ID"="BRREL"."OBJECT_ID")
filter("BANK_ACCOUNT"."BANK_ID"="PARTY_ID")
41 - access("PAYMENT"."VENDOR_SITE_ID"="VENDOR_SITE"."VENDOR_SITE_ID")
43 - access("VENDOR"."VENDOR_ID"="VENDOR_SITE"."VENDOR_ID")
45 - access("VENDOR_SITE"."VENDOR_SITE_ID"="IEPA"."SUPPLIER_SITE_ID")
filter("IEPA"."SUPPLIER_SITE_ID" IS NOT NULL)
46 - filter(SUBSTR("PAYMENT_DOCUMENT"."PAYMENT_DOCUMENT_NAME",1,2)='SW')
47 - access("PAYMENT"."PAYMENT_DOCUMENT_ID"="PAYMENT_DOCUMENT"."PAYMENT_DOCUMENT_ID")
48 - filter("EDICP"."STATUS"='A')
49 - access("EDICP"."OWNER_TABLE_ID"="BRANCHPARTY"."PARTY_ID" AND "EDICP"."OWNER_TABLE_NAME"='HZ_PARTIES' AND
"EDICP"."CONTACT_POINT_TYPE"='EDI')
50 - filter("BRANCHCP"."STATUS"='A')
51 - access("BRANCHCP"."OWNER_TABLE_ID"="BRANCHPARTY"."PARTY_ID" AND "BRANCHCP"."OWNER_TABLE_NAME"='HZ_PARTIES' AND
"BRANCHCP"."CONTACT_POINT_TYPE"='EFT')
52 - filter(("BRANCHTYPECA"."PRIMARY_FLAG"='Y' AND "BRANCHTYPECA"."STATUS"='A'))
53 - access("BRANCHTYPECA"."OWNER_TABLE_ID"="BRANCHPARTY"."PARTY_ID" AND "BRANCHTYPECA"."OWNER_TABLE_NAME"='HZ_PARTIES'
AND "BRANCHTYPECA"."CLASS_CATEGORY"='BANK_BRANCH_TYPE')
filter(("BRANCHTYPECA"."CLASS_CATEGORY"='BANK_BRANCH_TYPE' AND "BRANCHTYPECA"."OWNER_TABLE_NAME"='HZ_PARTIES'))
54 - filter(("BRANCHCA"."STATUS"='A' OR "BRANCHCA"."STATUS" IS NULL))
55 - access("BRANCHCA"."OWNER_TABLE_ID"="BRANCHPARTY"."PARTY_ID" AND "BRANCHCA"."OWNER_TABLE_NAME"='HZ_PARTIES' AND
"BRANCHCA"."CLASS_CATEGORY"='BANK_INSTITUTION_TYPE')
filter(("BRANCHCA"."CLASS_CATEGORY"='BANK_INSTITUTION_TYPE' AND INTERNAL_FUNCTION("BRANCHCA"."CLASS_CODE") AND
"BRANCHCA"."OWNER_TABLE_NAME"='HZ_PARTIES'))
56 - access("BANKCA"."OWNER_TABLE_ID"="PARTY_ID" AND "BANKCA"."OWNER_TABLE_NAME"='HZ_PARTIES' AND
"BANKCA"."CLASS_CATEGORY"='BANK_INSTITUTION_TYPE')
filter(("BANKCA"."CLASS_CATEGORY"='BANK_INSTITUTION_TYPE' AND INTERNAL_FUNCTION("BANKCA"."CLASS_CODE") AND
"BANKCA"."OWNER_TABLE_NAME"='HZ_PARTIES'))
57 - filter(("BANKCA"."STATUS"='A' OR "BANKCA"."STATUS" IS NULL))
60 - access("IBYU"."INSTRUMENT_ID"="BANK_ACCOUNT_VENDOR"."EXT_BANK_ACCOUNT_ID")
62 - filter(("BANK_ACCOUNT_VENDOR"."BANK_ID"="BANK_ACCOUNT_VENDOR"."BANK_ID" AND
"BANK_ACCOUNT_VENDOR"."BRANCH_ID"="BANK_ACCOUNT_VENDOR"."BRANCH_ID"))
71 - filter(("BRANCHPARTY"."PARTY_TYPE"='ORGANIZATION' AND "BRANCHPARTY"."STATUS"='A'))
72 - access("BRANCHPARTY"."PARTY_ID"="BANK_ACCOUNT_VENDOR"."BRANCH_ID")
73 - filter(("BANKCA"."STATUS"='A' OR "BANKCA"."STATUS" IS NULL))
74 - access("BANKCA"."OWNER_TABLE_ID"="BANK_ACCOUNT_VENDOR"."BANK_ID" AND "BANKCA"."OWNER_TABLE_NAME"='HZ_PARTIES' AND
"BANKCA"."CLASS_CATEGORY"='BANK_INSTITUTION_TYPE')
filter(("BANKCA"."CLASS_CATEGORY"='BANK_INSTITUTION_TYPE' AND INTERNAL_FUNCTION("BANKCA"."CLASS_CODE") AND
"BANKCA"."OWNER_TABLE_NAME"='HZ_PARTIES' AND "BANKCA"."OWNER_TABLE_ID"="BANK_ACCOUNT_VENDOR"."BANK_ID"))
75 - filter((TRUNC(INTERNAL_FUNCTION("EFFECTIVE_START_DATE"))=SYSDATE@! AND "ACTUAL_CONTENT_SOURCE"='SST'))
76 - access("PARTY_ID"="BANK_ACCOUNT_VENDOR"."BANK_ID")
filter(("BANKCA"."OWNER_TABLE_ID"="PARTY_ID" AND "PARTY_ID"="BANK_ACCOUNT_VENDOR"."BANK_ID"))
77 - filter(("BRREL"."RELATIONSHIP_TYPE"='BANK_AND_BRANCH' AND "BRREL"."RELATIONSHIP_CODE"='BRANCH_OF' AND
"BRREL"."STATUS"='A' AND "BRREL"."SUBJECT_TABLE_NAME"='HZ_PARTIES' AND "BRREL"."OBJECT_TABLE_NAME"='HZ_PARTIES'))
78 - access("BRREL"."OBJECT_ID"="BANK_ACCOUNT_VENDOR"."BANK_ID" AND "BRREL"."OBJECT_TYPE"='ORGANIZATION' AND
"BRREL"."SUBJECT_ID"="BANK_ACCOUNT_VENDOR"."BRANCH_ID" AND "BRREL"."SUBJECT_TYPE"='ORGANIZATION')
filter(("PARTY_ID"="BRREL"."OBJECT_ID" AND "BRREL"."OBJECT_ID"="BANK_ACCOUNT_VENDOR"."BANK_ID"))
79 - filter("EDICP"."STATUS"='A')
80 - access("EDICP"."OWNER_TABLE_ID"="BANK_ACCOUNT_VENDOR"."BRANCH_ID" AND "EDICP"."OWNER_TABLE_NAME"='HZ_PARTIES' AND
"EDICP"."CONTACT_POINT_TYPE"='EDI')
filter(("EDICP"."OWNER_TABLE_ID"="BRANCHPARTY"."PARTY_ID" AND
"EDICP"."OWNER_TABLE_ID"="BANK_ACCOUNT_VENDOR"."BRANCH_ID"))
81 - filter("BRANCHCP"."STATUS"='A')
82 - access("BRANCHCP"."OWNER_TABLE_ID"="BANK_ACCOUNT_VENDOR"."BRANCH_ID" AND "BRANCHCP"."OWNER_TABLE_NAME"='HZ_PARTIES'
AND "BRANCHCP"."CONTACT_POINT_TYPE"='EFT')
filter(("BRANCHCP"."OWNER_TABLE_ID"="BRANCHPARTY"."PARTY_ID" AND
"BRANCHCP"."OWNER_TABLE_ID"="BANK_ACCOUNT_VENDOR"."BRANCH_ID"))
83 - filter(("BRANCHTYPECA"."PRIMARY_FLAG"='Y' AND "BRANCHTYPECA"."STATUS"='A'))
84 - access("BRANCHTYPECA"."OWNER_TABLE_ID"="BANK_ACCOUNT_VENDOR"."BRANCH_ID" AND
"BRANCHTYPECA"."OWNER_TABLE_NAME"='HZ_PARTIES' AND "BRANCHTYPECA"."CLASS_CATEGORY"='BANK_BRANCH_TYPE')
filter(("BRANCHTYPECA"."CLASS_CATEGORY"='BANK_BRANCH_TYPE' AND "BRANCHTYPECA"."OWNER_TABLE_NAME"='HZ_PARTIES' AND
"BRANCHTYPECA"."OWNER_TABLE_ID"="BRANCHPARTY"."PARTY_ID" AND "BRANCHTYPECA"."OWNER_TABLE_ID"="BANK_ACCOUNT_VENDOR"."BRANCH_I
D"))
86 - filter((TRUNC(INTERNAL_FUNCTION("EFFECTIVE_START_DATE"))=SYSDATE@! AND "ACTUAL_CONTENT_SOURCE"='SST'))
87 - access("PARTY_ID"="BANK_ACCOUNT_VENDOR"."BRANCH_ID")
89 - filter(("BRANCHCA"."STATUS"='A' OR "BRANCHCA"."STATUS" IS NULL))
90 - access("BRANCHCA"."OWNER_TABLE_ID"="BANK_ACCOUNT_VENDOR"."BRANCH_ID" AND "BRANCHCA"."OWNER_TABLE_NAME"='HZ_PARTIES'
AND "BRANCHCA"."CLASS_CATEGORY"='BANK_INSTITUTION_TYPE')
filter(("BRANCHCA"."CLASS_CATEGORY"='BANK_INSTITUTION_TYPE' AND INTERNAL_FUNCTION("BRANCHCA"."CLASS_CODE") AND
"BRANCHCA"."OWNER_TABLE_NAME"='HZ_PARTIES'))
94 - access("AISC"."CHECKRUN_ID"="PAYMENT"."CHECKRUN_ID")
95 - filter("IPSR"."CALL_APP_PAY_SERVICE_REQ_CODE"="AISC"."CHECKRUN_NAME")
|
