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';
