[Home] [Help]
VIEW: APPS.CSD_OE_LINE_STATUS_V
Source
View Text - Preformatted
SELECT header_id, line_id, to_char(line_number) || '.' || to_char(shipment_number) line_number, ordered_quantity, flow_status_code from oe_order_lines_all order by line_number, shipment_number
View Text - HTML Formatted
SELECT HEADER_ID
, LINE_ID
, TO_CHAR(LINE_NUMBER) || '.' || TO_CHAR(SHIPMENT_NUMBER) LINE_NUMBER
, ORDERED_QUANTITY
, FLOW_STATUS_CODE
FROM OE_ORDER_LINES_ALL ORDER BY LINE_NUMBER
, SHIPMENT_NUMBER