VIEW: APPS.OE_WIP_OPEN_DEMANDS_V

Source

View Text - Preformatted

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 IN( 'OPTION','INCLUDED') AND L.ato_line_id = L.line_id))

View Text - HTML Formatted

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 IN( 'OPTION'
, 'INCLUDED')
AND L.ATO_LINE_ID = L.LINE_ID))