1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

R12 Queries to Pull up Supplier Info on AP invoices

Discussion in 'Oracle Apps Technical' started by Ramji, Mar 4, 2012.

  1. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    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';
     
    Bharat likes this.