ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EF523869E053B46B63588994 SELECT 'A' break_group, bb.bank_name bank_name, ba.bank_account_name bank_account_name, ba.currency_code ba_currency_code, sh.statement_number statement_number, to_char(sh.statement_date,'DD-MON-RRRR') statement_date, sl.statement_line_id statement_line_id, sl.line_number line_number, l1.meaning trx_type, sl.trx_date transaction_date, nvl(sh.currency_code,ba.currency_code) currency_code, sl.amount amount, e.message_name error, null trxn_subtype, null reference, null cashflow_number, null cashflow_currency, null cashflow_amount, CE_CEJEEXER_XMLP_PKG.c_message_dspformula(e.message_name) C_MESSAGE_DSP FROM ce_bank_accts_gt_v ba, ce_bank_branches_v bb, ce_statement_headers sh, ce_statement_lines sl, ce_je_messages e, ce_lookups l1 WHERE e.request_id = :P_REQUEST_ID and sh.bank_account_id = ba.bank_account_id and ba.bank_branch_id = bb.branch_party_id and sh.statement_header_id = sl.statement_header_id and sl.statement_line_id = e.statement_line_id and sl.cashflow_id is null and sh.statement_header_id = e.statement_header_id and l1.lookup_type = 'BANK_TRX_TYPE' and l1.lookup_code = sl.trx_type UNION ALL SELECT 'B' break_group, bb.bank_name bank_name, ba.bank_account_name bank_account_name, ba.currency_code ba_currency_code, sh.statement_number statement_number, to_char(sh.statement_date,'DD-MON-RRRR') statement_date, sl.statement_line_id statement_line_id, sl.line_number line_number, l1.meaning trx_type, sl.trx_date transaction_date, nvl(sh.currency_code,ba.currency_code) currency_code, sl.amount amount, null error, trxn.transaction_sub_type_name trxn_subtype, ca.reference_text reference, ca.cashflow_id cashflow_number, nvl(ca.cashflow_currency_code,ba.currency_code) cashflow_currency, ca.cashflow_amount cashflow_amount, CE_CEJEEXER_XMLP_PKG.c_message_dspformula(null) C_MESSAGE_DSP FROM ce_bank_accts_gt_v ba, ce_bank_branches_v bb, ce_statement_headers sh, ce_statement_lines sl, ce_lookups l1, ce_cashflows ca, ce_je_messages e, ce_trxns_subtype_codes trxn WHERE bb.branch_party_id = :P_BANK_BRANCH_ID and ba.bank_branch_id = bb.branch_party_id and ba.bank_account_id = NVL(:P_BANK_ACCOUNT_ID,ba.bank_account_id) and sh.bank_account_id = ba.bank_account_id and ba.account_classification = 'INTERNAL' and trunc(sh.statement_date) >= nvl(:P_STAT_DATE_FROM,trunc(sh.statement_date)) and trunc(sh.statement_date) <= nvl(:P_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 sl.statement_header_id = sh.statement_header_id and sl.statement_line_id = e.statement_line_id and sh.statement_header_id = e.statement_header_id and sl.cashflow_id = ca.cashflow_id and ca.trxn_reference_number is null and sl.status <> 'EXTERNAL' and sl.statement_line_id = ca.statement_line_id and ca.source_trxn_subtype_code_id = trxn.trxn_subtype_code_id(+) and l1.lookup_type = 'BANK_TRX_TYPE' and l1.lookup_code = sl.trx_type UNION ALL SELECT 'C' break_group, bb.bank_name bank_name, ba.bank_account_name bank_account_name, ba.currency_code ba_currency_code, sh.statement_number statement_number, to_char(sh.statement_date,'DD-MON-RRRR') statement_date, sl.statement_line_id statement_line_id, sl.line_number line_number, l1.meaning trx_type, sl.trx_date transaction_date, nvl(sh.currency_code,ba.currency_code) currency_code, sl.amount amount, null error, trxn.transaction_sub_type_name trxn_subtype, ca.reference_text reference, ca.cashflow_id cashflow_number, nvl(ca.cashflow_currency_code,ba.currency_code) cashflow_currency, ca.cashflow_amount cashflow_amount, CE_CEJEEXER_XMLP_PKG.c_message_dspformula(null) C_MESSAGE_DSP FROM ce_bank_accts_gt_v ba, ce_bank_branches_v bb, ce_statement_headers sh, ce_statement_lines sl, ce_lookups l1, ce_cashflows ca, ce_trxns_subtype_codes trxn WHERE bb.branch_party_id = :P_BANK_BRANCH_ID and ba.bank_branch_id = bb.branch_party_id and ba.bank_account_id = NVL(:P_BANK_ACCOUNT_ID,ba.bank_account_id) and sh.bank_account_id = ba.bank_account_id and ba.account_classification = 'INTERNAL' and trunc(sh.statement_date) >= nvl(:P_STAT_DATE_FROM,trunc(sh.statement_date)) and trunc(sh.statement_date) <= nvl(:P_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 sl.statement_header_id = sh.statement_header_id and sl.cashflow_id = ca.cashflow_id and ca.trxn_reference_number is null and sl.statement_line_id not in (select statement_line_id from ce_je_messages) and sl.status <> 'EXTERNAL' and sl.statement_line_id = ca.statement_line_id and ca.source_trxn_subtype_code_id = trxn.trxn_subtype_code_id(+) and l1.lookup_type = 'BANK_TRX_TYPE' and l1.lookup_code = sl.trx_type ORDER BY statement_number, break_group, statement_line_id CE CEJEEXER_XML AR CE تقرير تنفيذ تكوين تدفق نقدية لكشف حساب البنك (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: إدارة النقدية Source: تقرير تنفيذ تكوين تدفق نقدية لكشف حساب البنك (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: CEJEEXER_XML DB package: CE_CEJEEXER_XMLP_PKG D CE Kontoauszug - Cashflow erstellen - Ergebnisse- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Cash Management Source: Kontoauszug - Cashflow erstellen - Ergebnisse (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: CEJEEXER_XML DB package: CE_CEJEEXER_XMLP_PKG F CE Compte rendu d'exécution de la création de mouvements de trésorerie de relevé bancaire- Non pris en charge : réservé pour une utilisation future Application: Cash Management Source: Compte rendu d'exécution de la création de mouvements de trésorerie de relevé bancaire (XML) - Non pris en charge : réservé pour une utilisation future Short Name: CEJEEXER_XML DB package: CE_CEJEEXER_XMLP_PKG US CE Bank Statement Cashflow Creation Execution - draft Application: Cash Management Source: Bank Statement Cashflow Creation Execution Report (XML) - Not Supported: Reserved For Future Use Short Name: CEJEEXER_XML DB package: CE_CEJEEXER_XMLP_PKG ZHS CE 银行对帐单现金流量创建执行报表- 不支持：已保留供将来使用 Application: 现金管理系统 Source: 银行对帐单现金流量创建执行报表 (XML) - 不支持：已保留供将来使用 Short Name: CEJEEXER_XML DB package: CE_CEJEEXER_XMLP_PKG BI Publisher :c_all_translation :c_bank_account_num_dsp :c_bank_branch_name_dsp :c_bank_currency_code_dsp :c_base_currency_code_dsp :c_company_name_header :p_bank_account_id :p_bank_branch_id :p_conc_request_id :p_report_mode :p_request_id :p_stat_date_from :p_stat_date_to :p_stat_number_from :p_stat_number_to :zp_stat_date_from :zp_stat_date_to