Link between om and po in oracle apps

Link between om and po in oracle apps

In this post , We will discuss about the Link between om and po in oracle apps. Link between OM and PO comes in Drop Ship Orders. When we do create the Drop Ship Orders then System do create link between the OM and PO in oracle apps. We do create the Drop Ship orders in oracle apps when we don't ship the Sales order items directly from our company but we want our suppliers to ship that sales order items directly to our customer so in these type of business scenarios system create link between om and po in oracle apps. I will also share the DB Table link/Join between om and po in oracle apps.   

Business Link between om and po in oracle apps

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. 

DB Link between om and po in oracle apps

Table Join between om and po in oracle apps

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) po_req_distributions_all 

PO_REQUISITION_LINES_ALL(REQUISITION_LINE_ID) Joins Between PO_REQ_DISTRIBUTIONS_ALL(REQUISITION_LINE_ID)

PO_REQ_DISTRIBUTIONS_ALL(DISTRIBUTION_ID) Join Between PO_DISTRIBUTIONS_ALL(REQ_DISTRIBUTION_ID)

PO_DISTRIBUTIONS_ALL(PO_HEADER_ID) Join Between PO_HEADERS_ALL (PO_HEADER_ID)

Detail SQL query Using Link between om and po in oracle apps

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 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