Suppliers data related to Payable Invoice in R12

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