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

TABLE: OKL.OKL_TRX_MSGS

Object Details
Object Name: OKL_TRX_MSGS
Object Type: TABLE
Owner: OKL
FND Design Data: TableOKL.OKL_TRX_MSGS
Subobject Name:
Status: VALID


DEFINITION
System messages related to a transaction. References AOL messages
EXAMPLE
MISCELLANEOUS


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKL_TRX_MSGS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnID
TMG_BCH_FK_I NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBCH_ID
TMG_FND_NEW_MESSAGES_FK_I NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTMG_LANGUAGE_CODE
ColumnTMG_MESSAGE_NAME
ColumnTMG_APPLICATION_ID
TMG_TRX_FK_I NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRX_ID
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes Primary key column
SEQUENCE_NUMBER NUMBER (5)
Sequence number
TRX_ID NUMBER

The transaction identifier of the source table.
TRX_SOURCE_TABLE VARCHAR2 (90)
Source table of the transaction
BCH_ID NUMBER

Foreign key to table OKL_BILLING_CHARGES_B
TMG_LANGUAGE_CODE VARCHAR2 (4)
The transaction message language code
TMG_MESSAGE_NAME VARCHAR2 (30)
The transaction message name
TMG_APPLICATION_ID NUMBER

The transaction message application identifier
MESSAGE_TEXT VARCHAR2 (2000)
The text that describes the transaction message
OBJECT_VERSION_NUMBER NUMBER (9) Yes Column used for locking records during updates
REQUEST_ID NUMBER (15)
Concurrent Manager column
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Manager column
PROGRAM_ID NUMBER (15)
Concurrent Manager column
PROGRAM_UPDATE_DATE DATE

Concurrent Manager column
CREATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
TMG_RUN NUMBER

To Store the Message Run
Query Text

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


SELECT ID
,      SEQUENCE_NUMBER
,      TRX_ID
,      TRX_SOURCE_TABLE
,      BCH_ID
,      TMG_LANGUAGE_CODE
,      TMG_MESSAGE_NAME
,      TMG_APPLICATION_ID
,      MESSAGE_TEXT
,      OBJECT_VERSION_NUMBER
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TMG_RUN
FROM OKL.OKL_TRX_MSGS;

Dependencies

[top of page]

OKL.OKL_TRX_MSGS does not reference any database object

OKL.OKL_TRX_MSGS is referenced by following:

SchemaAPPS
SynonymOKL_TRX_MSGS