Loading

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:


0 Responses to “Suppliers data related to Payable Invoice in R12”

Post a Comment

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.