ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 9ED5174918F5578CE053B46B635817C7Y SELECT OEH.ORDER_NUMBER , OEL.LINE_NUMBER LINE, OEL.ORDERED_ITEM , MSI.PLANNER_CODE PLANNER, OEL.SCHEDULE_SHIP_DATE SSD_NOW, lag(AUD.schedule_ship_date, 1) OVER(ORDER BY AUD.line_id) HISTORICAL_SHIP_DATE, lag(AUD.promise_date, 1) OVER(ORDER BY AUD.line_id) HISTORICAL_PROMISE_DATE FROM OE_ORDER_HEADERS_ALL OEH, OE_ORDER_LINES_ALL_AC1 AUD, -- Audit View OE_ORDER_LINES_ALL OEL, MTL_SYSTEM_ITEMS_B MSI WHERE 1=1 AND AUD.LINE_ID = OEL.LINE_ID AND OEL.HEADER_ID = OEH.HEADER_ID AND MSI.SEGMENT1=OEL.ORDERED_ITEM AND MSI.ORGANIZATION_ID = OEL.SHIP_FROM_ORG_ID AND OEL.schedule_arrival_date IS NOT NULL -- AND OEL.LINE_NUMBER = 2 --AND ORDER_NUMBER='69362' Ready for test US ONT - Planning Reliability Metric Legging metric for trend / plan relaibility analysis on schedule ship date and promise date Use this to pinpoint trends in the late shipping of a sales order versus reality 1=1 1 10 1=1 planner_code=:planner_code LOV Oracle MSD_X_PLANNER_CODE Y select planner_code id, planner_code value, null description from msc_x_planners_v where plan_id=-1 order by value,description J. Smith US Planner Code 2 20 1=1 order_number=:order_number LOV Oracle ONT_ORDER_NUMBER Y select order_number id, order_number value, null description from oe_order_headers where rowid=(select rowid from oe_order_headers h where oe_order_headers.order_number=h.order_number and rownum=1) order by value,description 69362 US Sales Order