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;


1 Responses to “Query to Fetch the customer Bank Details in R12”

Kishor Kumar said...
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

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.