1. Tables and Views for SCM
  2. CST_ALL_TXN_TYPES_V

CST_ALL_TXN_TYPES_V

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

START_DATE

END_DATE

USER_DEFINED_FLAG

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.START_DATE,

CST_INTERNAL_TXN_TYPES_B.END_DATE,

CST_INTERNAL_TXN_TYPES_B.USER_DEFINED_FLAG USER_DEFINED_FLAG

FROM

CST_INTERNAL_TXN_TYPES_B ,

CST_INTERNAL_TXN_TYPES_TL,

CST_TXN_SOURCE_ACTIONS

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

CST_INTERNAL_TXN_TYPES_B.BASE_TXN_SOURCE_TYPE_ID = CST_TXN_SOURCE_ACTIONS.BASE_TXN_SOURCE_TYPE_ID AND

CST_INTERNAL_TXN_TYPES_B.BASE_TXN_ACTION_ID = CST_TXN_SOURCE_ACTIONS.BASE_TXN_ACTION_ID AND

CST_TXN_SOURCE_ACTIONS.BASE_TXN_SOURCE_TYPE_ID = 0

UNION

SELECT

INV_TRANSACTION_TYPES.TRANSACTION_TYPE_ID BASE_TXN_TYPE_ID,

INV_TRANSACTION_TYPES.TRANSACTION_TYPE_NAME BASE_TXN_TYPE_NAME,

INV_TRANSACTION_TYPES.DESCRIPTION DESCRIPTION,

CASE WHEN INV_TRANSACTION_TYPES.TRANSACTION_SOURCE_TYPE_ID>100 THEN 13

ELSE INV_TRANSACTION_TYPES.TRANSACTION_SOURCE_TYPE_ID

END BASE_TXN_SOURCE_TYPE_ID,

TO_NUMBER(INV_TRANSACTION_TYPES.TRANSACTION_ACTION_ID) BASE_TXN_ACTION_ID,

INV_TRANSACTION_TYPES.START_DATE START_DATE,

INV_TRANSACTION_TYPES.END_DATE END_DATE,

INV_TRANSACTION_TYPES.USER_DEFINED_FLAG USER_DEFINED_FLAG

FROM

INV_TRANSACTION_TYPES,

CST_TXN_SOURCE_ACTIONS

WHERE

CST_TXN_SOURCE_ACTIONS.BASE_TXN_SOURCE_TYPE_ID = CASE WHEN

INV_TRANSACTION_TYPES.TRANSACTION_SOURCE_TYPE_ID>100 THEN 13 ELSE

INV_TRANSACTION_TYPES.TRANSACTION_SOURCE_TYPE_ID END AND

INV_TRANSACTION_TYPES.TRANSACTION_ACTION_ID = CST_TXN_SOURCE_ACTIONS.BASE_TXN_ACTION_ID AND

CST_TXN_SOURCE_ACTIONS.BASE_TXN_SOURCE_TYPE_ID <> 0