Loading

Friday, September 14, 2012

Query to Fetch the Customer Payment Attributes and Receipt Method details in R12



Query to Fetch the Payment attribute details of the customer account level or customer account site level. At data level, customer account site level payment attribute record will have its column  acct_site_use_id populated.


SELECT iep.ext_payer_id,
       iep.payment_function,
       iep.party_id,
       iep.org_type,
       iep.org_id,
       ou.NAME org_name,
       iep.cust_account_id,
       iep.acct_site_use_id,
       iep.bank_charge_bearer_code,
       iep.dirdeb_instruction_code,
       iep.debit_advice_delivery_method,
       iep.debit_advice_email,
       iep.debit_advice_fax
  FROM iby_external_payers_all iep,
       hr_operating_units ou
 WHERE iep.org_id          = ou.organization_id(+)
   AND iep.cust_account_id = vl_cust_account_id
   AND iep.acct_site_use_id= vl_acct_site_use_id


Query to find the receipt methods associated with Customer Account/Site


SELECT rcrm.cust_receipt_method_id,
       rcrm.customer_id,
       rcrm.receipt_method_id,
       rcrm.receipt_method_name,
       rcrm.primary_flag,
       rcrm.site_use_id,
       rcrm.start_date,
       rcrm.end_date
  FROM ar_cust_receipt_methods_v rcrm
 WHERE 1 = 1
   AND rcrm.customer_id = :vl_cust_account_id
   AND rcrm.site_use_id = :vl_cust_site_use_id

2 Responses to “Query to Fetch the Customer Payment Attributes and Receipt Method details in R12”

Muhammad Amir said...
December 20, 2012 at 10:32 PM

The methodology described here is one of the proven strategies which we used in our conversion project. PPI Claims Management


Sridevi K said...
October 8, 2016 at 12:32 AM

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.


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.