View: OE_MRP_OPEN_DEMANDS_V

Product:	ONT - Order Management
Description:	This vew is used by MRP for their Scheduler's Workbench.
Implementation/DBA Data:	APPS.OE_MRP_OPEN_DEMANDS_V

View Text

SELECT H.ORDER_NUMBER
, L.LINE_ID
, L.ORG_ID
, L.HEADER_ID
, L.LINE_NUMBER
, L.SHIPMENT_NUMBER
, L.OPTION_NUMBER
, L.ORDERED_ITEM
, DECODE(H.ORDER_DATE_TYPE_CODE
, 'ARRIVAL'
, NULL
, L.REQUEST_DATE)
, DECODE(H.ORDER_DATE_TYPE_CODE
, 'ARRIVAL'
, L.REQUEST_DATE
, NULL)
, L.PROMISE_DATE
, L.SCHEDULE_SHIP_DATE
, L.SCHEDULE_ARRIVAL_DATE
, L.LATEST_ACCEPTABLE_DATE
, L.ORDER_QUANTITY_UOM
, L.ORDERED_QUANTITY
, L.DELIVERY_LEAD_TIME
, L.SHIP_FROM_ORG_ID
, L.SHIP_TO_ORG_ID
, L.SOLD_TO_ORG_ID
, L.PROJECT_ID
, L.TASK_ID
, L.INVENTORY_ITEM_ID
, L.DEMAND_CLASS_CODE
, L.SHIPPING_METHOD_CODE
, L.LINK_TO_LINE_ID
, L.ITEM_TYPE_CODE
, L.ATO_LINE_ID
, L.COMPONENT_NUMBER
, L.SHIP_MODEL_COMPLETE_FLAG
, L.RE_SOURCE_FLAG
, L.TOP_MODEL_LINE_ID
, L.ARRIVAL_SET_ID
, L.SHIP_SET_ID
, SET2.SET_NAME
, SET1.SET_NAME
, L.FREIGHT_CARRIER_CODE
, L.FLOW_STATUS_CODE
, H.ORDER_DATE_TYPE_CODE
, L.OVERRIDE_ATP_DATE_CODE
, H.ORDER_TYPE_ID
, OT.NAME
, L.PLANNING_PRIORITY
, L.LINE_CATEGORY_CODE
, L.EARLIEST_ACCEPTABLE_DATE
FROM OE_ORDER_LINES_ALL L
, OE_ORDER_HEADERS_ALL H
, OE_SETS SET1
, OE_SETS SET2
, OE_TRANSACTION_TYPES_VL OT
WHERE L.HEADER_ID = H.HEADER_ID
AND L.SHIPPED_QUANTITY IS NULL
AND L.ORDERED_QUANTITY > 0
AND NVL(L.SOURCE_TYPE_CODE
, 'INTERNAL') <> 'EXTERNAL'
AND L.SHIP_SET_ID = SET1.SET_ID (+)
AND L.ARRIVAL_SET_ID = SET2.SET_ID (+)
AND H.ORDER_TYPE_ID = OT.TRANSACTION_TYPE_ID
AND H.ORG_ID = OT.ORG_ID
AND L.OPEN_FLAG = 'Y'

Columns