DBA Data[Home] [Help]

VIEW: APPS.CST_XLA_INV_TXN_TYPES_REF_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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