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

TABLE: EDR.EDR_COLLATE_PRINT_TEMP

Object Details
Object Name: EDR_COLLATE_PRINT_TEMP
Object Type: TABLE
Owner: EDR
FND Design Data: TableEDR.EDR_COLLATE_PRINT_TEMP
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_COLLATE_PRINT_TEMP_PK NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnREQUEST_ID
SYS_IL0000324968C00008$$ LOB UNIQUE TablespaceAPPS_TS_INTERFACE
SYS_IL0000324968C00009$$ LOB UNIQUE TablespaceAPPS_TS_INTERFACE
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER
Yes Collation Identifier, for print request
CREATION_DATE DATE

Date Print Requested
CREATED_BY NUMBER (15)
Print Requestor
PRINTER_NAME VARCHAR2 (30)
Stores the FND Printer name to which the Request will be spooled
PRINT_STYLE VARCHAR2 (30)
FND Print Style to be used for this print request
NEW_PAGE_NUMBER VARCHAR2 (1)
If Collated PDF should have new page numbers or not
PRINT_STATUS VARCHAR2 (32)
Status of the print request
DRAFT_COLLATED_PDF BLOB (4000)
Draft Collated PDF
FINAL_COLLATED_PDF BLOB (4000)
Final Collated PDF
Query Text

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


SELECT REQUEST_ID
,      CREATION_DATE
,      CREATED_BY
,      PRINTER_NAME
,      PRINT_STYLE
,      NEW_PAGE_NUMBER
,      PRINT_STATUS
,      DRAFT_COLLATED_PDF
,      FINAL_COLLATED_PDF
FROM EDR.EDR_COLLATE_PRINT_TEMP;

Dependencies

[top of page]

EDR.EDR_COLLATE_PRINT_TEMP does not reference any database object

EDR.EDR_COLLATE_PRINT_TEMP is referenced by following:

SchemaEDR
ViewEDR_COLLATE_PRINT_TEMP#