Query used to review the requisition, sales order, and receipt number,joins between various tables in Internal Sales order (ISO)

Query  used to review the requisition, sales order, and receipt number. It shows the joins between various tables in Internal Sales order (ISO)

SELECT porh.segment1,

           porl.line_num,

           pord.distribution_num,

           ooh.order_number

           sales_order,

           ool.line_number so_line_num,

           rsh.receipt_num,

           rcv.transaction_type

  FROM oe_order_headers_all ooh,

          po_requisition_headers_all porh,

          po_requisition_lines_all porl,

          po_req_distributions_all pord,

          oe_order_lines_all ool,

          po_system_parameters_all posp,

          rcv_shipment_headers rsh,

          rcv_transactions rcv

 WHERE ooh.order_source_id = posp.order_source_id

   AND porh.org_id = posp.org_id

   AND porh.requisition_header_id = ool.source_document_id

   AND porl.requisition_line_id = ool.source_document_line_id

   AND porh.requisition_header_id = porl.requisition_header_id

   AND porl.requisition_line_id = pord.requisition_line_id

   AND porl.requisition_line_id = rcv.requisition_line_id

   AND pord.distribution_id = rcv.req_distribution_id

   AND rcv.shipment_header_id = rsh.shipment_header_id