Suppliers data for Payable Invoice -- Oracle Apps R12

Suppliers data for Payable Invoice -- R12

Finding the Suppliers Data for Payable INVOICE.

APPS.AP_SUPPLIERS:

SELECT *

FROM   APPS.AP_SUPPLIERS

WHERE vendor_id IN

       (SELECT vendor_id

         FROM   APPS.AP_INVOICES_ALL

         WHERE invoice_id = '166014'

       );

APPS.AP_SUPPLIER_SITES_ALL:

SELECT *

FROM   APPS.AP_SUPPLIER_SITES_ALL

WHERE vendor_site_id IN

       (SELECT vendor_site_id

         FROM   APPS.AP_INVOICES_ALL

         WHERE invoice_id = '166014'

       );

HZ_PARTIES:

SELECT DISTINCT HZP.*

FROM   APPS.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   APPS.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';