View: OE_WIP_OPEN_DEMANDS_V

Product:	ONT - Order Management
Description:
Implementation/DBA Data:	APPS.OE_WIP_OPEN_DEMANDS_V

View Text

SELECT L.SHIP_FROM_ORG_ID
, L.HEADER_ID
, MTL.SALES_ORDER_ID
, L.LINE_ID
, L.LINE_NUMBER
, L.SCHEDULE_SHIP_DATE
, L.INVENTORY_ITEM_ID
, L.ITEM_TYPE_CODE
, L.DEMAND_CLASS_CODE
, L.ORDER_QUANTITY_UOM
, OE_LINE_UTIL.GET_OPEN_QUANTITY(L.HEADER_ID
, L.LINE_ID
, L.ORDERED_QUANTITY
, L.SHIPPED_QUANTITY)
FROM OE_ORDER_LINES_ALL L
, OE_ORDER_HEADERS_ALL H
, MTL_SALES_ORDERS MTL
, OE_TRANSACTION_TYPES_TL TL
WHERE TL.TRANSACTION_TYPE_ID = H.ORDER_TYPE_ID
AND TL.LANGUAGE = (SELECT LANGUAGE_CODE
FROM FND_LANGUAGES
WHERE INSTALLED_FLAG = 'B')
AND TL.NAME = MTL.SEGMENT2
AND MTL.SEGMENT1 = TO_CHAR(H.ORDER_NUMBER)
AND MTL.SEGMENT3 = FND_PROFILE.VALUE('ONT_SOURCE_CODE')
AND L.HEADER_ID = H.HEADER_ID
AND H.OPEN_FLAG = 'Y'
AND L.OPEN_FLAG = 'Y'
AND L.BOOKED_FLAG = 'Y'
AND L.SCHEDULE_STATUS_CODE = 'SCHEDULED'
AND L.SOURCE_TYPE_CODE = 'INTERNAL'
AND L.SHIPPED_QUANTITY IS NULL
AND ( L.ITEM_TYPE_CODE = 'STANDARD' OR L.ITEM_TYPE_CODE = 'CONFIG' OR (L.ITEM_TYPE_CODE = 'OPTION'
AND L.ATO_LINE_ID = L.LINE_ID))

Columns