Monday, 8 June 2015

Invoice with or without PO query in oracle apps




/* Formatted on 6/8/2015 3:08:16 PM (QP5 v5.240.12305.39446) */
SELECT PO_DISTRIBUTION_ID
  FROM po_distributions_all
 WHERE PO_DISTRIBUTION_ID IN
          (SELECT PO_DISTRIBUTION_ID
             FROM ap_invoice_distributions_all apid, ap_invoices_all api
            WHERE api.invoice_id = apid.invoice_id AND api.invoice_num = '19-NOV-13-083205100626214565USDE')

No comments:

Post a Comment