joins between various tables in Internal Sales order (ISO)

Check this query may b it will help you.

 

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