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.OE_PROCESSING_MSGS_VL

Object Details

Object Name:	OE_PROCESSING_MSGS_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ONT.OE_PROCESSING_MSGS_VL
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

This view is a view built on oe_processing_msgs and oe_processing_msgs_tl for de-normalization to resolve multilingual issue and names for certain ids.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER		Yes	System Generated Id
REQUEST_ID	NUMBER			Concurrent request that last changed row
MESSAGE_TEXT	VARCHAR2	(2000)		This column holds the message
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
ORDER_SOURCE_ID	NUMBER			This holds the order source. Will be used for Order Import
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_TYPE_ID	NUMBER			This holds the Type of the source like COPY ORDER
SOURCE_DOCUMENT_ID	NUMBER			This holds the source header id.
SOURCE_DOCUMENT_LINE_ID	NUMBER			This holds the source Line id
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).
ORDER_NUMBER	NUMBER
ORDER_TYPE_ID	NUMBER
ORDER_TYPE	VARCHAR2	(30)
LINE_NUMBER	NUMBER
SHIPMENT_NUMBER	NUMBER
OPTION_NUMBER	NUMBER
ITEM	VARCHAR2	(2000)
PROGRAM_NAME	VARCHAR2	(240)
CONCURRENT_PROGRAM_ID	NUMBER
USER_NAME	VARCHAR2	(100)		Application username (what a user types in at the Oracle Applications sign-on screen)
PROCESS_ACTIVITY_NAME	VARCHAR2	(80)
CUSTOMER_NAME	VARCHAR2	(360)
CUSTOMER_NUMBER	VARCHAR2	(30)
ORGANIZATION_ID	NUMBER	(15)
ORG_ID	NUMBER
MESSAGE_STATUS_CODE	VARCHAR2	(30)		This column holds the status value of the the message.
ORDER_CREATION_DATE	DATE			This holds Order Header Creation Date

Query Text

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


SELECT TRANSACTION_ID
,      REQUEST_ID
,      MESSAGE_TEXT
,      ENTITY_CODE
,      ENTITY_ID
,      HEADER_ID
,      LINE_ID
,      ORDER_SOURCE_ID
,      ORIGINAL_SYS_DOCUMENT_REF
,      ORIGINAL_SYS_DOCUMENT_LINE_REF
,      SOURCE_DOCUMENT_TYPE_ID
,      SOURCE_DOCUMENT_ID
,      SOURCE_DOCUMENT_LINE_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
,      ORDER_NUMBER
,      ORDER_TYPE_ID
,      ORDER_TYPE
,      LINE_NUMBER
,      SHIPMENT_NUMBER
,      OPTION_NUMBER
,      ITEM
,      PROGRAM_NAME
,      CONCURRENT_PROGRAM_ID
,      USER_NAME
,      PROCESS_ACTIVITY_NAME
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      ORGANIZATION_ID
,      ORG_ID
,      MESSAGE_STATUS_CODE
,      ORDER_CREATION_DATE
FROM APPS.OE_PROCESSING_MSGS_VL;

Dependencies

[top of page]

APPS.OE_PROCESSING_MSGS_VL references the following:

APPS: FND_CONCURRENT_PROGRAMS_TL; FND_CONCURRENT_REQUESTS; FND_USER; OE_ORDER_HEADERS; OE_ORDER_LINES; OE_PROCESSING_MSGS; OE_PROCESSING_MSGS_TL; OE_SOLD_TO_ORGS_V; OE_TRANSACTION_TYPES_TL; WF_ACTIVITIES_TL; WF_PROCESS_ACTIVITIES

APPS.OE_PROCESSING_MSGS_VL is not referenced by any database object