Oracle Apps Functional All About Oracle Apps functional & Technical FAQs, Tutorials

OE Header or OE Lines Table Column Links Back To A Purchase REQ for Back To Back Orders

Unable to link a purchase order and sale order?. There isn't a table column that links from the OE lines to the req lines.

The following sql query can be used to retrieve the data.

SELECT oh.Order_Number,
oh.Header_Id,
ol.Line_Id,
prh.Requisition_Header_Id,
prh.Segment1 req_Number,
prl.Requisition_Line_Id,
Pl.po_Line_Id,
poh.po_Header_Id,
poh.Segment1 po_Number
FROM oe_Order_Headers_All oh,
oe_Order_Lines_All ol,
po_Requisition_Headers_All prh,
po_Requisition_Lines_All prl,
po_Line_Locations_All pol,
po_Headers_All poh,
po_Lines_All Pl
WHERE ol.Header_Id = oh.Header_Id
AND prh.InterFace_Source_Line_Id = ol.Line_Id
AND prh.InterFace_Source_Code = 'CTO'
AND prh.Requisition_Header_Id = prl.Requisition_Header_Id
AND prl.Line_Location_Id = pol.Line_Location_Id
AND pol.po_Header_Id = poh.po_Header_Id
AND pol.po_Line_Id = Pl.po_Line_Id
AND ol.Line_Id = &sales_order_line_id;

Related Posts

• Order workflow statuses
• Order Management List of Shipping Statuses
• What is SUPPLY-TO-ORDER?
• Create a Customer
• Defining Release Rules
• API to partially Backorder a Pick Released Order Line
• Set Defaulting Shipping Document at the time of ship confirm based on the customers
• How To Progress ATO Lines Passed Supply Eligible?
• Can I update an imported Internal Order through order import?
• Is it possible to keep the legacy order number through order import?