Loading

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”

Sridevi K said...
October 8, 2016 at 12:32 AM

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.


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.