1. Tables and Views for SCM
  2. CMR_TRANSACTION_TYPES_VL

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')