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


4 Responses to “Query to Fetch Credit Card Details of a customer in R12”

Unknown said...
May 20, 2015 at 10:16 AM

This was real helpful. Thanks for sharing this query. Much of Help !!


Unknown said...
September 8, 2016 at 3:46 AM

Thanks for sharing.to get more details on credit card visit
ORACLE APPS -LEARN AND GROW


Chandra said...
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


markthomson said...
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

Disclaimer

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.