[Home] [Help]
View: 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
Name |
PRODUCT_TRANSACTION_ID |
ORDER_HEADER_ID |
ORDER_LINE_ID |
ORDER_NUMBER |
PRODUCT |
REPAIR_QUANTITY |
ACTION_TYPE |
ACTION_TYPE_MEANING |
ACTION_CODE |
ACTION_CODE_MEANING |
PROD_TXN_STATUS |