[Home] [Help]
View: MTL_STATUS_CONTROL_V
View Text
SELECT MSTC.ROWID
, MTT.TRANSACTION_SOURCE_TYPE_ID
, MSTC.TRANSACTION_TYPE_ID
, MTT.DESCRIPTION
, MSTC.STATUS_ID
, NVL(MSTC.IS_ALLOWED
, 1)
FROM MTL_TRANSACTION_TYPES MTT
, MTL_STATUS_TRANSACTION_CONTROL MSTC
WHERE MTT.TRANSACTION_TYPE_ID = MSTC.TRANSACTION_TYPE_ID (+)
AND MTT.STATUS_CONTROL_FLAG = 1
Columns
Name |
ROW_ID |
TRANSACTION_SOURCE_TYPE_ID |
TRANSACTION_TYPE_ID |
TRANSACTION_DESCRIPTION |
STATUS_ID |
IS_ALLOWED |