[Home] [Help]
View: 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 |