Product: | INV - Inventory |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.MTL_TRX_TYPES_VIEW |
SELECT TP.TRANSACTION_TYPE_NAME
, TP.TRANSACTION_TYPE_ID
, TP.TRANSACTION_SOURCE_TYPE_ID
, TP.TRANSACTION_ACTION_ID
, TP.DESCRIPTION
, SRC.DESCRIPTIVE_FLEX_CONTEXT_CODE
, SRC.TRANSACTION_SOURCE_TYPE_NAME
, TP.TYPE_CLASS
, LOCATION_REQUIRED_FLAG
FROM MTL_TRANSACTION_TYPES TP
, MTL_TXN_SOURCE_TYPES SRC
WHERE TP.TRANSACTION_SOURCE_TYPE_ID = SRC.TRANSACTION_SOURCE_TYPE_ID
AND NVL(TP.DISABLE_DATE
, SYSDATE+1) > SYSDATE
AND NVL(SRC.DISABLE_DATE
, SYSDATE+1) > SYSDATE