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

TABLE: OE.SO_REPORT_PRINTERS

Object Details
Object Name: SO_REPORT_PRINTERS
Object Type: TABLE
Owner: OE
FND Design Data: TableOE.SO_REPORT_PRINTERS
Subobject Name:
Status: VALID


SO_REPORT_PRINTERS stores the printer assignments for your shipping
reports. Each shipping report should have at least one record in this
table. Assignments can be done by Site, Application, Responsibility
and User. This table corresponds to the Choose Printers for Shipping
Documents window.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SO_REPORT_PRINTERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnREPORT_ID
ColumnLEVEL_TYPE_ID
ColumnLEVEL_VALUE_ID
Columns
Name Datatype Length Mandatory Comments
REPORT_ID NUMBER
Yes System-generated ID
LEVEL_TYPE_ID NUMBER
Yes AOL level, i.e., Site, Application, Responsibility, User
LEVEL_VALUE_ID NUMBER
Yes Site name, application name, resposiblity, or user, depending on the level type
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
PRINTER_NAME VARCHAR2 (30) Yes Name of the printer
ENABLE_FLAG VARCHAR2 (1) Yes Enable/disable flag
DESCRIPTION VARCHAR2 (240)
Printer description
APPLICATION_ID NUMBER (15)
Application ID
Query Text

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


SELECT REPORT_ID
,      LEVEL_TYPE_ID
,      LEVEL_VALUE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PRINTER_NAME
,      ENABLE_FLAG
,      DESCRIPTION
,      APPLICATION_ID
FROM OE.SO_REPORT_PRINTERS;

Dependencies

[top of page]

OE.SO_REPORT_PRINTERS does not reference any database object

OE.SO_REPORT_PRINTERS is referenced by following:

SchemaAPPS
SynonymSO_REPORT_PRINTERS