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

TABLE: EDR.EDR_PSIG_PRINT_HISTORY

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


Maintain print history for a e-record


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EDR_PSIG_PRINT_HISTORY_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDOCUMENT_ID
ColumnPRINT_COUNT
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_ID NUMBER
Yes Document Id to be printed
PRINT_DOCUMENT_ID NUMBER

Document ID of the print e-record
PRINT_COUNT NUMBER
Yes Print Count
PRINT_REQUESTED_BY VARCHAR2 (240)
Print requested by
PRINT_REQUESTED_DATE DATE

Print requested date
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
ORIG_SYSTEM VARCHAR2 (240)
Originating User System Name
ORIG_SYSTEM_ID NUMBER

Originating User System ID
USER_DISPLAY_NAME VARCHAR2 (360)
The User Display Name
Query Text

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


SELECT DOCUMENT_ID
,      PRINT_DOCUMENT_ID
,      PRINT_COUNT
,      PRINT_REQUESTED_BY
,      PRINT_REQUESTED_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      ORIG_SYSTEM
,      ORIG_SYSTEM_ID
,      USER_DISPLAY_NAME
FROM EDR.EDR_PSIG_PRINT_HISTORY;

Dependencies

[top of page]

EDR.EDR_PSIG_PRINT_HISTORY does not reference any database object

EDR.EDR_PSIG_PRINT_HISTORY is referenced by following:

SchemaAPPS
SynonymEDR_PSIG_PRINT_HISTORY