1. Tables and Views for SCM
  2. CST_TRANSACTION_TYPES_V

CST_TRANSACTION_TYPES_V

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: VIEW

Columns

Name

TRANSACTION_TYPE_ID

USER_DEFINED_FLAG

BASE_TXN_TYPE_NAME

TRANSACTION_GROUP_ID

BASE_TXN_TYPE_ID

BASE_TXN_ACTION_ID

BASE_TXN_SOURCE_TYPE_ID

Query

SQL_Statement

SELECT DISTINCT

csttransactiongroups.transaction_type_id,

cstalltxntypes.user_defined_flag,

cstalltxntypes.base_txn_type_name,

csttransactiongroups.transaction_group_id,

cstalltxntypes.base_txn_type_id,

cstalltxntypes.base_txn_action_id,

cstalltxntypes.base_txn_source_type_id

FROM

cst_transaction_groups csttransactiongroups,

cst_all_txn_types_v cstalltxntypes

WHERE

csttransactiongroups.base_txn_source_type_id = cstalltxntypes.base_txn_source_type_id

AND csttransactiongroups.base_txn_action_id = cstalltxntypes.base_txn_action_id

AND ( csttransactiongroups.transaction_type_id = cstalltxntypes.base_txn_type_id

OR cstalltxntypes.user_defined_flag = 'Y' )

AND csttransactiongroups.transaction_group_id NOT IN ( 1, 4, 6, 7, 10 )

AND ( csttransactiongroups.transaction_group_id, csttransactiongroups.transaction_type_id ) NOT IN ( ( 2, 70 ), ( 5, 71 ),

( 5, 39 ), ( 9, 18 ), ( 9,

20 ) )

AND csttransactiongroups.cost_transaction_type = 'RECEIPT'

ORDER BY

base_txn_type_name