Friday, September 14, 2012
Query to Fetch the customer Bank Details in R12
Query to Fetch the customer account related bank details
SELECT ipiu.instrument_payment_use_id,
ipiu.payment_flow,
ipiu.ext_pmt_party_id,
ipiu.instrument_type,
ipiu.instrument_id,
cb.bank_name,
cb.bank_branch_name,
ieb.currency_code,
ieb.bank_account_name,
ieb.bank_account_num,
ipiu.payment_function,
DECODE (ipiu.order_of_preference, 1, 'YES', 'NO') primary_flag,
ieb.start_date,
ieb.end_date,
ipiu.debit_auth_flag,
ipiu.debit_auth_method,
ipiu.debit_auth_reference,
ipiu.debit_auth_begin,
ipiu.debit_auth_end,
iep.org_id
FROM iby_pmt_instr_uses_all ipiu,
iby_ext_bank_accounts ieb,
iby_external_payers_all iep,
ce_bank_branches_v cb
WHERE ieb.ext_bank_account_id = ipiu.instrument_id
AND ipiu.ext_pmt_party_id =
iep.ext_payer_id
AND cb.bank_party_id =
ieb.bank_id
AND iep.cust_account_id =
:vl_cust_account_id
AND iep.acct_site_use_id =
:vl_cust_site_use_id;
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
1 Responses to “Query to Fetch the customer Bank Details in R12”
March 22, 2018 at 11:17 PM
Hi ,
Please add the below condition also.
and cb.BRANCH_PARTY_ID = ieb.BRANCH_ID
Post a Comment