Friday, September 14, 2012
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.
FROM iby_external_payers_all iep,
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
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
Do you think this Article is useful?
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.