FND Design Data [Home] [Help]

View: MTL_TXN_SRC_FOR_TRAN_TYPE_VIEW

Product: INV - Inventory
Description: - Retrofitted
Implementation/DBA Data: ViewAPPS.MTL_TXN_SRC_FOR_TRAN_TYPE_VIEW
View Text

SELECT TXN.TRANSACTION_SOURCE_TYPE_ID
, TXN.TRANSACTION_SOURCE_TYPE_NAME
, TXN.DESCRIPTION
, TXN.USER_DEFINED_FLAG
FROM MTL_TXN_SOURCE_TYPES TXN
WHERE NVL(TXN.DISABLE_DATE
, SYSDATE+1) > SYSDATE
AND (TXN.TRANSACTION_SOURCE_TYPE_ID IN (3
, 4
, 5
, 6
, 13) OR TXN.USER_DEFINED_FLAG = 'Y')

Columns

Name
TRANSACTION_SOURCE_TYPE_ID
TRANSACTION_SOURCE_TYPE_NAME
DESCRIPTION
USER_DEFINED_FLAG