FND Design Data [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: ViewAPPS.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