Wednesday, 20 February 2013

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;

No comments:

Post a Comment