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

TABLE: EDR.EDR_ESIGNATURES

Object Details
Object Name: EDR_ESIGNATURES
Object Type: TABLE
Owner: EDR
FND Design Data: TableEDR.EDR_ESIGNATURES
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: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EDR_ESIGNATURES_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnSIGNATURE_ID
EDR_ESIGNATURES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnEVENT_ID
Columns
Name Datatype Length Mandatory Comments
SIGNATURE_ID NUMBER

EVENT_ID NUMBER

EVENT_NAME VARCHAR2 (240)
EVIDENCE_STORE_ID NUMBER

USER_NAME VARCHAR2 (100)
SIGNATURE_SEQUENCE VARCHAR2 (32)
SIGNATURE_TYPE VARCHAR2 (32)
SIGNATURE_TIMESTAMP DATE

SIGNATURE_TIMEZONE VARCHAR2 (240)
SIGNATURE_STATUS VARCHAR2 (32)
SIGNATURE_REASON_CODE VARCHAR2 (32)
SIGNER_COMMENTS VARCHAR2 (4000)
ORIGINAL_RECIPIENT VARCHAR2 (100)
SIGNATURE_OVERRIDING_COMMENTS VARCHAR2 (4000)
ADHOC_STATUS VARCHAR2 (32)
This column is used to identify is the user is a adhoc user. Added Adhoc users will have the value as ADDED. If the default users are deleted then it will have deleted as the value.
Query Text

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


SELECT SIGNATURE_ID
,      EVENT_ID
,      EVENT_NAME
,      EVIDENCE_STORE_ID
,      USER_NAME
,      SIGNATURE_SEQUENCE
,      SIGNATURE_TYPE
,      SIGNATURE_TIMESTAMP
,      SIGNATURE_TIMEZONE
,      SIGNATURE_STATUS
,      SIGNATURE_REASON_CODE
,      SIGNER_COMMENTS
,      ORIGINAL_RECIPIENT
,      SIGNATURE_OVERRIDING_COMMENTS
,      ADHOC_STATUS
FROM EDR.EDR_ESIGNATURES;

Dependencies

[top of page]

EDR.EDR_ESIGNATURES does not reference any database object

EDR.EDR_ESIGNATURES is referenced by following:

SchemaEDR
ViewEDR_ESIGNATURES#