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

TABLE: EDR.EDR_TRANS_ACKN

Object Details
Object Name: EDR_TRANS_ACKN
Object Type: TABLE
Owner: EDR
FND Design Data: TableEDR.EDR_TRANS_ACKN
Subobject Name:
Status: VALID


Table to store the transaction acknowledgement for erecords


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EDR_TRANS_ACKN_P NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnACKN_ID
EDR_TRANS_ACKN_U NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnERECORD_ID
ColumnTRANSACTION_STATUS
Columns
Name Datatype Length Mandatory Comments
ACKN_ID NUMBER
Yes Surrogate key of the table
ERECORD_ID NUMBER
Yes eRecord ID of the eRecord for which acknowledgement is created
ACKN_DATE DATE
Yes Date on which acknowledgement is recorded
TRANSACTION_STATUS VARCHAR2 (30) Yes Status of the transaction for which eREcord is created
ACKN_BY VARCHAR2 (200)
Details of the source from where the acknowledgement is received
ACKN_NOTE VARCHAR2 (2000)
General notes (comments) about the acknowledgement providing more information
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 ACKN_ID
,      ERECORD_ID
,      ACKN_DATE
,      TRANSACTION_STATUS
,      ACKN_BY
,      ACKN_NOTE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
FROM EDR.EDR_TRANS_ACKN;

Dependencies

[top of page]

EDR.EDR_TRANS_ACKN does not reference any database object

EDR.EDR_TRANS_ACKN is referenced by following:

SchemaAPPS
SynonymEDR_TRANS_ACKN