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]

TABLE: ONT.OE_PROCESSING_MSGS

Object Details

Object Name:	OE_PROCESSING_MSGS
Object Type:	TABLE
Owner:	ONT
FND Design Data:	ONT.OE_PROCESSING_MSGS
Subobject Name:
Status:	VALID

This table stores the context information of the processing messages that will be generated during Order Entry concurrent program execution or UI process.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OE_PROCESSING_MSGS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID
OE_PROCESSING_MSGS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORDER_SOURCE_ID ORIGINAL_SYS_DOCUMENT_REF
OE_PROCESSING_MSGS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID
OE_PROCESSING_MSGS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	HEADER_ID MESSAGE_STATUS_CODE
OE_PROCESSING_MSGS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENTITY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER		Yes	System Generated Id
REQUEST_ID	NUMBER			Concurrent request that last changed row
ENTITY_CODE	VARCHAR2	(30)		Name of the Entity
ENTITY_ID	NUMBER			Entity Id
HEADER_ID	NUMBER			This holds the header id against which the message is logged
LINE_ID	NUMBER			This holds the Line id against which the message is logged
ORIGINAL_SYS_DOCUMENT_REF	VARCHAR2	(50)		This holds the order header source. Will be used for Order Import
ORIGINAL_SYS_DOCUMENT_LINE_REF	VARCHAR2	(50)		This holds the order Line source. Will be used for Order Import
SOURCE_DOCUMENT_ID	NUMBER			This holds the source header id.
SOURCE_DOCUMENT_LINE_ID	NUMBER			This holds the source Line id
ORDER_SOURCE_ID	NUMBER			This holds the order source. Will be used for Order Import
SOURCE_DOCUMENT_TYPE_ID	NUMBER			This holds the Type of the source like COPY ORDER
ATTRIBUTE_CODE	VARCHAR2	(30)		This will store Attribute name/code against which the message is generated.
PROGRAM_UPDATE_DATE	DATE			Last date changed by concurrent program
PROGRAM_APPLICATION_ID	NUMBER			This will store concurrent program Application id against which the message is generated
PROGRAM_ID	NUMBER			This will store concurrent program id against which the message is generated.
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CONSTRAINT_ID	NUMBER			This will store workflow constraint id against which the message is generated.
PROCESS_ACTIVITY	NUMBER			This will store workflow process information against which the message is generated.
NOTIFICATION_FLAG	VARCHAR2	(1)		This flag indicates whether the notification has been sent or not.
ENTITY_REF	VARCHAR2	(50)		Entity Reference
CHANGE_SEQUENCE	VARCHAR2	(50)		Change sequence
ORIG_SYS_SHIPMENT_REF	VARCHAR2	(50)		Source shipment number
TYPE	VARCHAR2	(30)		This will store the severity of the message.
MESSAGE_SOURCE_CODE	VARCHAR2	(30)		This indicates the source of the message(UI/ Con current / Workflow).
LANGUAGE	VARCHAR2	(4)		Language in which message text is stored.
MESSAGE_TEXT	VARCHAR2	(2000)		Test of the processing message.
SOLD_TO_ORG_ID	NUMBER			Customer Id referred by the message
MESSAGE_STATUS_CODE	VARCHAR2	(30)		This column holds the status value of the the message
ORG_ID	NUMBER			Operating Unit
INST_ID	NUMBER			used in RAC INSTANCE AFFINITY for context setting

Query Text

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


SELECT TRANSACTION_ID
,      REQUEST_ID
,      ENTITY_CODE
,      ENTITY_ID
,      HEADER_ID
,      LINE_ID
,      ORIGINAL_SYS_DOCUMENT_REF
,      ORIGINAL_SYS_DOCUMENT_LINE_REF
,      SOURCE_DOCUMENT_ID
,      SOURCE_DOCUMENT_LINE_ID
,      ORDER_SOURCE_ID
,      SOURCE_DOCUMENT_TYPE_ID
,      ATTRIBUTE_CODE
,      PROGRAM_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      CONSTRAINT_ID
,      PROCESS_ACTIVITY
,      NOTIFICATION_FLAG
,      ENTITY_REF
,      CHANGE_SEQUENCE
,      ORIG_SYS_SHIPMENT_REF
,      TYPE
,      MESSAGE_SOURCE_CODE
,      LANGUAGE
,      MESSAGE_TEXT
,      SOLD_TO_ORG_ID
,      MESSAGE_STATUS_CODE
,      ORG_ID
,      INST_ID
FROM ONT.OE_PROCESSING_MSGS;

Dependencies

[top of page]

ONT.OE_PROCESSING_MSGS does not reference any database object

ONT.OE_PROCESSING_MSGS is referenced by following:

ONT: OE_PROCESSING_MSGS#