Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Sunday, July 31, 2011

Supplier Site Payment Methods in R12

In R12 the suppliers were merged into the Trading Community Architecture (TCA).
The default payment method for supplier sites are now located in the IBY_EXT_PARTY_PMT_MTHDS table and not the AP_SUPPLIER_SITES_ALL table.
Below is a query that will return a list of all suppliers, supplier sites and their payment methods.
The default payment method is denoted with a primary flag = ‘Y’.

SELECT ieppm.ext_party_pmt_mthd_id,
sup.vendor_name,
assa.vendor_site_code,
ieppm.payment_method_code,
ieppm.primary_flag,
ieppm.inactive_date,
assa.org_id,
sup.vendor_id,
assa.vendor_site_id
FROM ap_supplier_sites_all assa,
ap_suppliers sup,
iby_external_payees_all iepa,
iby_ext_party_pmt_mthds ieppm
WHERE sup.vendor_id = assa.vendor_id
AND assa.pay_site_flag = ‘Y’
AND assa.vendor_site_id = iepa.supplier_site_id
AND iepa.ext_payee_id = ieppm.ext_pmt_party_id
AND( (ieppm.inactive_date IS NULL)or (ieppm.inactive_date > sysdate))
ORDER BY sup.vendor_name, assa.vendor_site_code;

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect