Purchase Order Receipt details query in Oracle apps

Purchase Order Receipt details query in Oracle apps
Query to find PO receipts in Oracle EBS R12
po receipts table in oracle apps r12
po receipt oracle apps
po receiving tables in oracle apps r12

SELECT pha.segment1                            "PO#",
       pla.line_num || '.' || pll.shipment_num "Line-Ship#",
       pod.distribution_num                    "Distribution#",
       pll.quantity                            "PO Line_qty_ordered",
       pod.quantity_ordered                    "Distribution_qty_ordered",
       plt.line_type                           "Line_Type",
       pv.vendor_name                          "Vendor Name",
       msi.segment1                            "Item#",
       rsh.receipt_num,
       rt.transaction_id,
       rt.transaction_type,
       rt.quantity                             "RCV_quantity",
       apid.INVOICE_ID,
       apid.QUANTITY_INVOICED,
       pod.po_distribution_id,
       rsh.SHIPMENT_HEADER_ID,
       RSL.SHIPMENT_LINE_ID,
       PLL.LINE_LOCATION_ID,
       pla.PO_HEADER_ID,
       pla.PO_LINE_ID
  FROM rcv_transactions                  rt,
       rcv_shipment_headers              rsh,
       rcv_shipment_lines                rsl,
       apps.po_distributions_all         pod,
       apps.gl_code_combinations         gcc1,
       apps.gl_code_combinations         gcc2,
       apps.po_line_locations_all        pll,
       apps.po_lines_all                 pla,
       apps.po_line_types_tl             plt,
       apps.po_releases_all              pra,
       apps.po_headers_all               pha,
       apps.po_vendors                   pv,
       apps.mtl_system_items_b           msi,
       apps.ap_invoice_distributions_all apid
 WHERE     rsl.shipment_line_id = rt.shipment_line_id
       AND rsh.shipment_header_id = rt.shipment_header_id
       AND rsh.shipment_header_id = rsl.shipment_header_id
       --AND apid.rcv_transaction_id(+) = rt.transaction_id
       AND apid.po_distribution_id(+) = pod.po_distribution_id
       AND NVL (apid.REVERSAL_FLAG, 'N') = 'Y'
       AND pv.vendor_id = pha.vendor_id
       AND rt.po_header_id = pha.po_header_id
       AND rt.po_line_id = pla.po_line_id
       AND rt.po_line_location_id = pll.line_location_id
       AND rt.po_distribution_id = pod.po_distribution_id
       AND gcc1.code_combination_id = pod.code_combination_id
       AND gcc2.code_combination_id = pod.accrual_account_id
       AND pod.line_location_id = pll.line_location_id
       AND pra.po_release_id(+) = pll.po_release_id
       AND plt.line_type_id = pla.line_type_id
       AND msi.inventory_item_id = pla.item_id
       AND msi.organization_id = rt.organization_id
       AND pll.po_line_id = pla.po_line_id
       AND pla.po_header_id = pha.po_header_id
       AND rt.source_document_code = 'PO'
       AND rt.transaction_type IN ('RECEIVE', 'MATCH')
       AND pha.type_lookup_code IN ('BLANKET', 'STANDARD', 'PLANNED')
       AND pll.shipment_type IN ('BLANKET', 'STANDARD', 'SCHEDULED')
       AND pha.segment1 = '1234'  --Enter PO number here

Related posts:

• Supervisor Hierarchy and Approval Limits in Oracle EBS R12
• Purchase Order Receipt details query in Oracle apps
• Oracle apps query to find approval limits
• Query to find all APIs of Oracle Apps modules
• Purchase Requisition Vertex debug xml query in Oracle EBS
• Purchase Order Vertex debug xml query in Oracle EBS
• Query to find serial number material transactions details
• Query to find period status for Inventory General Ledger Purchasing Payables Receivables Fixed Assets
• Query to find Purchase Order and Invoice Details
• Query to find AP Invoices matched with receipts
• Query to find Supplier Bank Details
• Query to find Credit Memos on an AP invoice
• Query to find the AP invoices that are applied to multiple Purchase Orders

Upload your own post and refer it anywhere anytime: