1. Tables and Views for SCM
  2. CST_INTERNAL_TXN_TYPES_VL

CST_INTERNAL_TXN_TYPES_VL

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: VIEW

Columns

Name

BASE_TXN_TYPE_ID

BASE_TXN_TYPE_NAME

DESCRIPTION

BASE_TXN_SOURCE_TYPE_ID

BASE_TXN_ACTION_ID

USER_DEFINED_FLAG

CREATED_BY

CREATION_DATE

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

LAST_UPDATED_BY

Query

SQL_Statement

SELECT

CST_INTERNAL_TXN_TYPES_B.BASE_TXN_TYPE_ID BASE_TXN_TYPE_ID,

CST_INTERNAL_TXN_TYPES_TL.BASE_TXN_TYPE_NAME BASE_TXN_TYPE_NAME,

CST_INTERNAL_TXN_TYPES_TL.DESCRIPTION DESCRIPTION,

CST_INTERNAL_TXN_TYPES_B.BASE_TXN_SOURCE_TYPE_ID BASE_TXN_SOURCE_TYPE_ID,

CST_INTERNAL_TXN_TYPES_B.BASE_TXN_ACTION_ID BASE_TXN_ACTION_ID,

CST_INTERNAL_TXN_TYPES_B.USER_DEFINED_FLAG USER_DEFINED_FLAG,

CST_INTERNAL_TXN_TYPES_B.CREATED_BY CREATED_BY,

CST_INTERNAL_TXN_TYPES_B.CREATION_DATE CREATION_DATE,

CST_INTERNAL_TXN_TYPES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

CST_INTERNAL_TXN_TYPES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

CST_INTERNAL_TXN_TYPES_B.LAST_UPDATED_BY LAST_UPDATED_BY

FROM

CST_INTERNAL_TXN_TYPES_B,

CST_INTERNAL_TXN_TYPES_TL

WHERE

CST_INTERNAL_TXN_TYPES_B.BASE_TXN_TYPE_ID = CST_INTERNAL_TXN_TYPES_TL.BASE_TXN_TYPE_ID AND CST_INTERNAL_TXN_TYPES_TL.LANGUAGE = USERENV('LANG')

ORDER BY

CST_INTERNAL_TXN_TYPES_B.BASE_TXN_TYPE_ID