Friday, September 14, 2012
Query to Fetch the customer account related bank details
DECODE (ipiu.order_of_preference, 1, 'YES', 'NO') primary_flag,
FROM iby_pmt_instr_uses_all ipiu,
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?
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.