[Home] [Help]
View: CST_XLA_INV_TXN_TYPES_REF_V
View Text
SELECT TRANSACTION_TYPE_ID INV_TRANSACTION_TYPE_ID
, TRANSACTION_TYPE_NAME TRANSACTION_TYPE_NAME
, USER_DEFINED_FLAG TXN_TYPE_USER_DEFINED_FLAG
, DECODE(TYPE_CLASS
, 1
, 'Y'
, 'N' ) TYPE_CLASS
, DESCRIPTION INV_TXN_TYPE_DESCRIPTION
FROM MTL_TRANSACTION_TYPES
Columns
Name |
INV_TRANSACTION_TYPE_ID |
TRANSACTION_TYPE_NAME |
TXN_TYPE_USER_DEFINED_FLAG |
TYPE_CLASS |
INV_TXN_TYPE_DESCRIPTION |