CMR_TRANSACTION_TYPES_VL
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: VIEW
Columns
Name |
---|
TRANSACTION_TYPE_ID TRANSACTION_TYPE_CODE PRODUCT_CODE TRANSACTION_GROUP_NAME TRANSACTION_TYPE_NAME TRANSACTION_TYPE_DESCRIPTION XCC_TRANSACTION_TYPE XCC_SOURCE_ACTION XCC_TRANSACTION_SUBTYPE_CODE CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN TXN_DATE_IN_LE_TZ_FLAG ACTIVE_FLAG |
Query
SQL_Statement |
---|
SELECT B.TRANSACTION_TYPE_ID, B.TRANSACTION_TYPE_CODE, B.PRODUCT_CODE, B.TRANSACTION_GROUP_NAME, TL.TRANSACTION_TYPE_NAME, TL.TRANSACTION_TYPE_DESCRIPTION, B.XCC_TRANSACTION_TYPE, B.XCC_SOURCE_ACTION, B.XCC_TRANSACTION_SUBTYPE_CODE, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.TXN_DATE_IN_LE_TZ_FLAG, B.ACTIVE_FLAG FROM CMR_TRANSACTION_TYPES_B B, CMR_TRANSACTION_TYPES_TL TL WHERE B.TRANSACTION_TYPE_ID = TL.TRANSACTION_TYPE_ID AND TL.LANGUAGE = USERENV('LANG') |