DBA Data[Home] [Help] [Dependency Information]


TABLE: INV.MTL_TXN_SOURCE_TYPES

Object Details
Object Name: MTL_TXN_SOURCE_TYPES
Object Type: TABLE
Owner: INV
FND Design Data: TableINV.MTL_TXN_SOURCE_TYPES
Subobject Name:
Status: VALID


MTL_TXN_SOURCE_TYPES contains information about valid transaction
source type in the system. There are two kinds of transaction source
types. System transaction source types are those seeded when the
system is installed, bear source type identifiers of 1 through 13
and use system validation. User defined transaction source types have
have identifiers higher than 100, and may have validation set up
through the use of the descriptive flex context in the 'Transaction
Source' descriptive flexfield.
.
Transaction source types are used in defining user transaction types,
which would in turn be used in different inventory transactions.
.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_TXN_SOURCE_TYPES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnTRANSACTION_SOURCE_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_SOURCE_TYPE_ID NUMBER
Yes Transaction source type identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
TRANSACTION_SOURCE_TYPE_NAME VARCHAR2 (30) Yes Transaction source type name
DESCRIPTION VARCHAR2 (240)
Transaction source type description
DISABLE_DATE DATE

Disable date for the transaction source type
USER_DEFINED_FLAG VARCHAR2 (1) Yes Flag to indicate whether source type is user-defined or predefined by system
VALIDATED_FLAG VARCHAR2 (1) Yes Flag to indicate whether source type is validated by system/descriptive flex context
DESCRIPTIVE_FLEX_CONTEXT_CODE VARCHAR2 (30)
Descriptive flex context defined for the 'Transaction Source' descriptive flex for linkage to a value set
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
TRANSACTION_SOURCE_CATEGORY VARCHAR2 (30)
Column defined for the purpose of setting up the 'Transaction Source' descriptive flexfield (contains no data)
TRANSACTION_SOURCE VARCHAR2 (30)
Column defined for the purpose of setting up the 'Transaction Source' descriptive flexfield (contains no data)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TRANSACTION_SOURCE_TYPE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      TRANSACTION_SOURCE_TYPE_NAME
,      DESCRIPTION
,      DISABLE_DATE
,      USER_DEFINED_FLAG
,      VALIDATED_FLAG
,      DESCRIPTIVE_FLEX_CONTEXT_CODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      TRANSACTION_SOURCE_CATEGORY
,      TRANSACTION_SOURCE
FROM INV.MTL_TXN_SOURCE_TYPES;

Dependencies

[top of page]

INV.MTL_TXN_SOURCE_TYPES does not reference any database object

INV.MTL_TXN_SOURCE_TYPES is referenced by following:

SchemaAPPS
SynonymMTL_TXN_SOURCE_TYPES