Friday, September 14, 2012
Query to Fetch Credit Card Details of a customer in R12
Query to Fetch the customer account related Credit Card Details
SELECT ipiu.instrument_payment_use_id,
ipiu.payment_flow,
ipiu.ext_pmt_party_id,
ipiu.instrument_type,
ipiu.instrument_id,
ic.ccnumber,
ic.card_issuer_code,
ipiu.payment_function,
DECODE (ipiu.order_of_preference,
1,
'Yes',
'NO'
) primary_flag,
ipiu.start_date,
ipiu.end_date,
ipiu.debit_auth_flag,
ipiu.debit_auth_method,
ipiu.debit_auth_reference,
ipiu.debit_auth_begin,
ipiu.debit_auth_end
FROM iby_pmt_instr_uses_all ipiu,
iby_creditcard ic,
iby_external_payers_all iep
WHERE ipiu.instrument_id =
ic.instrid
AND ipiu.ext_pmt_party_id = iep.ext_payer_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?
Subscribe to:
Post Comments (Atom)
2 Responses to “Query to Fetch Credit Card Details of a customer in R12”
May 20, 2015 at 10:16 AM
This was real helpful. Thanks for sharing this query. Much of Help !!
December 10, 2020 at 8:15 PM
when I ran query, I can see error message like below
ORA-00942: table or view does not exist
00942. 00000 - "table or view does not exist"
*Cause:
*Action:
Error at Line: 22 Column: 8
in this error Line: 22 is iby_creditcard ic
Post a Comment