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)
4 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 !!
September 8, 2016 at 3:46 AM
Thanks for sharing.to get more details on credit card visit
ORACLE APPS -LEARN AND GROW
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
March 6, 2021 at 5:59 AM
A debt of gratitude is in order for your post. I've been contemplating composing an extremely tantamount post in the course of the last couple of weeks, I'll most likely keep it straightforward and connection to this rather if thats cool. Much obliged. 8006698488
Post a Comment