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 02711C1D4275559BE06362FB0905C0AFY select /*+ push_pred(x) */ x.* from ( select /* Q1. Imported Statements */ (select hou.name from hr_operating_units hou where hou.organization_id = csh.org_id) ou, 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, 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, csl.currency_code trx_currency, cl2.meaning trx_type, csl.bank_trx_number trx_no, 'CE' application, -- 'Imported' import_status, null interf_header_status_flag, csl.status line_status_code, nvl2(csl.statement_line_id,null,'Y') no_statement_line_flag, -- Q8 (select 'Y' 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 rownum <= 1 ) auto_created_misc_rec_flag, -- Q2 (select distinct listagg(nvl(ce_cexinerr_xmlp_pkg.c_prt_message_nameformula(cre.message_name),'Y'),', ') within group (order by cre.message_name) from ce_reconciliation_errors cre where cre.statement_line_id = csl.statement_line_id) line_recon_error, -- Q3 (select distinct listagg(nvl(ce_cexinerr_xmlp_pkg.c_prt_message_nameformula(cre.message_name),'Y'),', ') within group (order by cre.message_name) from ce_reconciliation_errors cre where cre.statement_header_id = csh.statement_header_id and cre.statement_line_id is null) header_recon_error, -- Q4 (select listagg (nvl(ce_cexinerr_xmlp_pkg.c_prt_message_nameformula(chie.message_name),', '),'Y') within group (order by chie.message_name) from ce_header_interface_errors chie where chie.bank_account_num = cbagv.bank_account_num and chie.statement_number = csh.statement_number) header_intf_error, -- Q6 (select distinct listagg (chie.currency_code,', ') within group (order by chie.currency_code) from ce_header_interface_errors chie where chie.bank_account_num = cbagv.bank_account_num and chie.statement_number = csh.statement_number) header_intf_error_cur, -- Q6 (select listagg (nvl(ce_cexinerr_xmlp_pkg.c_prt_message_nameformula(clie.message_name),'Y'),', ') within group (order by clie.message_name) from ce_line_interface_errors clie where clie.bank_account_num = cbagv.bank_account_num and clie.statement_number = csh.statement_number and clie.line_number = csl.line_number) line_intf_error, -- Q7 (select listagg (clie.bank_acct_currency_code,', ') within group (order by clie.bank_acct_currency_code) from ce_line_interface_errors clie where clie.bank_account_num = cbagv.bank_account_num and clie.statement_number = csh.statement_number and clie.line_number = csl.line_number) line_intf_error_cur, -- Q7 (select count(*) from ce_statement_reconcils_all csra where csra.statement_line_id = csl.statement_line_id and csra.current_record_flag = 'Y' and csra.status_flag = 'M') recon_count, (select listagg (csra.reference_type,', ') within group (order by csra.reference_type) from ce_statement_reconcils_all csra where csra.statement_line_id = csl.statement_line_id and csra.current_record_flag = 'Y' and csra.status_flag = 'M') recon_types, -- csh.statement_header_id, csl.statement_line_id -- from ce_lookups cl2, ce_bank_accts_gt_v cbagv, ce_bank_branches_v cbbv, ce_statement_headers csh, ce_statement_lines csl where 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 -- union all select /* Q2. Interface Statements */ (select hou.name from hr_operating_units hou where hou.organization_id = csh.org_id) ou, csh.bank_name bank_name, csh.bank_branch_name bank_branch_name, cbagv.bank_account_name bank_account_name, csh.bank_account_num bank_account_number, csh.currency_code account_currency, csh.statement_number statement_number, csh.statement_date statement_date, csh.creation_date statement_interface_date, to_number(null) doc_sequence_value, csl.line_number line_number, csl.trx_date trx_date, 'Interface' line_status, csl.currency_code trx_currency, csl.trx_code trx_type, csl.bank_trx_number trx_no, 'CE' application, -- 'Interface' import_status, csh.record_status_flag interf_header_status_flag, 'INTERFACE' line_status_code, nvl2(csl.bank_account_num,null,'Y') no_statement_line_flag, -- Q8 null auto_created_misc_rec_flag, -- Q2 null line_recon_error_flag, -- Q3 null header_recon_error_flag, -- Q4 (select listagg (nvl(ce_cexinerr_xmlp_pkg.c_prt_message_nameformula(chie.message_name),', '),'Y') within group (order by chie.message_name) from ce_header_interface_errors chie where chie.bank_account_num = csh.bank_account_num and chie.statement_number = csh.statement_number) header_intf_error, -- Q5 (select listagg (chie.currency_code,', ') within group (order by chie.currency_code) from ce_header_interface_errors chie where chie.bank_account_num = csh.bank_account_num and chie.statement_number = csh.statement_number) header_intf_error_cur, -- Q5 (select listagg (nvl(ce_cexinerr_xmlp_pkg.c_prt_message_nameformula(clie.message_name),'Y'),', ') within group (order by clie.message_name) from ce_line_interface_errors clie where clie.bank_account_num = csl.bank_account_num and clie.statement_number = csl.statement_number and clie.line_number = csl.line_number) line_intf_error, -- Q7 (select listagg (clie.bank_acct_currency_code,', ') within group (order by clie.bank_acct_currency_code) from ce_line_interface_errors clie where clie.bank_account_num = csl.bank_account_num and clie.statement_number = csl.statement_number and clie.line_number = csl.line_number and rownum <= 1) line_intf_error_cur, -- Q7 to_number(null) recon_count, null recon_types, -- to_number(null) statement_header_id, to_number(null) statement_line_id -- from ce_statement_headers_int csh, ce_statement_lines_interface csl, ce_bank_accts_gt_v cbagv, ce_bank_branches_v cbbv where cbagv.bank_account_num (+) = csh.bank_account_num and cbagv.currency_code (+) = csh.currency_code and cbbv.branch_party_id (+) = cbagv.bank_branch_id ) x where 1=1 order by x.bank_name, x.bank_branch_name, x.bank_account_name, x.bank_account_number, x.statement_date, x.statement_number, x.line_number CE CEIMPERR_XML US CE Bank Statement Import Diagnostics Report to help diagnose the entries shown or missing from the CE Bank Statement Import Execution Report 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_sql_trace :p_stat_date_from :p_stat_date_to :p_stat_number_from :p_stat_number_to 1 10 1=1 x.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 x.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 x.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 x.bank_account_number=: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 x.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 x.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 x.statement_date>=trunc(:p_stat_date_from) Date AR تاريخ كشف الحساب من D Von Auszugsdatum F Date de déclaration du US Statement Date From ZHS 对帐单日期自 8 80 1=1 x.statement_date<trunc(:p_stat_date_to)+1 Date :$flex$.Statement_Date_From AR تاريخ كشف الحساب إلى D Bis Auszugsdatum F Date du relevé au US Statement Date To ZHS 对帐单日期至 :$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