eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: WSH.WSH_REPORT_PRINTERS

Object Details

Object Name:	WSH_REPORT_PRINTERS
Object Type:	TABLE
Owner:	WSH
FND Design Data:	WSH.WSH_REPORT_PRINTERS
Subobject Name:
Status:	VALID

WSH_REPORT_PRINTERS maps printers to shipping reports.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WSH_REPORT_PRINTERS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	APPLICATION_ID CONCURRENT_PROGRAM_ID LEVEL_TYPE_ID LEVEL_VALUE_ID
WSH_REPORT_PRINTERS_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	LEVEL_TYPE_ID LEVEL_VALUE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICATION_ID	NUMBER		Yes	Application identifier for the report
CONCURRENT_PROGRAM_ID	NUMBER		Yes	Identifier of the report
LEVEL_TYPE_ID	NUMBER		Yes	Identifier for the value type
LEVEL_VALUE_ID	NUMBER		Yes	Identifier for the value level
PRINTER_NAME	VARCHAR2	(30)	Yes	Name of the Printer the report is to be printed on
DESCRIPTION	VARCHAR2	(240)		Description of the printer
ENABLED_FLAG	VARCHAR2	(1)	Yes	Indicates if this printer is enabled or not
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield
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
REQUEST_ID	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who column
PROGRAM_ID	NUMBER			Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
LABEL_ID	NUMBER			Label identifier
FORMAT_TYPE	VARCHAR2	(30)		Format type
EQUIPMENT_INSTANCE	VARCHAR2	(30)		Equipment instance
ORGANIZATION_ID	NUMBER			Organization identifier
SUBINVENTORY	VARCHAR2	(10)		Subinventory
DEFAULT_PRINTER_FLAG	VARCHAR2	(1)		Default printer flag

Query Text

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


SELECT APPLICATION_ID
,      CONCURRENT_PROGRAM_ID
,      LEVEL_TYPE_ID
,      LEVEL_VALUE_ID
,      PRINTER_NAME
,      DESCRIPTION
,      ENABLED_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LABEL_ID
,      FORMAT_TYPE
,      EQUIPMENT_INSTANCE
,      ORGANIZATION_ID
,      SUBINVENTORY
,      DEFAULT_PRINTER_FLAG
FROM WSH.WSH_REPORT_PRINTERS;

Dependencies

[top of page]

WSH.WSH_REPORT_PRINTERS does not reference any database object

WSH.WSH_REPORT_PRINTERS is referenced by following:

APPS: WSH_REPORT_PRINTERS