eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.OKL_TRX_MSGS_V

Object Details

Object Name:	OKL_TRX_MSGS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_TRX_MSGS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

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

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Auto-generated by Headstart Utilities
ID	NUMBER		Yes	Primary key column
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Column used for locking records during updates
BCH_ID	NUMBER			Foreign key to table OKL_BILLING_CHARGES_B
TMG_MESSAGE_NAME	VARCHAR2	(30)		The transaction message name
TMG_APPLICATION_ID	NUMBER			The transaction message application identifier
TMG_LANGUAGE_CODE	VARCHAR2	(4)		The transaction message language code
MESSAGE_TEXT	VARCHAR2	(2000)		The text that describes the transaction message
TRX_ID	NUMBER			The transaction identifier of the source table.
TRX_SOURCE_TABLE	VARCHAR2	(90)		Source table of the transaction
SEQUENCE_NUMBER	NUMBER	(5)		Sequence number
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 Message Run

Query Text

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


SELECT ROW_ID
,      ID
,      OBJECT_VERSION_NUMBER
,      BCH_ID
,      TMG_MESSAGE_NAME
,      TMG_APPLICATION_ID
,      TMG_LANGUAGE_CODE
,      MESSAGE_TEXT
,      TRX_ID
,      TRX_SOURCE_TABLE
,      SEQUENCE_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 APPS.OKL_TRX_MSGS_V;

Dependencies

[top of page]

APPS.OKL_TRX_MSGS_V references the following:

APPS: OKL_TRX_MSGS

APPS.OKL_TRX_MSGS_V is referenced by following:

APPS: OKL_TMG_PVT - show dependent code; OKL_TMG_PVT - show dependent code