VIEW: APPS.OE_MRP_OPEN_DEMANDS_V

Source

View Text - Preformatted

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' AND NVL(L.VISIBLE_DEMAND_FLAG,'N')='Y'

View Text - HTML Formatted

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'
AND NVL(L.VISIBLE_DEMAND_FLAG
, 'N')='Y'