VIEW: APPS.SO_LINES_CURRENT_DEMAND_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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