Monday, January 10, 2011
Suppliers data related to Payable Invoice in R12
In this post, we will find the Suppliers Data related to the Payable INVOICE ( Invoice_id = 166014 ). All the queries given in this post and their related posts were tested in R12.1.1 Instance.
AP_SUPPLIERS
SELECT *
FROM AP_SUPPLIERS
WHERE vendor_id IN
( SELECT vendor_id
FROM AP_INVOICES_ALL
WHERE invoice_id = '166014'
);
AP_SUPPLIER_SITES_ALL
SELECT *
FROM AP_SUPPLIER_SITES_ALL
WHERE vendor_site_id IN
( SELECT vendor_site_id
FROM AP_INVOICES_ALL
WHERE invoice_id = '166014'
);
HZ_PARTIES
SELECT DISTINCT HZP.*
FROM AP_INVOICES_ALL AI,
HZ_PARTIES HZP
WHERE AI.PARTY_ID = HZP.PARTY_ID
AND AI.INVOICE_ID = '166014';
HZ_PARTY_SITES
SELECT DISTINCT HZPS.*
FROM AP_INVOICES_ALL AI,
HZ_PARTY_SITES HZPS
WHERE AI.PARTY_ID = HZPS.PARTY_ID
AND AI.PARTY_SITE_ID = HZPS.PARTY_SITE_ID
AND AI.INVOICE_ID = '166014';
Other Related Supplier posts:
Payable Invoice Data in other Modules
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
0 Responses to “Suppliers data related to Payable Invoice in R12”
Post a Comment