DBA Data[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