Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: EDR.EDR_PROCESS_ERECORDS_T#

Object Details
Object Name: EDR_PROCESS_ERECORDS_T#
Object Type: VIEW
Owner: EDR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ERECORD_SEQUENCE_ID NUMBER
Yes
ERES_PROCESS_ID NUMBER

TRANSACTION_NAME VARCHAR2 (80)
TRANSACTION_KEY VARCHAR2 (240)
PAYLOAD CLOB (4000)
REQUESTER VARCHAR2 (100)
DEFERRED_MODE VARCHAR2 (1)
POST_OP_API VARCHAR2 (240)
USER_KEY_LABEL VARCHAR2 (240)
USER_KEY_VALUE VARCHAR2 (240)
TRANSACTION_AUDIT_ID NUMBER

STATUS VARCHAR2 (32)
ERECORD_ID NUMBER

PARENT_NAME VARCHAR2 (80)
PARENT_KEY VARCHAR2 (240)
PARENT_ERECORD_ID NUMBER

CHILD_ERECORD_IDS VARCHAR2 (100)
WF_ITEM_TYPE VARCHAR2 (30)
WF_ITEM_KEY VARCHAR2 (30)
WF_PROCESS VARCHAR2 (30)
SOURCE_APPLICATION VARCHAR2 (15)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Yes
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# references the following:

SchemaEDR
TableEDR_PROCESS_ERECORDS_T
EDR.EDR_PROCESS_ERECORDS_T# is referenced by following:

SchemaAPPS
SynonymEDR_PROCESS_ERECORDS_T