Procurement - EBS (MOSC)

MOSC Banner

Is there a unique join between po_line_locations_all and mrp_item_purchase_orders?

edited Sep 22, 2011 1:48AM in Procurement - EBS (MOSC) 3 commentsAnswered
I read an Oracle Support document, Doc 297568.1 (How To Establish A Link Between MRP_RECOMMENDATIONS and PO_LINE_LOCATIONS_ALL), that is supposed to address this requirement but the script in the document does not give the correct result.

The script uses only po_line_id to link the MRP PO (mrp_item_purchase_orders) table to the PO shipments (po_line_locations_all) table but MRP recommendations are per PO shipment, not per PO line so if you need the mrp recommendation alongside the PO shipment details, you will not be able to do it correctly using this script. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center