Product: | OE - Order Entry |
---|---|
Description: | |
Implementation/DBA Data: | APPS.SO_LINES_CURRENT_DEMAND_V |
SELECT H.ORDER_NUMBER
, H.ORDER_TYPE_ID
, H.CUSTOMER_ID
, H.ORIGINAL_SYSTEM_REFERENCE
, SOT.NAME ORDER_TYPE_NAME
, L.LINE_ID
, OE_QUERY.LINE_NUMBER( L.LINE_ID
, L.SHIPMENT_SCHEDULE_LINE_ID
, L.PARENT_LINE_ID
, L.LINE_NUMBER) LINE_NUMBER
, OE_QUERY.SHIPMENT_NUMBER(L.LINE_ID
, L.PARENT_LINE_ID
, L.SHIPMENT_SCHEDULE_LINE_ID
, L.LINE_NUMBER) SHIPMENT_NUMBER
, DECODE(L.OPTION_FLAG
, 'Y'
, L.LINE_NUMBER
, NULL) OPTION_NUMBER
, L.ORIGINAL_SYSTEM_LINE_REFERENCE
, L.HEADER_ID
, L.DEMAND_STREAM_ID
, L.DATE_REQUESTED_CURRENT
, L.PARENT_LINE_ID
, L.ATO_LINE_ID
, L.INVENTORY_ITEM_ID
, L.ITEM_TYPE_CODE
, NVL(L.OPEN_FLAG
, 'N') OPEN_FLAG
, NVL(L.ATO_FLAG
, 'N') ATO_FLAG
, L.S2 PICK_RELEASE_STATUS
, L.S4 SHIP_CONFIRM_STATUS
, L.S27 MFG_RELEASE_STATUS
, L.S25 SERVICE_INTERFACE_STATUS
, L.ORDERED_QUANTITY
, NVL(L.CANCELLED_QUANTITY
, 0) CANCELLED_QUANTITY
, NVL(L.SHIPPED_QUANTITY
, 0) SHIPPED_QUANTITY
, NVL(L.INVOICED_QUANTITY
, 0) INVOICED_QUANTITY
, OE_QUERY.RELEASED_QUANTITY(L.LINE_ID) PICK_RELEASED_QUANTITY
, OE_QUERY.OPEN_BACKORDERED_QUANTITY(L.LINE_ID) OPEN_BACKORDERED_QUANTITY
FROM SO_ORDER_TYPES SOT
, SO_HEADERS H
, SO_LINES L
WHERE SOT.ORDER_TYPE_ID = H.ORDER_TYPE_ID
AND H.HEADER_ID = L.HEADER_ID