[Home] [Help] [Dependency Information]
Object Name: | EDR_PROCESS_ERECORDS_T |
---|---|
Object Type: | TABLE |
Owner: | EDR |
FND Design Data: | EDR.EDR_PROCESS_ERECORDS_T |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
EDR.EDR_PROCESS_ERECORDS_T does not reference any database object
EDR.EDR_PROCESS_ERECORDS_T is referenced by following:
|
|
|