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_EM_INFORMATION_ALL

Object Details

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

This table maintains tracking information for Order Import and Electronic Messaging (EDI & XML)

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OE_EM_INFORMATION_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	EM_TRANSACTION_TYPE_CODE DOCUMENT_ID
OE_EM_INFORMATION_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORDER_SOURCE_ID ORIG_SYS_DOCUMENT_REF SOLD_TO_ORG_ID
OE_EM_INFORMATION_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOLD_TO_ORG_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ORDER_SOURCE_ID	NUMBER			Order Source Identifier
ORIG_SYS_DOCUMENT_REF	VARCHAR2	(50)		Original document reference for the order in external system
SOLD_TO_ORG_ID	NUMBER			Sold to customer
EM_TRANSACTION_TYPE_CODE	VARCHAR2	(30)		Electronic Message Transaction Type Code
DOCUMENT_ID	NUMBER			Unique id for each inbound/outbound electronic messaging transaction
PARENT_DOCUMENT_ID	NUMBER			Links outbound electronic messages with any corresponding inbound response
ORDER_NUMBER	NUMBER			User-visible number of the order
ORDER_TYPE_ID	NUMBER			Order Transaction Type Identifier
CHANGE_SEQUENCE	VARCHAR2	(50)		It is sequence number in which changes will be applied. It will make sure that later changes are not over-written by previous order change
ORG_ID	NUMBER			Operating Unit which performed this transaction
HEADER_ID	NUMBER			Order Header Identifier
EM_CONC_REQUEST_ID	NUMBER			Concurrent request id of electronic message processing
DOCUMENT_STATUS	VARCHAR2	(240)		Status code for the electronic message processing
DOCUMENT_DISPOSITION	VARCHAR2	(20)		Result of the buyer/seller message exchange
MESSAGE_TEXT	VARCHAR2	(2000)		User-visible message regarding the electronic message processing
ITEM_TYPE	VARCHAR2	(8)		Internal name for the Item Type
ITEM_KEY	VARCHAR2	(240)		Holds the primary key generated for the item type
CREATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER			Application of concurrent program that last updated row
PROGRAM_ID	NUMBER			Concurrent program that last updated row
PROGRAM_UPDATE_DATE	DATE			Last date changed by concurrent program
REQUEST_ID	NUMBER			Concurrent request that last changed row
LAST_UPDATE_ITEMKEY	VARCHAR2	(240)		Item key of the last workflow process to update row

Query Text

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


SELECT ORDER_SOURCE_ID
,      ORIG_SYS_DOCUMENT_REF
,      SOLD_TO_ORG_ID
,      EM_TRANSACTION_TYPE_CODE
,      DOCUMENT_ID
,      PARENT_DOCUMENT_ID
,      ORDER_NUMBER
,      ORDER_TYPE_ID
,      CHANGE_SEQUENCE
,      ORG_ID
,      HEADER_ID
,      EM_CONC_REQUEST_ID
,      DOCUMENT_STATUS
,      DOCUMENT_DISPOSITION
,      MESSAGE_TEXT
,      ITEM_TYPE
,      ITEM_KEY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      LAST_UPDATE_ITEMKEY
FROM ONT.OE_EM_INFORMATION_ALL;

Dependencies

[top of page]

ONT.OE_EM_INFORMATION_ALL does not reference any database object

ONT.OE_EM_INFORMATION_ALL is referenced by following:

ONT: OE_EM_INFORMATION_ALL#