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: EDR.EDR_PROCESS_ERECORDS_T

Object Details

Object Name:	EDR_PROCESS_ERECORDS_T
Object Type:	TABLE
Owner:	EDR
FND Design Data:	EDR.EDR_PROCESS_ERECORDS_T
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EDR_PROCESS_ERECORDS_T_P	NORMAL	UNIQUE	APPS_TS_INTERFACE	ERECORD_SEQUENCE_ID
SYS_IL0000396569C00005$$	LOB	UNIQUE	APPS_TS_INTERFACE
EDR_PROCESS_ERECORDS_T_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ERES_PROCESS_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ERECORD_SEQUENCE_ID	NUMBER		Yes	Primary Key which identifies a specific row
ERES_PROCESS_ID	NUMBER			The process ID which identified the transaction
TRANSACTION_NAME	VARCHAR2	(80)		The transaction name of the e-record
TRANSACTION_KEY	VARCHAR2	(240)		The transaction key of the e-record
PAYLOAD	CLOB	(4000)		The runtime transaction data
REQUESTER	VARCHAR2	(100)		The user requesting the transaction
DEFERRED_MODE	VARCHAR2	(1)		Specifies whether deferred mode is allowed
POST_OP_API	VARCHAR2	(240)		The post operation API to be executed after ERES processing in case of deferred transactions
USER_KEY_LABEL	VARCHAR2	(240)		The user key label
USER_KEY_VALUE	VARCHAR2	(240)		The user key value
TRANSACTION_AUDIT_ID	NUMBER			The transaction sudit id
STATUS	VARCHAR2	(32)		The e-record approval status
ERECORD_ID	NUMBER			The e-record ID as stored in evidence store
PARENT_NAME	VARCHAR2	(80)		The parent event name of the e-record
PARENT_KEY	VARCHAR2	(240)		The parent key of the e-record
PARENT_ERECORD_ID	NUMBER			The parent e-record ID
CHILD_ERECORD_IDS	VARCHAR2	(100)		Comma separated values of child e-record IDs
WF_ITEM_TYPE	VARCHAR2	(30)		The workflow item type
WF_ITEM_KEY	VARCHAR2	(30)		The workflow item key
WF_PROCESS	VARCHAR2	(30)		The workflow process
SOURCE_APPLICATION	VARCHAR2	(15)		The source application type from which ERES is triggered
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_LOGIN	NUMBER	(15)		Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column

Query Text

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


SELECT ERECORD_SEQUENCE_ID
,      ERES_PROCESS_ID
,      TRANSACTION_NAME
,      TRANSACTION_KEY
,      PAYLOAD
,      REQUESTER
,      DEFERRED_MODE
,      POST_OP_API
,      USER_KEY_LABEL
,      USER_KEY_VALUE
,      TRANSACTION_AUDIT_ID
,      STATUS
,      ERECORD_ID
,      PARENT_NAME
,      PARENT_KEY
,      PARENT_ERECORD_ID
,      CHILD_ERECORD_IDS
,      WF_ITEM_TYPE
,      WF_ITEM_KEY
,      WF_PROCESS
,      SOURCE_APPLICATION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
FROM EDR.EDR_PROCESS_ERECORDS_T;

Dependencies

[top of page]

EDR.EDR_PROCESS_ERECORDS_T does not reference any database object

EDR.EDR_PROCESS_ERECORDS_T is referenced by following:

EDR: EDR_PROCESS_ERECORDS_T#