ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C8A7FD7AC920667BE0530100007F4469 CE Internal Bank Account Name (Secured) Y with ce_sec_v as (select /*+ materialize */ cbaua.bank_account_id, cspv.organization_type from ce_bank_acct_uses_all cbaua, ce_security_profiles_v cspv where ((cbaua.org_id = cspv.organization_id and cspv.organization_type = 'OPERATING_UNIT') or (cbaua.legal_entity_id = cspv.organization_id and cspv.organization_type = 'LEGAL_ENTITY') or (cbaua.org_id = cspv.organization_id and cspv.organization_type = 'BUSINESS_GROUP') ) and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate) ) select cba.bank_account_name value, hpb.party_name||' ('||cba.currency_code||') Account#: ' || cba.masked_account_num description from ce_bank_accounts cba, hz_parties hpb, hz_parties hpbb where cba.account_classification = 'INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' and hpb.party_id = cba.bank_id and hpbb.party_id = cba.bank_branch_id and (:$flex$.legal_entity is null or cba.account_owner_org_id in (select xep.legal_entity_id from xle_entity_profiles xep where xxen_util.contains(:$flex$.legal_entity,xep.name) = 'Y') ) and hpb.party_name = nvl(:$flex$.bank_name,hpb.party_name) and hpbb.party_name = nvl(:$flex$.bank_branch,hpbb.party_name) and ( ((cba.ap_use_allowed_flag = 'Y' or cba.ar_use_allowed_flag ='Y') and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'OPERATING_UNIT') ) or (cba.xtr_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'LEGAL_ENTITY') ) or (cba.pay_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'BUSINESS_GROUP') ) ) order by cba.bank_account_name US CE Internal Bank Account Names secured by CE Security Profile C8A7FD7AC91F667BE0530100007F4469 CE Internal Bank Account Number (secured, masked) Y with ce_sec_v as (select /*+ materialize */ cbaua.bank_account_id, cspv.organization_type from ce_bank_acct_uses_all cbaua, ce_security_profiles_v cspv where ((cbaua.org_id = cspv.organization_id and cspv.organization_type = 'OPERATING_UNIT') or (cbaua.legal_entity_id = cspv.organization_id and cspv.organization_type = 'LEGAL_ENTITY') or (cbaua.org_id = cspv.organization_id and cspv.organization_type = 'BUSINESS_GROUP') ) and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate) ) select cba.masked_account_num value, hpb.party_name||' ('||cba.currency_code||') Account:' || cba.bank_account_name description from ce_bank_accounts cba, hz_parties hpb, hz_parties hpbb where cba.account_classification = 'INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' and hpb.party_id = cba.bank_id and hpbb.party_id = cba.bank_branch_id and (:$flex$.legal_entity is null or cba.account_owner_org_id in (select xep.legal_entity_id from xle_entity_profiles xep where xxen_util.contains(:$flex$.legal_entity,xep.name) = 'Y') ) and hpb.party_name = nvl(:$flex$.bank_name,hpb.party_name) and hpbb.party_name = nvl(:$flex$.bank_branch,hpbb.party_name) and ( ((cba.ap_use_allowed_flag = 'Y' or cba.ar_use_allowed_flag ='Y') and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'OPERATING_UNIT') ) or (cba.xtr_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'LEGAL_ENTITY') ) or (cba.pay_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'BUSINESS_GROUP') ) ) order by cba.masked_account_num US CE Internal Bank Account Numbers secured by CE Security Profile C8A7FD7AC921667BE0530100007F4469 CE Internal Bank Account Statement Number (Secured, Account Dependent) Y with ce_sec_v as (select /*+ materialize */ cbaua.bank_account_id, cspv.organization_type from ce_bank_acct_uses_all cbaua, ce_security_profiles_v cspv where ((cbaua.org_id = cspv.organization_id and cspv.organization_type = 'OPERATING_UNIT') or (cbaua.legal_entity_id = cspv.organization_id and cspv.organization_type = 'LEGAL_ENTITY') or (cbaua.org_id = cspv.organization_id and cspv.organization_type = 'BUSINESS_GROUP') ) and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate) ) select csh.statement_number value, csh.statement_date || ' ' || hp.party_name||' ('||cba.currency_code||') Account:' || cba.bank_account_name || ' (' || cba.masked_account_num || ')' description from ce_statement_headers csh, ce_bank_accounts cba, hz_parties hp where cba.account_classification = 'INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' and csh.bank_account_id = cba.bank_account_id and hp.party_id = cba.bank_id and (:$flex$.bank_account_name is null or xxen_util.contains(:$flex$.bank_account_name,cba.bank_account_name) = 'Y') and (:$flex$.bank_account_number is null or xxen_util.contains(:$flex$.bank_account_number,cba.masked_account_num) = 'Y') and (:$flex$.check_digits is null or xxen_util.contains(:$flex$.check_digits,cba.check_digits) = 'Y') and (:$flex$.legal_entity is null or cba.account_owner_org_id in (select xep.legal_entity_id from xle_entity_profiles xep where xxen_util.contains(:$flex$.legal_entity,xep.name) = 'Y') ) and ( ((cba.ap_use_allowed_flag = 'Y' or cba.ar_use_allowed_flag ='Y') and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'OPERATING_UNIT') ) or (cba.xtr_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'LEGAL_ENTITY') ) or (cba.pay_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'BUSINESS_GROUP') ) ) order by csh.statement_date desc US CE Internal Bank Account Statement Numbers secured by CE Security Profile and Dependent on Account Number and/or Account Name CB5B97B15AC6A126E05362FB09055DE0 CE Internal Bank Branch Names Y select cbbv.bank_branch_name value, cbbv.bank_name description from ce_bank_branches_v cbbv where cbbv.branch_party_id in (select cba.bank_branch_id from ce_bank_accounts cba where cba.account_classification='INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' ) and cbbv.bank_name = nvl(:$flex$.Bank_name,cbbv.bank_name) order by cbbv.bank_branch_name, cbbv.bank_name US CE Internal Bank Branch Names CB5B97B15AC5A126E05362FB09055DE0 CE Internal Bank Names Y select distinct cbbv.bank_name value, null description from ce_bank_branches_v cbbv where cbbv.branch_party_id in (select cba.bank_branch_id from ce_bank_accounts cba where cba.account_classification='INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' ) order by cbbv.bank_name US CE Internal Bank Names 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 82288223EF513869E053B46B63588994 select /* Q1. successfuly imported statements with no errors */ cbbv.bank_name bank_name, cbbv.bank_branch_name bank_branch_name, cbagv.bank_account_name bank_account_name, cbagv.bank_account_num bank_account_number, cbagv.currency_code account_currency, 'Processed' import_status, null error_type, csh.statement_number statement_number, csh.statement_date statement_date, (select cshi.creation_date from ce_statement_headers_int cshi where cshi.statement_number = csh.statement_number and cshi.currency_code = nvl(csh.currency_code,cbagv.currency_code) and cshi.bank_account_num = cbagv.bank_account_num and nvl(cshi.org_id,-99) = nvl(csh.org_id,-99) ) statement_interface_date, csh.doc_sequence_value doc_sequence_value, csl.line_number line_number, csl.trx_date trx_date, xxen_util.meaning(csl.status,'STATEMENT_LINE_STATUS',260) line_status, null message_name, nvl(csl.amount,0) amount, nvl(csl.currency_code, cbagv.currency_code ) trx_currency, cl2.meaning trx_type, csl.bank_trx_number trx_no, 'CE' application from ce_lookups cl2, ce_bank_accts_gt_v cbagv, ce_bank_branches_v cbbv, ce_statement_headers csh, ce_statement_lines csl where 1=1 and nvl(:p_show_errors_only,'No') != 'Yes' and cbbv.branch_party_id = cbagv.bank_branch_id and cbagv.bank_account_id = csh.bank_account_id and csl.statement_header_id = csh.statement_header_id and cl2.lookup_type (+) = 'BANK_TRX_TYPE' and cl2.lookup_code (+) = csl.trx_type and not exists (select null from ar_cash_receipts_all acra, ar_cash_receipt_history_all acrha, ce_statement_reconcils_all csra where csra.statement_line_id = csl.statement_line_id and csra.reference_type in ('RECEIPT','DM REVERSAL') and csra.current_record_flag = 'Y' and csra.status_flag = 'M' and acrha.cash_receipt_history_id = csra.reference_id and acra.cash_receipt_id = acrha.cash_receipt_id and acra.comments = 'Created by Auto Bank Rec' ) and not exists (select null from ce_reconciliation_errors clie where csl.statement_line_id = clie.statement_line_id and clie.statement_line_id is not null and csl.status != 'EXTERNAL' ) -- union all -- select /* Q2. miscellaneous receipts created */ cbbv.bank_name bank_name, cbbv.bank_branch_name bank_branch_name, cbagv.bank_account_name bank_account_name, cbagv.bank_account_num bank_account_number, cbagv.currency_code account_currency, 'Processed' import_status, cl1.meaning error_type, csh.statement_number statement_number, csh.statement_date statement_date, (select cshi.creation_date from ce_statement_headers_int cshi where cshi.statement_number = csh.statement_number and cshi.currency_code = nvl(csh.currency_code,cbagv.currency_code) and cshi.bank_account_num = cbagv.bank_account_num and nvl(cshi.org_id,-99) = nvl(csh.org_id,-99) ) statement_interface_date, csh.doc_sequence_value doc_sequence_value, csl.line_number line_number, csl.trx_date trx_date, xxen_util.meaning(csl.status,'STATEMENT_LINE_STATUS',260) line_status, null message_name, nvl(csl.amount,0) amount, acra.currency_code trx_currency, cl2.meaning trx_type, acra.receipt_number trx_no, 'CE' application from ce_lookups cl1, ce_lookups cl2, ce_bank_accts_gt_v cbagv, ce_bank_branches_v cbbv, ce_statement_headers csh, ce_statement_lines csl, ar_cash_receipts_all acra, ar_cash_receipt_history_all acrha, ce_statement_reconcils_all csra where 1=1 and cbbv.branch_party_id = cbagv.bank_branch_id and cbagv.bank_account_id = csh.bank_account_id and csh.statement_header_id = csl.statement_header_id and csra.statement_line_id = csl.statement_line_id and csra.reference_type in ('RECEIPT','DM REVERSAL') and csra.current_record_flag = 'Y' and csra.status_flag = 'M' and acrha.cash_receipt_history_id = csra.reference_id and acra.cash_receipt_id = acrha.cash_receipt_id and acra.comments = 'Created by Auto Bank Rec' and cl1.lookup_type = 'ABR_REPORT_EXCEPTIONS' and cl1.lookup_code = 'MISC_RECEIPT_CREATED' and cl2.lookup_type (+) = 'BANK_TRX_TYPE' and cl2.lookup_code (+) = csl.trx_type -- union all -- select /*+ push_pred(clie) */ /*Q3. reconciliation errors - line level */ cbbv.bank_name bank_name, cbbv.bank_branch_name bank_branch_name, cbagv.bank_account_name bank_account_name, cbagv.bank_account_num bank_account_number, cbagv.currency_code account_currency, 'Processed' import_status, cl1.description error_type, csh.statement_number statement_no, csh.statement_date statement_date, (select cshi.creation_date from ce_statement_headers_int cshi where cshi.statement_number = csh.statement_number and cshi.currency_code = nvl(csh.currency_code,cbagv.currency_code) and cshi.bank_account_num = cbagv.bank_account_num and nvl(cshi.org_id,-99) = nvl(csh.org_id,-99) ) statement_interface_date, csh.doc_sequence_value doc_sequence_value, csl.line_number line_no, csl.trx_date trx_date, xxen_util.meaning(csl.status,'STATEMENT_LINE_STATUS',260) line_status, clie.message_name, nvl(csl.amount,0) amount, nvl(csl.currency_code,cbagv.currency_code) c_currency_code, cl2.meaning trx_type, csl.bank_trx_number trx_no, nvl(clie.application_short_name,'CE') application_short_name from ce_lookups cl1, ce_lookups cl2, ce_bank_accts_gt_v cbagv, ce_bank_branches_v cbbv, ce_statement_headers csh, ce_statement_lines csl, (select distinct cre.statement_header_id, cre.statement_line_id, cre.application_short_name, listagg (ce_cexinerr_xmlp_pkg.c_prt_message_nameformula(cre.message_name),', ') within group (order by cre.message_name) message_name from ce_reconciliation_errors cre group by cre.statement_header_id, cre.statement_line_id, cre.application_short_name ) clie where 1=1 and cbbv.branch_party_id = cbagv.bank_branch_id and cbagv.bank_account_id = csh.bank_account_id and csh.statement_header_id = csl.statement_header_id and csh.statement_header_id = clie.statement_header_id and csl.statement_line_id = clie.statement_line_id and clie.statement_line_id is not null and csl.status != 'EXTERNAL' and cl1.lookup_type = 'ABR_REPORT_EXCEPTIONS' and cl1.lookup_code = 'RECONCILIATION' and cl2.lookup_type (+) = 'BANK_TRX_TYPE' and cl2.lookup_code (+) = csl.trx_type -- union all -- select /*+ push_pred(clie) */ /* Q4. reconciliation errors - header level */ cbbv.bank_name bank_name, cbbv.bank_branch_name bank_branch_name, cbagv.bank_account_name bank_account_name, cbagv.bank_account_num bank_account_number, cbagv.currency_code account_currency, 'Processed' import_status, cl1.description error_type, csh.statement_number statement_no, csh.statement_date statement_date, (select cshi.creation_date from ce_statement_headers_int cshi where cshi.statement_number = csh.statement_number and cshi.currency_code = nvl(csh.currency_code,cbagv.currency_code) and cshi.bank_account_num = cbagv.bank_account_num and nvl(cshi.org_id,-99) = nvl(csh.org_id,-99) ) statement_interface_date, csh.doc_sequence_value doc_sequence_value, 0 line_no, to_date(null) trx_date, null line_status, clie.message_name, to_number(null) amount, cbagv.currency_code c_currency_code, null trx_type, null trx_no, nvl(clie.application_short_name,'CE') application_short_name from ce_lookups cl1, ce_bank_accts_gt_v cbagv, ce_bank_branches_v cbbv, ce_statement_headers csh, (select distinct cre.statement_header_id, cre.statement_line_id, cre.application_short_name, listagg (ce_cexinerr_xmlp_pkg.c_prt_message_nameformula(cre.message_name),', ') within group (order by cre.message_name) message_name from ce_reconciliation_errors cre group by cre.statement_header_id, cre.statement_line_id, cre.application_short_name ) clie where 1=1 and cbbv.branch_party_id = cbagv.bank_branch_id and cbagv.bank_account_id = csh.bank_account_id and clie.statement_line_id is null and csh.statement_header_id = clie.statement_header_id and cl1.lookup_type = 'ABR_REPORT_EXCEPTIONS' and cl1.lookup_code = 'RECONCILIATION' -- union all -- ( select /*+ push_pred(clie) */ /*Q5. header interface errors */ cbbv.bank_name bank_name, cbbv.bank_branch_name bank_branch_name, cbagv.bank_account_name bank_account_name, cbagv.bank_account_num bank_account_number, cbagv.currency_code account_currency, 'Error' import_status, cl1.description error_type, clie.statement_number statement_no, trunc(csh.statement_date) statement_date, csh.creation_date statement_interface_date, to_number(null) doc_sequence_value, 0 line_no, csh.statement_date trx_date, null line_status, clie.message_name, 0 amount, ' ' c_currency_code, ' ' trx_type, ' ' trx_no, nvl(clie.application_short_name,'CE') application_short_name from ce_lookups cl1, ce_statement_headers_int csh, ce_bank_accts_gt_v cbagv, ce_bank_branches_v cbbv, (select distinct chie.bank_account_num, chie.statement_number, chie.currency_code, chie.application_short_name, listagg (ce_cexinerr_xmlp_pkg.c_prt_message_nameformula(chie.message_name),', ') within group (order by chie.message_name) message_name from ce_header_interface_errors chie group by chie.bank_account_num, chie.statement_number, chie.currency_code, chie.application_short_name ) clie where 1=1 and cbbv.branch_party_id = cbagv.bank_branch_id and clie.bank_account_num = cbagv.bank_account_num and cbagv.currency_code = csh.currency_code and csh.bank_account_num = clie.bank_account_num and csh.statement_number = clie.statement_number and csh.currency_code = clie.currency_code and cl1.lookup_type = 'ABR_REPORT_EXCEPTIONS' and cl1.lookup_code = 'STATEMENT' and nvl(csh.record_status_flag,'N') != 'T' -- not transferred -- union -- select /*+ push_pred(clie) */ /*Q6. header interface errors, in case the stmt has been transfered to ce_statement_headers and there're warnings during transfer */ cbbv.bank_name bank_name, cbbv.bank_branch_name bank_branch_name, cbagv.bank_account_name bank_account_name, cbagv.bank_account_num bank_account_number, cbagv.currency_code account_currency, 'Processed' import_status, cl1.description error_type, clie.statement_number statement_no, csh.statement_date statement_date, (select cshi.creation_date from ce_statement_headers_int cshi where cshi.statement_number = csh.statement_number and cshi.currency_code = nvl(csh.currency_code,cbagv.currency_code) and cshi.bank_account_num = cbagv.bank_account_num and nvl(cshi.org_id,-99) = nvl(csh.org_id,-99) ) statement_interface_date, to_number(null) doc_sequence_value, 0 line_no, csh.statement_date trx_date, null line_status, clie.message_name, 0 amount, ' ' c_currency_code, ' ' trx_type, ' ' trx_no, nvl(clie.application_short_name,'CE') application_short_name from ce_lookups cl1, ce_statement_headers csh, ce_bank_accts_gt_v cbagv, ce_bank_branches_v cbbv, (select distinct chie.bank_account_num, chie.statement_number, chie.currency_code, chie.application_short_name, listagg (ce_cexinerr_xmlp_pkg.c_prt_message_nameformula(chie.message_name),', ') within group (order by chie.message_name) message_name from ce_header_interface_errors chie group by chie.bank_account_num, chie.statement_number, chie.currency_code, chie.application_short_name ) clie where 1=1 and cbbv.branch_party_id = cbagv.bank_branch_id and csh.bank_account_id = cbagv.bank_account_id and clie.bank_account_num = cbagv.bank_account_num and clie.statement_number = csh.statement_number and clie.currency_code = nvl(csh.currency_code,cbagv.currency_code) and cl1.lookup_type = 'ABR_REPORT_EXCEPTIONS' and cl1.lookup_code = 'STATEMENT' ) -- union all -- select /*+ push_pred(clie) */ /*Q7. line interface errors */ cbbv.bank_name bank_name, cbbv.bank_branch_name bank_branch_name, cbagv.bank_account_name bank_account_name, cbagv.bank_account_num bank_account_number, cbagv.currency_code account_currency, 'Error' import_status, cl1.description error_type, clie.statement_number statement_no, trunc(csh.statement_date) statement_date, csh.creation_date statement_interface_date, to_number(null) doc_sequence_value, clie.line_number line_no, csl.trx_date trx_date, 'Error' line_status, clie.message_name, nvl(csl.amount,0) amount, nvl(curr.currency_code, cbagv.currency_code) c_currency_code, ' ' trx_type, ' ' trx_no, nvl(clie.application_short_name,'CE') application_short_name from fnd_currencies curr, ce_lookups cl1, ce_statement_headers_int csh, ce_statement_lines_interface csl, ce_bank_accts_gt_v cbagv, ce_bank_branches_v cbbv, (select distinct clie.bank_account_num, clie.statement_number, clie.line_number, clie.bank_acct_currency_code, clie.application_short_name, listagg (ce_cexinerr_xmlp_pkg.c_prt_message_nameformula(clie.message_name),', ') within group (order by clie.message_name) message_name from ce_line_interface_errors clie group by clie.bank_account_num, clie.statement_number, clie.line_number, clie.bank_acct_currency_code, clie.application_short_name ) clie where 1=1 and cbbv.branch_party_id = cbagv.bank_branch_id and cbagv.bank_account_num = csh.bank_account_num and cbagv.currency_code = csh.currency_code and csh.bank_account_num = csl.bank_account_num and csh.statement_number = csl.statement_number and csh.currency_code = csl.bank_acct_currency_code and clie.bank_account_num = cbagv.bank_account_num and csl.line_number = clie.line_number and csl.statement_number = clie.statement_number and csl.bank_account_num = clie.bank_account_num and csl.bank_acct_currency_code = clie.bank_acct_currency_code and curr.currency_code(+) = csl.currency_code and cl1.lookup_type = 'ABR_REPORT_EXCEPTIONS' and cl1.lookup_code = 'LINE' union all select /* Q8. statement headers with no lines */ cbbv.bank_name bank_name, cbbv.bank_branch_name bank_branch_name, cbagv.bank_account_name bank_account_name, cbagv.bank_account_num bank_account_number, cbagv.currency_code account_currency, 'Processed' import_status, 'No Statement Lines' error_type, csh.statement_number statement_number, csh.statement_date statement_date, (select cshi.creation_date from ce_statement_headers_int cshi where cshi.statement_number = csh.statement_number and cshi.currency_code = nvl(csh.currency_code,cbagv.currency_code) and cshi.bank_account_num = cbagv.bank_account_num and nvl(cshi.org_id,-99) = nvl(csh.org_id,-99) ) statement_interface_date, csh.doc_sequence_value doc_sequence_value, to_number(null) line_number, to_date(null) trx_date, null line_status, 'No Statement Lines' message_name, to_number(null) amount, null trx_currency, null trx_type, null trx_no, 'CE' application from ce_bank_accts_gt_v cbagv, ce_bank_branches_v cbbv, ce_statement_headers csh where 1=1 and cbbv.branch_party_id = cbagv.bank_branch_id and cbagv.bank_account_id = csh.bank_account_id and not exists -- no statement lines (select null from ce_statement_lines csl where csl.statement_header_id = csh.statement_header_id ) and not exists -- will be picked up in Q4 header recon error (select null from ce_reconciliation_errors cre where cre.statement_line_id is null and cre.statement_header_id = csh.statement_header_id ) and not exists -- will be picked up in Q6 header interface errors (select null from ce_header_interface_errors chie where chie.bank_account_num = cbagv.bank_account_num and chie.statement_number = csh.statement_number and chie.currency_code = nvl(csh.currency_code,cbagv.currency_code) ) -- order by 1,2,3,4,9,12 Y CE CEIMPERR_XML AR CE تقرير تنفيذ استيراد كشف حساب البنك (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: إدارة النقدية Source: تقرير تنفيذ استيراد كشف حساب البنك (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: CEIMPERR_XML DB package: CE_CEXINERR_XMLP_PKG D CE Kontoauszüge importieren - Ergebnisse- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Cash Management Source: Kontoauszüge importieren - Ergebnisse (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: CEIMPERR_XML DB package: CE_CEXINERR_XMLP_PKG F CE Compte rendu d'exécution de l'importation des relevés bancaires- Non pris en charge : réservé pour une utilisation future Application: Cash Management Source: Compte rendu d'exécution de l'importation des relevés bancaires (XML) - Non pris en charge : réservé pour une utilisation future Short Name: CEIMPERR_XML DB package: CE_CEXINERR_XMLP_PKG US CE Bank Statement Import Execution Application: Cash Management Source: Bank Statement Import Execution Report Short Name: CEIMPERR DB package: CE_CEXINERR_XMLP_PKG ZHS CE 银行对帐单导入执行报表- 不支持：已保留供将来使用 Application: 现金管理系统 Source: 银行对帐单导入执行报表 (XML) - 不支持：已保留供将来使用 Short Name: CEIMPERR_XML DB package: CE_CEXINERR_XMLP_PKG BI Publisher Enginatics R12 only 1=1 :c_all_translation :c_bank_account_name_dsp :c_bank_account_num_dsp :c_bank_branch_name_dsp :c_bank_currency_code_dsp :c_bank_name_dsp :c_base_currency_code :c_company_name_header :c_date_head_lex :c_date_line_lex :c_date_recon_lex :c_number_head_lex :c_number_line_lex :c_number_recon_lex :c_the_end :lp_stat_date_from :lp_stat_date_to :p_bank_account_id :p_bank_branch_id :p_conc_request_id :p_debug_mode :p_min_precision :p_set_of_books_id :p_show_errors_only :p_sql_trace :p_stat_date_from :p_stat_date_to :p_stat_number_from :p_stat_number_to 1 10 1=1 cbbv.bank_name=:p_bank_name LOV CE Internal Bank Names CB5B97B15AC5A126E05362FB09055DE0 Y select distinct cbbv.bank_name value, null description from ce_bank_branches_v cbbv where cbbv.branch_party_id in (select cba.bank_branch_id from ce_bank_accounts cba where cba.account_classification='INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' ) order by cbbv.bank_name F Nom de la banque US Bank Name 2 20 1=1 cbbv.bank_branch_name=:p_bank_branch_name LOV CE Internal Bank Branch Names CB5B97B15AC6A126E05362FB09055DE0 Y select cbbv.bank_branch_name value, cbbv.bank_name description from ce_bank_branches_v cbbv where cbbv.branch_party_id in (select cba.bank_branch_id from ce_bank_accounts cba where cba.account_classification='INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' ) and cbbv.bank_name = nvl(:$flex$.Bank_name,cbbv.bank_name) order by cbbv.bank_branch_name, cbbv.bank_name AR اسم فرع البنك D Zweigstellenbezeichnung F Nom de la succursale bancaire US Bank Branch Name ZHS 分行名称 3 30 1=1 cbagv.bank_account_name=:p_bank_account_name LOV CE Internal Bank Account Name (Secured) C8A7FD7AC920667BE0530100007F4469 Y with ce_sec_v as (select /*+ materialize */ cbaua.bank_account_id, cspv.organization_type from ce_bank_acct_uses_all cbaua, ce_security_profiles_v cspv where ((cbaua.org_id = cspv.organization_id and cspv.organization_type = 'OPERATING_UNIT') or (cbaua.legal_entity_id = cspv.organization_id and cspv.organization_type = 'LEGAL_ENTITY') or (cbaua.org_id = cspv.organization_id and cspv.organization_type = 'BUSINESS_GROUP') ) and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate) ) select cba.bank_account_name value, hpb.party_name||' ('||cba.currency_code||') Account#: ' || cba.masked_account_num description from ce_bank_accounts cba, hz_parties hpb, hz_parties hpbb where cba.account_classification = 'INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' and hpb.party_id = cba.bank_id and hpbb.party_id = cba.bank_branch_id and (:$flex$.legal_entity is null or cba.account_owner_org_id in (select xep.legal_entity_id from xle_entity_profiles xep where xxen_util.contains(:$flex$.legal_entity,xep.name) = 'Y') ) and hpb.party_name = nvl(:$flex$.bank_name,hpb.party_name) and hpbb.party_name = nvl(:$flex$.bank_branch,hpbb.party_name) and ( ((cba.ap_use_allowed_flag = 'Y' or cba.ar_use_allowed_flag ='Y') and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'OPERATING_UNIT') ) or (cba.xtr_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'LEGAL_ENTITY') ) or (cba.pay_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'BUSINESS_GROUP') ) ) order by cba.bank_account_name F Nom du compte bancaire US Bank Account Name 4 40 1=1 cbagv.bank_account_num=:p_bank_account_num LOV CE Internal Bank Account Number (secured, masked) C8A7FD7AC91F667BE0530100007F4469 Y with ce_sec_v as (select /*+ materialize */ cbaua.bank_account_id, cspv.organization_type from ce_bank_acct_uses_all cbaua, ce_security_profiles_v cspv where ((cbaua.org_id = cspv.organization_id and cspv.organization_type = 'OPERATING_UNIT') or (cbaua.legal_entity_id = cspv.organization_id and cspv.organization_type = 'LEGAL_ENTITY') or (cbaua.org_id = cspv.organization_id and cspv.organization_type = 'BUSINESS_GROUP') ) and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate) ) select cba.masked_account_num value, hpb.party_name||' ('||cba.currency_code||') Account:' || cba.bank_account_name description from ce_bank_accounts cba, hz_parties hpb, hz_parties hpbb where cba.account_classification = 'INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' and hpb.party_id = cba.bank_id and hpbb.party_id = cba.bank_branch_id and (:$flex$.legal_entity is null or cba.account_owner_org_id in (select xep.legal_entity_id from xle_entity_profiles xep where xxen_util.contains(:$flex$.legal_entity,xep.name) = 'Y') ) and hpb.party_name = nvl(:$flex$.bank_name,hpb.party_name) and hpbb.party_name = nvl(:$flex$.bank_branch,hpbb.party_name) and ( ((cba.ap_use_allowed_flag = 'Y' or cba.ar_use_allowed_flag ='Y') and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'OPERATING_UNIT') ) or (cba.xtr_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'LEGAL_ENTITY') ) or (cba.pay_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'BUSINESS_GROUP') ) ) order by cba.masked_account_num AR رقم حساب البنك D Kontonummer F Numéro de compte bancaire US Bank Account Number ZHS 银行帐号 5 50 1=1 csh.statement_number>=:p_stat_number_from LOV CE Internal Bank Account Statement Number (Secured, Account Dependent) C8A7FD7AC921667BE0530100007F4469 Y with ce_sec_v as (select /*+ materialize */ cbaua.bank_account_id, cspv.organization_type from ce_bank_acct_uses_all cbaua, ce_security_profiles_v cspv where ((cbaua.org_id = cspv.organization_id and cspv.organization_type = 'OPERATING_UNIT') or (cbaua.legal_entity_id = cspv.organization_id and cspv.organization_type = 'LEGAL_ENTITY') or (cbaua.org_id = cspv.organization_id and cspv.organization_type = 'BUSINESS_GROUP') ) and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate) ) select csh.statement_number value, csh.statement_date || ' ' || hp.party_name||' ('||cba.currency_code||') Account:' || cba.bank_account_name || ' (' || cba.masked_account_num || ')' description from ce_statement_headers csh, ce_bank_accounts cba, hz_parties hp where cba.account_classification = 'INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' and csh.bank_account_id = cba.bank_account_id and hp.party_id = cba.bank_id and (:$flex$.bank_account_name is null or xxen_util.contains(:$flex$.bank_account_name,cba.bank_account_name) = 'Y') and (:$flex$.bank_account_number is null or xxen_util.contains(:$flex$.bank_account_number,cba.masked_account_num) = 'Y') and (:$flex$.check_digits is null or xxen_util.contains(:$flex$.check_digits,cba.check_digits) = 'Y') and (:$flex$.legal_entity is null or cba.account_owner_org_id in (select xep.legal_entity_id from xle_entity_profiles xep where xxen_util.contains(:$flex$.legal_entity,xep.name) = 'Y') ) and ( ((cba.ap_use_allowed_flag = 'Y' or cba.ar_use_allowed_flag ='Y') and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'OPERATING_UNIT') ) or (cba.xtr_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'LEGAL_ENTITY') ) or (cba.pay_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'BUSINESS_GROUP') ) ) order by csh.statement_date desc AR رقم كشف الحساب من D Von Auszugsnummer F Numéro de déclaration De US Statement Number From ZHS 对帐单编号自 6 60 1=1 csh.statement_number<=:p_stat_number_to LOV CE Internal Bank Account Statement Number (Secured, Account Dependent) C8A7FD7AC921667BE0530100007F4469 Y with ce_sec_v as (select /*+ materialize */ cbaua.bank_account_id, cspv.organization_type from ce_bank_acct_uses_all cbaua, ce_security_profiles_v cspv where ((cbaua.org_id = cspv.organization_id and cspv.organization_type = 'OPERATING_UNIT') or (cbaua.legal_entity_id = cspv.organization_id and cspv.organization_type = 'LEGAL_ENTITY') or (cbaua.org_id = cspv.organization_id and cspv.organization_type = 'BUSINESS_GROUP') ) and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate) ) select csh.statement_number value, csh.statement_date || ' ' || hp.party_name||' ('||cba.currency_code||') Account:' || cba.bank_account_name || ' (' || cba.masked_account_num || ')' description from ce_statement_headers csh, ce_bank_accounts cba, hz_parties hp where cba.account_classification = 'INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' and csh.bank_account_id = cba.bank_account_id and hp.party_id = cba.bank_id and (:$flex$.bank_account_name is null or xxen_util.contains(:$flex$.bank_account_name,cba.bank_account_name) = 'Y') and (:$flex$.bank_account_number is null or xxen_util.contains(:$flex$.bank_account_number,cba.masked_account_num) = 'Y') and (:$flex$.check_digits is null or xxen_util.contains(:$flex$.check_digits,cba.check_digits) = 'Y') and (:$flex$.legal_entity is null or cba.account_owner_org_id in (select xep.legal_entity_id from xle_entity_profiles xep where xxen_util.contains(:$flex$.legal_entity,xep.name) = 'Y') ) and ( ((cba.ap_use_allowed_flag = 'Y' or cba.ar_use_allowed_flag ='Y') and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'OPERATING_UNIT') ) or (cba.xtr_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'LEGAL_ENTITY') ) or (cba.pay_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'BUSINESS_GROUP') ) ) order by csh.statement_date desc :$flex$.Statement_Number_From AR رقم كشف الحساب إلى D Bis Auszugsnummer F Numéro de déclaration à US Statement Number To ZHS 对帐单编号至 7 70 1=1 csh.statement_date>=:p_stat_date_from Date AR تاريخ كشف الحساب من D Von Auszugsdatum F Date de déclaration du US Statement Date From ZHS 对帐单日期自 8 80 1=1 csh.statement_date<:p_stat_date_to+1 Date :$flex$.Statement_Date_From AR تاريخ كشف الحساب إلى D Bis Auszugsdatum F Date du relevé au US Statement Date To ZHS 对帐单日期至 9 90 :p_show_errors_only LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Show Warnings/Errors Only :$flex$.Bank_name Bank Name Bank Branch Name :$flex$.Statement_Date_From Statement Date From Y Statement Date To :$flex$.Statement_Number_From Statement Number From Statement Number To :$flex$.bank_account_name Bank Account Name Statement Number From :$flex$.bank_account_name Bank Account Name Statement Number To :$flex$.bank_account_number Bank Account Number Statement Number From :$flex$.bank_account_number Bank Account Number Statement Number To :$flex$.bank_name Bank Name Bank Account Name :$flex$.bank_name Bank Name Bank Account Number