MTL_TRANSACTION_TYPES

Tag:
Table Number: 
IN.02.03
Table Owner: 
Inventory
Table Or View: 
Table
Important columns: 

TRANSACTION_TYPE_ID : Transaction type identifier
TRANSACTION_TYPE_NAME : Name of the transaction type
TRANSACTION_ACTION_ID : Transaction action identifer that is associated with this type
TRANSACTION_SOURCE_TYPE_ID : Transaction source type identifier that is associated with this transaction type
SHORTAGE_MSG_BACKGROUND_FLAG : Flag indicating background notification should be provided for this transaction
USER_DEFINED_FLAG : Set to 'Y' if this type is user-defined

Description: 

MTL_TRANSACTION_TYPES contains seeded transaction types and the user defined ones. USER_DEFINED_FLAG will distinguish the two. The table also stores the TRANSACTION_ACTION_ID and TRANSACTION_SOURCE_TYPE_ID
that is associated with each transaction type.

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
All Rights Reserved. Copyright 2008-11 OracleUG.com.