Order Management - EBS (MOSC)

MOSC Banner

Joining oe_order_lines_history and oe_order_lines_all

edited Jun 9, 2014 12:00PM in Order Management - EBS (MOSC) 2 commentsAnswered

I am new to Oracle and needing to do a report that will compare original order quantities to the existing shipments essentially to compare availability at shipment. This is what I have put together so far but i still have something missing as I still having some duplications. So the top three I don't need but the bottom 3 I do. Any suggestions to clean up the joins and include all from oe_order_lines_all and just be able to grab the original quantities from oe_order_lines_history?

select ont.oe_order_lines_all.Header_ID, ont.oe_order_lines_all.Line_Number, ont.oe_order_lines_all.Ordered_ITEM, ont.oe_order_lines_all.Ordered_QUantity, ont.oe_order_lines_history.ordered_quantity as Original_Quantity, ont.oe_order_lines_history.shipped_quantity

Tagged:

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