Link between sales order and purchase requisition in oracle

Link between sales order and purchase requisition in oracle

In this post , we will discuss about the Link between sales order and purchase requisition in oracle apps. I will share the Data Base Table Link/join between the Sales order and purchase requisition in oracle. As per the Business Flow , the link between sales order and purchase requisition exists in  Drop Ship Orders. When we do create the Drop Ship Orders then it creates Link between sales order and purchase requisition. Drop Ship sales orders is the process in which customers place the order for Company but company did not ship that order from itself , instead company told its supplier to directly ship the items to the customers.So this is the Business link between sales order and purchase requisition in oracle.

Business Flow Link between sales order and purchase requisition in oracle

Drop Ship sales orders is the process in which customers place the order for Company but company did not ship that order from itself , instead company told its supplier to directly ship the items to the customers.So this is the Business link between sales order and purchase requisition in oracle. 

SQL Link Between sales order and purchase requisition in oracle

Table Join between sales order and purchase requisition in oracle

OE_ORDER_LINES_ALL(SOURCE_DOCUMENT_LINE_ID) Joins Between PO_REQUISITION_LINES_ALL(REQUISITION_LINE_ID)

OE_ORDER_LINES_ALL(ORIG_SYS_DOCUMENT_REF) Joins Between PO_REQUISITION_HEADERS_ALL(SEGMENT1)

SQL Link between sales order and purchase requisition in oracle

 SELECT OOH.ORDER_NUMBER SO,

  PRH.SEGMENT1 REQ,

  ph.segment1 "PO Num"

FROM OE_ORDER_HEADERS_ALL OOH,

  PO_REQUISITION_HEADERS_ALL PRH,

  PO_REQUISITION_LINES_ALL PRL,

  po_req_distributions_all rd,

  po_headers_all ph,

po_distributions_all d

WHERE 1 = 1

AND PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID

AND PRH.SEGMENT1              = OOH.ORIG_SYS_DOCUMENT_REF

AND PRH.REQUISITION_HEADER_ID = OOH.SOURCE_DOCUMENT_ID

AND ORDER_NUMBER              = :P_Sales_Order_Number

AND rd.requisition_line_id = PRL.requisition_line_id

AND d.req_distribution_id = rd.distribution_id

and ph.po_header_id = d.po_header_id