View: CSD_LOGISTICS_LINE_STATUS_V

Product:	CSD - Depot Repair
Description:	View for logistics line on status details tab
Implementation/DBA Data:	APPS.CSD_LOGISTICS_LINE_STATUS_V

View Text

SELECT PRODUCT_TRANSACTION_ID
, ORDER_HEADER_ID
, ORDER_LINE_ID
, ORDER_NUMBER
, PRODUCT
, REPAIR_QUANTITY
, ACTION_TYPE
, (SELECT MEANING
FROM FND_LOOKUP_VALUES_VL
WHERE LOOKUP_TYPE = 'CSD_PROD_ACTION_TYPE'
AND LOOKUP_CODE = ACTION_TYPE) ACTION_TYPE_MEANING
, ACTION_CODE
, (SELECT MEANING
FROM FND_LOOKUP_VALUES_VL
WHERE LOOKUP_TYPE = 'CSD_PRODUCT_ACTION_CODE'
AND LOOKUP_CODE = ACTION_CODE) ACTION_CODE_MEANING
, PROD_TXN_STATUS
FROM CSD_PRODUCT_TXNS_V

Columns