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;
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