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

Query to find program will transfer the details from OM to PO requisitions interface

SELECT interface_source_code,

           interface_source_line_id,

           quantity,

           destination_type_code,

           transaction_id,

           process_flag,

           request_id,

           TRUNC (creation_date)

  FROM po_requisitions_interface_all

 WHERE interface_source_code = ‘ORDER ENTRY’

   AND interface_source_line_id IN (SELECT drop_ship_source_id

                                      FROM oe_drop_ship_sources

                                     WHERE header_id = &order_hdr_id

                                       AND line_id = &order_line_id);

Join between OM, WSH, AR Tables

SELECT ooh.order_number

              ,ool.line_id

              ,ool.ordered_quantity

              ,ool.shipped_quantity

              ,ool.invoiced_quantity

              ,wdd.delivery_detail_id

              ,wnd.delivery_id

              ,rctl.interface_line_attribute1

              ,rctl.interface_line_attribute3

              ,rctl.interface_line_attribute6

              ,rct.org_id

              ,rct.creation_date

              ,trx_number

              ,rctl.quantity_ordered

              ,rct.interface_header_context

  FROM oe_order_headers_all ooh

             ,oe_order_lines_all ool

             ,wsh_delivery_details wdd

             ,wsh_new_deliveries wnd

             ,wsh_delivery_assignments wda

             ,ra_customer_trx_all rct

             ,ra_customer_trx_lines_all rctl

 WHERE ooh.header_Id=ool.header_id

      AND wdd.source_header_id=ooh.header_id

      AND wdd.delivery_detail_Id=wda.delivery_detail_id

      AND wda.delivery_id=wnd.delivery_id

      AND rctl.interface_line_attribute1=to_char(ooh.order_number)

      AND rctl.interface_line_attribute6=to_char(ool.line_id)

      AND rctl.interface_line_attribute3=to_char(wnd.delivery_id)

      AND rctl.customer_trx_id=rct.customer_trx_id

      AND rct.interface_header_context=’ORDER ENTRY’