ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EF5D3869E053B46B63588994 select 'B' break_group, sh.statement_number statement_no, sh.doc_sequence_value doc_sequence_value, sl.line_number line_no, sh.statement_Date statement_date, sl.trx_date trx_date, ba.bank_account_num bank_acc, ba.bank_Account_name bank_Account_name, ba.currency_code acc_currency, null message_name, nvl(sl.amount,0) amount, l2.meaning trx_type, nvl(e.application_short_name,'CE') application_short_name, bb.branch_party_id bank_branch_id, sl.bank_Account_text bank_Account_text, e.deal_type deal_type, e.deal_num deal_num, e.transaction_num transaction_num, offset_deal_num offset_deal_num, 1 count, nvl(sl.currency_code,ba.currency_code) C_CURRENCY_CODE, offset_transaction_num offset_transaction_num, null counter_name, null subtype_name, null status, null cashflows_create, CE_CEZBAERR_XMLP_PKG.cf_line_countformula('B') CF_LINE_COUNT_MSG, CE_CEZBAERR_XMLP_PKG.cf_1formula('B') CF_ERROR_TYPE_MSG, CE_CEZBAERR_XMLP_PKG.c_prt_message_nameformula(null) C_PRT_MESSAGE_NAME from ce_lookups l2, ce_bank_accts_gt_v ba, ce_bank_branches_v bb, ce_Statement_headers sh, ce_statement_lines sl, ce_zba_Deal_messages e where l2.lookup_type = 'BANK_TRX_TYPE' AND l2.lookup_code = sl.trx_type AND :c_profile = 'XTR' AND bb.branch_party_id = ba.bank_branch_id AND bb.branch_party_id = :P_BANK_BRANCH_ID AND ba.bank_account_id = sh.bank_account_id AND ba.account_classification = 'INTERNAL' AND sh.statement_header_id = sl.statement_header_id AND sh.statement_header_id = e.statement_header_id AND sl.statement_line_id = e.statement_line_id AND e.statement_line_id is not null AND sl.status != 'EXTERNAL' AND ba.bank_account_id = DECODE(:P_BANK_ACCOUNT_ID,NULL,ba.bank_account_id,:P_BANK_ACCOUNT_ID) AND trunc(sh.statement_date) >= nvl(:LP_STAT_DATE_FROM,trunc(sh.statement_date)) AND trunc(sh.statement_date) <= nvl(:LP_STAT_DATE_TO,trunc(sh.statement_date)) AND sh.statement_number >= nvl(:P_STAT_NUMBER_FROM,sh.statement_number) AND sh.statement_number <= nvl(:P_STAT_NUMBER_TO,sh.statement_number) AND e.deal_status_flag = 'Y' union all select 'B' break_group, sh.statement_number statement_no, sh.doc_sequence_value doc_sequence_value, sl.line_number line_no, sh.statement_Date statement_date, sl.trx_date trx_date, ba.bank_account_num bank_acc, ba.bank_Account_name bank_Account_name, ba.currency_code acc_currency, null message_name, nvl(sl.amount,0) amount, l2.meaning trx_type, nvl(e.application_short_name,'CE') application_short_name, bb.branch_party_id bank_branch_id, sl.bank_Account_text bank_Account_text, e.deal_type deal_type, e.deal_num deal_num, e.transaction_num transaction_num, offset_deal_num offset_deal_num, 1 count, cpo.currency_code C_CURRENCY_CODE, offset_transaction_num offset_transaction_num, xle.name counter_name, trxn.transaction_sub_type_name subtype_name, l3.meaning status, l4.meaning cashflows_create, CE_CEZBAERR_XMLP_PKG.cf_line_countformula('B') CF_LINE_COUNT_MSG, CE_CEZBAERR_XMLP_PKG.cf_1formula('B') CF_ERROR_TYPE_MSG, CE_CEZBAERR_XMLP_PKG.c_prt_message_nameformula(null) C_PRT_MESSAGE_NAME from ce_lookups l2, ce_bank_accts_gt_v ba, ce_bank_branches_v bb, ce_Statement_headers sh, ce_statement_lines sl, ce_zba_Deal_messages e, ce_cashpools cpo, ce_payment_transactions bat, ce_trxns_subtype_codes trxn, xle_firstparty_information_v xle, ce_lookups l3, ce_lookups l4 where l2.lookup_type = 'BANK_TRX_TYPE' AND l2.lookup_code = sl.trx_type AND :c_profile = 'CE' AND bb.branch_party_id = ba.bank_branch_id AND bb.branch_party_id = :P_BANK_BRANCH_ID AND ba.bank_account_id = sh.bank_account_id AND ba.account_classification = 'INTERNAL' AND sh.statement_header_id = sl.statement_header_id AND sh.statement_header_id = e.statement_header_id AND sl.statement_line_id = e.statement_line_id AND e.statement_line_id is not null AND sl.status != 'EXTERNAL' AND ba.bank_account_id = DECODE(:P_BANK_ACCOUNT_ID,NULL,ba.bank_account_id,:P_BANK_ACCOUNT_ID) AND trunc(sh.statement_date) >= nvl(:LP_STAT_DATE_FROM,trunc(sh.statement_date)) AND trunc(sh.statement_date) <= nvl(:LP_STAT_DATE_TO,trunc(sh.statement_date)) AND sh.statement_number >= nvl(:P_STAT_NUMBER_FROM,sh.statement_number) AND sh.statement_number <= nvl(:P_STAT_NUMBER_TO,sh.statement_number) AND e.deal_status_flag = 'Y' AND e.cashpool_id = cpo.cashpool_id AND e.transaction_num = bat.trxn_reference_number AND cpo.trxn_subtype_code_id = trxn.trxn_subtype_code_id(+) AND bat.destination_legal_entity_id = xle.legal_entity_id AND l3.lookup_type = 'CE_BAT_STATUS' AND l3.lookup_code = bat.trxn_status_code AND l4.lookup_type = 'YES/NO' AND l4.lookup_code = e.cashflows_created_flag union all select 'C' break_group, sh.statement_number statement_no, sh.doc_sequence_value doc_sequence_value, sl.line_number line_no, sh.statement_date statement_date, sl.trx_date trx_date, ba.bank_account_num bank_acc, ba.bank_account_name bank_account_name, ba.currency_code acc_currency, e.message_name message_name, nvl(sl.amount,0) amount, l2.meaning trx_type, nvl(e.application_short_name,'CE') application_short_name, bb.branch_party_id bank_branch_id, sl.bank_account_text bank_account_text, null deal_type, null deal_num, null transaction_num, null offset_deal_num, 1 count, decode(:c_profile,'CE',nvl(cpo.currency_code,ba.currency_code),'XTR',nvl(sl.currency_code,ba.currency_code)) C_CURRENCY_CODE, null offset_transaction_num, null counter_name, null subtype_name, null status, null cashflows_create, CE_CEZBAERR_XMLP_PKG.cf_line_countformula('B') CF_LINE_COUNT_MSG, CE_CEZBAERR_XMLP_PKG.cf_1formula('B') CF_ERROR_TYPE_MSG, CE_CEZBAERR_XMLP_PKG.c_prt_message_nameformula(null) C_PRT_MESSAGE_NAME FROM ce_lookups l2, ce_bank_accts_gt_v ba, ce_bank_branches_v bb, ce_statement_headers sh, ce_statement_lines sl, ce_zba_deal_messages e, ce_cashpools cpo WHERE l2.lookup_type = 'BANK_TRX_TYPE' AND l2.lookup_code = sl.trx_type AND bb.branch_party_id = ba.bank_branch_id AND bb.branch_party_id = :P_BANK_BRANCH_ID AND ba.bank_account_id = sh.bank_account_id AND ba.account_classification='INTERNAL' AND sh.statement_header_id = sl.statement_header_id AND sh.statement_header_id = e.statement_header_id AND sl.statement_line_id = e.statement_line_id AND e.statement_line_id is not null AND sl.status != 'EXTERNAL' AND ba.bank_account_id = DECODE(:P_BANK_ACCOUNT_ID,NULL,ba.bank_account_id,:P_BANK_ACCOUNT_ID) AND trunc(sh.statement_date) >= nvl(:LP_STAT_DATE_FROM,trunc(sh.statement_date)) AND trunc(sh.statement_date) <= nvl(:LP_STAT_DATE_TO,trunc(sh.statement_date)) AND sh.statement_number >= nvl(:P_STAT_NUMBER_FROM,sh.statement_number) AND sh.statement_number <= nvl(:P_STAT_NUMBER_TO,sh.statement_number) AND e.deal_status_flag = 'N' AND e.cashpool_id = cpo.cashpool_id(+) UNION ALL SELECT 'A' break_group, sh.statement_number statement_no, sh.doc_sequence_value doc_sequence_value, 0 line_no, sh.statement_date statement_date, to_date(NULL) trx_date, ba.bank_account_num bank_acc, ba.bank_account_name bank_account_name, ba.currency_code acc_currency, e.message_name message_name, to_number(NULL) amount, NULL trx_type, NVL(e.application_short_name,'CE') application_short_name, bb.branch_party_id bank_branch_id, NULL bank_Account_text, null deal_type, null deal_num, null transaction_num, null offset_deal_num, 1 count, null C_CURRENCY_CODE, null offset_transaction_num, null counter_name, null subtype_name, null status, null cashflows_create, CE_CEZBAERR_XMLP_PKG.cf_line_countformula('B') CF_LINE_COUNT_MSG, CE_CEZBAERR_XMLP_PKG.cf_1formula('B') CF_ERROR_TYPE_MSG, CE_CEZBAERR_XMLP_PKG.c_prt_message_nameformula(null) C_PRT_MESSAGE_NAME FROM ce_bank_accts_gt_v ba, ce_bank_branches_v bb, ce_statement_headers sh, ce_zba_deal_messages e WHERE bb.branch_party_id = ba.bank_branch_id AND bb.branch_party_id = :P_BANK_BRANCH_ID AND ba.bank_account_id = sh.bank_account_id AND ba.account_classification = 'INTERNAL' AND sh.statement_header_id = e.statement_header_id AND e.statement_line_id is null AND ba.bank_account_id=decode(:P_BANK_ACCOUNT_ID,null,ba.bank_account_id,:P_BANK_ACCOUNT_ID) AND trunc(sh.statement_date) >= nvl(:LP_STAT_DATE_FROM,trunc(sh.statement_date)) AND trunc(sh.statement_date) <= nvl(:LP_STAT_DATE_TO,trunc(sh.statement_date)) AND sh.statement_number >= nvl(:P_STAT_NUMBER_FROM,sh.statement_number) AND sh.statement_number<= nvl(:P_STAT_NUMBER_TO,sh.statement_number) AND e.deal_status_flag = 'N' order by break_group, line_no CE CEZBAERR_XML AR CE تقرير تنفيذ تكوين حركات التحويل (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: إدارة النقدية Source: تقرير تنفيذ تكوين حركات التحويل (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: CEZBAERR_XML DB package: CE_CEZBAERR_XMLP_PKG D CE Sweep-Transaktionen generieren - Ergebnisse- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Cash Management Source: Sweep-Transaktionen generieren - Ergebnisse (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: CEZBAERR_XML DB package: CE_CEZBAERR_XMLP_PKG F CE Compte rendu d'exécution de la génération des mouvements de transfert- Non pris en charge : réservé pour une utilisation future Application: Cash Management Source: Compte rendu d'exécution de la génération des mouvements de transfert (XML) - Non pris en charge : réservé pour une utilisation future Short Name: CEZBAERR_XML DB package: CE_CEZBAERR_XMLP_PKG US CE Sweep Transactions Generation Execution - draft Application: Cash Management Source: Sweep Transactions Generation Execution Report (XML) - Not Supported: Reserved For Future Use Short Name: CEZBAERR_XML DB package: CE_CEZBAERR_XMLP_PKG ZHS CE 转移事务处理生成执行报表- 不支持：已保留供将来使用 Application: 现金管理系统 Source: 转移事务处理生成执行报表 (XML) - 不支持：已保留供将来使用 Short Name: CEZBAERR_XML DB package: CE_CEZBAERR_XMLP_PKG BI Publisher :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_dsp :c_company_name_header :c_profile :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 :p_bank_branch_id LOV Oracle CE_BANK_BRANCHES Y select branch_party_id id, bank_branch_name value, bank_name description from ce_bank_branches_v where branch_party_id in (select bank_branch_id from ce_bank_accounts a where a.account_classification='INTERNAL' ) order by bank_branch_name,bank_name Y AR اسم فرع البنك D Zweigstellenbezeichnung F Nom de l'agence bancaire US Bank Branch Name ZHS 分行名称 2 20 :p_bank_account_id LOV Oracle CE_ZBA_BANK_ACCT_NUM Y select bank_account_id id, bank_account_num value, bank_account_name description from ce_bank_accounts where bank_branch_id=nvl(:$flex$.ce_bank_branches, bank_branch_id) and bank_account_id in (select bank_account_id from ce_bank_accounts_v where cep_standard.check_ba_security(account_owner_org_id,'CEBAT')=1 and fnd_profile.value('CE_BANK_ACCOUNT_TRANSFERS')='CE' union all select ba.bank_account_id from ce_bank_accounts ba,ce_bank_acct_uses_all bau,ce_security_profiles_v ou where bau.bank_account_id=ba.bank_account_id and ba.xtr_use_allowed_flag='Y' and bau.authorized_flag='Y' and bau.legal_entity_id=ou.organization_id and ou.organization_type='LEGAL_ENTITY' and fnd_profile.value('CE_BANK_ACCOUNT_TRANSFERS')='XTR') order by bank_account_name AR رقم حساب البنك D Kontonummer F Numéro de compte bancaire US Bank Account Number ZHS 银行帐号 3 30 :p_stat_number_from LOV Oracle CE_ABR_XTR_STATEMENT_NUM_FROM Y select statement_number id, statement_number value, null description from ce_statement_headers where bank_account_id=:$flex$.ce_zba_bank_acct_num and (statement_complete_flag is null or statement_complete_flag='N') order by statement_number AR رقم كشف الحساب من D Von Auszugsnummer F Numéro de relevé - De US Statement Number From ZHS 对帐单编号自 4 40 :p_stat_number_to LOV Oracle CE_ABR_XTR_STATEMENT_NUM_TO Y select statement_number id, statement_number value, null description from ce_statement_headers where bank_account_id=:$flex$.ce_zba_bank_acct_num and (statement_complete_flag is null or statement_complete_flag='N') and statement_number>=:$flex$.ce_abr_xtr_statement_num_from order by statement_number AR رقم كشف الحساب إلى D Bis Auszugsnummer F Numéro de relevé - A US Statement Number To ZHS 对帐单编号至 5 50 :p_stat_date_from Date AR تاريخ كشف الحساب من D Von Auszugsdatum F Date de relevé - Du US Statement Date From ZHS 对帐单日期自 6 60 :p_stat_date_to Date AR تاريخ كشف الحساب إلى D Bis Auszugsdatum F Date de relevé - Au US Statement Date To ZHS 对帐单日期至 :$flex$.ce_abr_xtr_statement_num_from Statement Number From Statement Number To :$flex$.ce_bank_branches Bank Branch Name Bank Account Number :$flex$.ce_zba_bank_acct_num Bank Account Number Statement Number From :$flex$.ce_zba_bank_acct_num Bank Account Number Statement Number To