ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EF583869E053B46B63588994 SELECT l1.meaning error_type, 'D' 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, acr.currency_code C_CURRENCY_CODE, l2.meaning trx_type, acr.receipt_number trx_no, 'CE' application_short_name, bb.branch_party_id bank_branch_id, CE_CEXINERR_XMLP_PKG.c_prt_message_nameformula(NULL) C_PRT_MESSAGE_NAME FROM ce_lookups l1, ce_lookups l2, ce_bank_accts_gt_v ba, ce_bank_branches_v bb, ce_statement_headers sh, ce_statement_lines sl, ar_cash_receipts_all acr, ce_222_reconciled_v cr WHERE l1.lookup_type = 'ABR_REPORT_EXCEPTIONS' AND l1.lookup_code = 'MISC_RECEIPT_CREATED' AND 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 sh.statement_header_id = sl.statement_header_id AND ba.bank_account_id = DECODE(:P_BANK_ACCOUNT_ID, NULL, ba.bank_account_id, :P_BANK_ACCOUNT_ID) AND to_char(sh.statement_date,'YYYY/MM/DD') >= nvl(to_char(:P_STAT_DATE_FROM,'YYYY/MM/DD'), to_char(sh.statement_date,'YYYY/MM/DD') ) AND to_char(sh.statement_date,'YYYY/MM/DD') <= nvl(to_char(:P_STAT_DATE_TO,'YYYY/MM/DD'), to_char(sh.statement_date,'YYYY/MM/DD') ) 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 acr.cash_receipt_id = cr.cash_receipt_id and cr.statement_line_id = sl.statement_line_id and acr.comments = 'Created by Auto Bank Rec' UNION ALL SELECT l1.description error_type, '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, nvl(sl.currency_code,ba.currency_code) C_CURRENCY_CODE, l2.meaning trx_type, sl.bank_trx_number trx_no, NVL(e.application_short_name,'CE') application_short_name, bb.branch_party_id bank_branch_id, CE_CEXINERR_XMLP_PKG.c_prt_message_nameformula(e.message_name) C_PRT_MESSAGE_NAME FROM ce_lookups l1, ce_lookups l2, ce_bank_accts_gt_v ba, ce_bank_branches_v bb, ce_statement_headers sh, ce_statement_lines sl, ce_reconciliation_errors e WHERE l2.lookup_type = 'BANK_TRX_TYPE' AND l2.lookup_code = sl.trx_type AND l1.lookup_type = 'ABR_REPORT_EXCEPTIONS' AND l1.lookup_code='RECONCILIATION' 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 to_char(sh.statement_date,'YYYY/MM/DD') >= nvl(to_char(:P_STAT_DATE_FROM,'YYYY/MM/DD'), to_char(sh.statement_date,'YYYY/MM/DD') ) AND to_char(sh.statement_date,'YYYY/MM/DD') <= nvl(to_char(:P_STAT_DATE_TO,'YYYY/MM/DD'), to_char(sh.statement_date,'YYYY/MM/DD') ) AND sh.statement_number >= nvl(:P_STAT_NUMBER_FROM,sh.statement_number) AND sh.statement_number <= nvl(:P_STAT_NUMBER_TO,sh.statement_number) UNION ALL SELECT l1.description error_type, 'C' 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, ba.currency_code C_CURRENCY_CODE, NULL trx_type, NULL trx_no, NVL(e.application_short_name,'CE') application_short_name, bb.branch_party_id bank_branch_id, CE_CEXINERR_XMLP_PKG.c_prt_message_nameformula(e.message_name) C_PRT_MESSAGE_NAME FROM ce_lookups l1, ce_bank_accts_gt_v ba, ce_bank_branches_v bb, ce_statement_headers sh, ce_reconciliation_errors e WHERE l1.lookup_type = 'ABR_REPORT_EXCEPTIONS' AND l1.lookup_code='RECONCILIATION' 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 = 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 to_char(sh.statement_date,'YYYY/MM/DD') >= nvl(to_char(:P_STAT_DATE_FROM,'YYYY/MM/DD'), to_char(sh.statement_date,'YYYY/MM/DD') ) AND to_char(sh.statement_date,'YYYY/MM/DD') <= nvl(to_char(:P_STAT_DATE_TO,'YYYY/MM/DD'), to_char(sh.statement_date,'YYYY/MM/DD') ) AND sh.statement_number >= nvl(:P_STAT_NUMBER_FROM,sh.statement_number) AND sh.statement_number <= nvl(:P_STAT_NUMBER_TO,sh.statement_number) UNION ALL (SELECT l.description error_type, 'A' break_group, e.statement_number statement_no, to_number(NULL) doc_sequence_value, 1 line_no, sh.statement_date statement_date, sh.statement_date trx_date, e.bank_account_num bank_acc, ba.bank_account_name bank_account_name, ba.currency_code acc_currency, e.message_name message_name, 0 amount, ' ' C_CURRENCY_CODE, ' ' trx_type, ' ' trx_no, NVL(e.application_short_name,'CE') application_short_name, bb.branch_party_id bank_branch_id, CE_CEXINERR_XMLP_PKG.c_prt_message_nameformula(e.message_name) C_PRT_MESSAGE_NAME FROM ce_lookups l, ce_statement_headers_int sh, ce_header_interface_errors e, ce_bank_branches_v bb, ce_bank_accts_gt_v ba WHERE l.lookup_type = 'ABR_REPORT_EXCEPTIONS' AND l.lookup_code='STATEMENT' AND sh.bank_account_num = e.bank_account_num AND sh.statement_number = e.statement_number AND sh.bank_branch_name = bb.bank_branch_name AND e.bank_account_num = NVL(ba.bank_account_num, e.bank_account_num) AND ba.bank_branch_id = bb.branch_party_id AND bb.bank_branch_name = DECODE(:C_BANK_BRANCH_NAME_DSP, :C_ALL_TRANSLATION, bb.bank_branch_name, :C_BANK_BRANCH_NAME_DSP) AND ba.bank_account_id = NVL(:P_BANK_ACCOUNT_ID, ba.bank_account_id) AND ba.account_classification = 'INTERNAL' AND to_char(sh.statement_date,'YYYY/MM/DD') >= nvl(to_char(:P_STAT_DATE_FROM,'YYYY/MM/DD'), to_char(sh.statement_date,'YYYY/MM/DD') ) AND to_char(sh.statement_date,'YYYY/MM/DD') <= nvl(to_char(:P_STAT_DATE_TO,'YYYY/MM/DD'), to_char(sh.statement_date,'YYYY/MM/DD') ) AND sh.statement_number >= nvl(:P_STAT_NUMBER_FROM,sh.statement_number) AND sh.statement_number <= nvl(:P_STAT_NUMBER_TO,sh.statement_number) UNION SELECT l.description error_type, 'A' break_group, e.statement_number statement_no, to_number(NULL) doc_sequence_value, 1 line_no, sh.statement_date statement_date, sh.statement_date trx_date, e.bank_account_num bank_acc, ba.bank_account_name bank_account_name, ba.currency_code acc_currency, e.message_name message_name, 0 amount, ' ' C_CURRENCY_CODE, ' ' trx_type, ' ' trx_no, NVL(e.application_short_name,'CE') application_short_name, bb.branch_party_id bank_branch_id, CE_CEXINERR_XMLP_PKG.c_prt_message_nameformula(e.message_name) C_PRT_MESSAGE_NAME FROM ce_lookups l, ce_statement_headers sh, ce_header_interface_errors e, ce_bank_branches_v bb, ce_bank_accts_gt_v ba WHERE l.lookup_type = 'ABR_REPORT_EXCEPTIONS' AND l.lookup_code='STATEMENT' AND e.bank_account_num = ba.bank_account_num AND e.statement_number = sh.statement_number AND sh.bank_account_id = ba.bank_account_id AND ba.bank_branch_id = bb.branch_party_id AND bb.bank_branch_name = DECODE(:C_BANK_BRANCH_NAME_DSP, :C_ALL_TRANSLATION, bb.bank_branch_name, :C_BANK_BRANCH_NAME_DSP) AND ba.bank_account_id = NVL(:P_BANK_ACCOUNT_ID, ba.bank_account_id) AND ba.account_classification = 'INTERNAL' AND to_char(sh.statement_date,'YYYY/MM/DD') >= nvl(to_char(:P_STAT_DATE_FROM,'YYYY/MM/DD'), to_char(sh.statement_date,'YYYY/MM/DD') ) AND to_char(sh.statement_date,'YYYY/MM/DD') <= nvl(to_char(:P_STAT_DATE_TO,'YYYY/MM/DD'), to_char(sh.statement_date,'YYYY/MM/DD') ) AND sh.statement_number >= nvl(:P_STAT_NUMBER_FROM,sh.statement_number) AND sh.statement_number <= nvl(:P_STAT_NUMBER_TO,sh.statement_number) ) UNION ALL SELECT l.description error_type, 'B' break_group, e.statement_number statement_no, to_number(NULL) doc_sequence_value, e.line_number line_no, sh.statement_date statement_date, sl.trx_date trx_date, e.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, NVL(curr.currency_code, ba.CURRENCY_CODE) C_CURRENCY_CODE, ' ' trx_type, ' ' trx_no, NVL(e.application_short_name,'CE') application_short_name, bb.branch_party_id bank_branch_id, CE_CEXINERR_XMLP_PKG.c_prt_message_nameformula(e.message_name) C_PRT_MESSAGE_NAME FROM fnd_currencies curr, ce_lookups l, ce_statement_headers_int sh, ce_statement_lines_interface sl, ce_line_interface_errors e, ce_bank_branches_v bb, ce_bank_accts_gt_v ba WHERE curr.currency_code(+) = sl.currency_code AND l.lookup_type = 'ABR_REPORT_EXCEPTIONS' AND l.lookup_code='LINE' AND sh.bank_account_num = sl.bank_account_num AND sh.statement_number = sl.statement_number AND sl.line_number = e.line_number AND sl.statement_number = e.statement_number AND sl.bank_account_num = e.bank_account_num AND bb.bank_branch_name = sh.bank_branch_name AND bb.branch_party_id = ba.bank_branch_id AND e.bank_account_num = NVL(ba.bank_account_num, e.bank_account_num) AND bb.bank_branch_name = DECODE(:C_BANK_BRANCH_NAME_DSP, :C_ALL_TRANSLATION, bb.bank_branch_name, :C_BANK_BRANCH_NAME_DSP) AND ba.bank_account_id = NVL(:P_BANK_ACCOUNT_ID, ba.bank_account_id) AND ba.account_classification = 'INTERNAL' AND to_char(sh.statement_date,'YYYY/MM/DD') >= nvl(to_char(:P_STAT_DATE_FROM,'YYYY/MM/DD'), to_char(sh.statement_date,'YYYY/MM/DD') ) AND to_char(sh.statement_date,'YYYY/MM/DD') <= nvl(to_char(:P_STAT_DATE_TO,'YYYY/MM/DD'), to_char(sh.statement_date,'YYYY/MM/DD') ) AND sh.statement_number >= nvl(:P_STAT_NUMBER_FROM,sh.statement_number) AND sh.statement_number <= nvl(:P_STAT_NUMBER_TO,sh.statement_number) ORDER BY 5 CE CEXINERR_XML Y AR CE تقرير تنفيذ التسوية الآلية (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: إدارة النقدية Source: تقرير تنفيذ التسوية الآلية (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: CEXINERR_XML DB package: CE_CEXINERR_XMLP_PKG D CE Automatische Abstimmung - Ergebnisse- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Cash Management Source: Automatische Abstimmung - Ergebnisse (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: CEXINERR_XML DB package: CE_CEXINERR_XMLP_PKG F CE Compte rendu d'exécution du rapprochement automatique- Non pris en charge : réservé pour une utilisation future Application: Cash Management Source: Compte rendu d'exécution du rapprochement automatique (XML) - Non pris en charge : réservé pour une utilisation future Short Name: CEXINERR_XML DB package: CE_CEXINERR_XMLP_PKG US CE AutoReconciliation Execution - draft Application: Cash Management Source: AutoReconciliation Execution Report (XML) - Not Supported: Reserved For Future Use Short Name: CEXINERR_XML DB package: CE_CEXINERR_XMLP_PKG ZHS CE 自动调节执行报表- 不支持：已保留供将来使用 Application: 现金管理系统 Source: 自动调节执行报表 (XML) - 不支持：已保留供将来使用 Short Name: CEXINERR_XML DB package: CE_CEXINERR_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 :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 :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_BANK_ACC_NUM Y select bank_account_id id, bank_account_num value, bank_account_name description from ce_bank_accounts_v where bank_branch_id=nvl(:$flex$.ce_bank_branches, bank_branch_id) and account_classification='INTERNAL' 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_ALL_STATEMENT_NUM_FROM Y select statement_number id, statement_number value, null description from ce_all_statements_v where bank_account_id=:$flex$.ce_bank_acc_num 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_ALL_STATEMENT_NUM_TO Y select statement_number id, statement_number value, null description from ce_all_statements_v where bank_account_id=:$flex$.ce_bank_acc_num and statement_number>=:$flex$.ce_abr_all_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_all_statement_num_from Statement Number From Statement Number To :$flex$.ce_bank_acc_num Bank Account Number Statement Number From :$flex$.ce_bank_acc_num Bank Account Number Statement Number To :$flex$.ce_bank_branches Bank Branch Name Bank Account Number