Monday 31 October 2011

R12_Ap_Invoice to Po Vendors

/* Formatted on 17-08-2011 21:31:56 (QP5 v5.115.810.9015) */
SELECT   Hou.Name Operating_unit,
         aia.Invoice_num,
         aia.INVOICE_TYPE_LOOKUP_CODE,
         pov.vendor_name,
         site.VENDOR_SITE_CODE,
         aia.INVOICE_AMOUNT
  FROM   ap_invoices_all aia,
         hr_operating_units hou,
         po_vendors pov,
         po_vendor_sites_all site
 WHERE       hou.organization_id = aia.org_id
         AND pov.vendor_id = aia.vendor_id
         AND aia.vendor_site_id = site.VENDOR_SITE_ID
         AND TRUNC (aia.gl_Date) <= '31-MAR-2011'

No comments:

Post a Comment