[Home] [Help]
View: CSD_OE_LINE_STATUS_V
Product: | CSD - Depot Repair |
Description: | View for order management line status on status details tab |
Implementation/DBA Data: |
APPS.CSD_OE_LINE_STATUS_V
|
View Text
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
Columns
Name |
HEADER_ID |
LINE_ID |
LINE_NUMBER |
ORDERED_QUANTITY |
FLOW_STATUS_CODE |