ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EEC23869E053B46B63588994 select bra1.bank_name, bra1.bank_branch_name, cba1.bank_account_name, cba1.bank_account_num, bra1.address_line1, bra1.address_line2, bra1.address_line3, bra1.zip, bra1.city, bra1.state, bra1.country, bat.name, cas.currency_code, crh1.trx_date, cas.receipt_number, pay.due_date, decode(bra2.instrument_type,'BANKACCOUNT',bra2.bank_name,'CREDITCARD',bra2.card_issuer_name,'DEBITCARD',bra2.card_issuer_name,null) bank_name, cas.amount, (crh1.acctd_amount + nvl(crh1.acctd_factor_discount_amount,0)) func_curr from ar_cash_receipt_history crh1, ar_cash_receipts cas, ar_payment_schedules pay, ar_batches bat, ce_bank_branches_v bra1, ce_bank_accounts cba1, ce_bank_acct_uses acc1, iby_trxn_extensions_v extn, iby_fndcpt_payer_assgn_instr_v bra2 where bra1.branch_party_id = :P_bnk_branch_id &lp_bank_account and crh1.cash_receipt_id = cas.cash_receipt_id and crh1.factor_flag = 'Y' and crh1.current_record_flag = 'Y' and crh1.status ='CLEARED' and (cas.cash_receipt_id, bat.batch_id) in (select distinct crh2.cash_receipt_id, crh2.batch_id from ar_cash_receipt_history crh2 where crh2 . status = 'REMITTED' ) and cas.remit_bank_acct_use_id = acc1.bank_acct_use_id and cba1.bank_branch_id = bra1.branch_party_id and cba1.bank_account_id = acc1.bank_account_id and cas.payment_trxn_extension_id = extn.trxn_extension_id(+) and extn.instrument_id = bra2.instrument_id(+) and cas.cash_receipt_id = pay.cash_receipt_id(+) order by bra1.bank_name, bra1.bank_branch_name, cba1.bank_account_name, bat.name, pay.due_date Y AR ARXRBRD_XML AR AR تقرير مخاطر البنك (بتنسيق XML) Application: المقبوضات Source: تقرير مخاطر البنك (بتنسيق XML) Short Name: ARXRBRD_XML DB package: AR_ARXRBRD_XMLP_PKG D AR Bankrisiko Application: Debitoren Source: Bankrisiko (XML) Short Name: ARXRBRD_XML DB package: AR_ARXRBRD_XMLP_PKG F AR Etat Risque bancaire Application: Receivables Source: Etat Risque bancaire (XML) Short Name: ARXRBRD_XML DB package: AR_ARXRBRD_XMLP_PKG US AR Bank Risk Application: Receivables Source: Bank Risk Report (XML) Short Name: ARXRBRD_XML DB package: AR_ARXRBRD_XMLP_PKG ZHS AR 银行风险报表 Application: 应收帐款 Source: 银行风险报表 (XML) Short Name: ARXRBRD_XML DB package: AR_ARXRBRD_XMLP_PKG BI Publisher &lp_bank_account :c_company_name :c_functional_currency :c_no_data_message :lp_bank_account :operating_unit :p_bank_account_name :p_bnk_branch_id :p_conc_request_id 1 10 :p_bnk_branch_id LOV Oracle AR_REMIT_BRANCHES Y select branch_party_id id, bank_name value, null description from ce_bank_branches_v where branch_party_id in ( select cba.bank_branch_id from ce_bank_acct_uses ba,ce_bank_accounts cba where ba.bank_account_id=cba.bank_account_id and cba.account_classification='INTERNAL') order by bank_name,bank_branch_name Y AR الفرع/البنك المستفيد D Bank/Zweigstelle F Banque/agence de remise US Remittance Bank/Branch ZHS 汇款银行/分行 2 20 :p_bank_account_name LOV Oracle AR_REMIT_BANK_ACCOUNTS Y select cba.bank_account_name id, cba.bank_account_name value, null description from ce_bank_acct_uses ba,ce_bank_accounts cba,ce_bank_branches_v bb where cba.bank_branch_id=:$flex$.ar_remit_branches and cba.account_classification='INTERNAL' and ba.bank_account_id=cba.bank_account_id and cba.bank_branch_id=bb.branch_party_id order by cba.bank_account_name AR اسم حساب البنك المستفيد D Bankkonto F Intitulé du compte bancaire de remise US Remittance Bank Account Name ZHS 汇款银行帐户名 :$flex$.ar_remit_branches Remittance Bank/Branch Remittance Bank Account Name