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]

VIEW: APPS.JTF_FM_PRINTER_LOOKUPS_USERS_V

Object Details

Object Name:	JTF_FM_PRINTER_LOOKUPS_USERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JTF.JTF_FM_PRINTER_LOOKUPS_USERS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

View to Lookup Printers associated with a user.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SERVER_ID	NUMBER		Yes	Unique Identifier of the Server
PRINT_SERVER_ID	NUMBER		Yes	Unique identifier of the Print Server.
PHYSICAL_NAME	VARCHAR2	(255)		Physical Name of the Print Server
PRINT_SERVER_TYPE	VARCHAR2	(1)		Identifies the type of Print Server. "P" for Pasta and "R" for RightFax.
PRINTER_NAME	VARCHAR2	(255)		Name of the Printer
PRINTER_API_VALUE	VARCHAR2	(80)		Value passed to p_printer parameter of the Fulfillment API's
USER_ID	NUMBER	(15)	Yes	User Id of the User

Query Text

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


SELECT SERVER_ID
,      PRINT_SERVER_ID
,      PHYSICAL_NAME
,      PRINT_SERVER_TYPE
,      PRINTER_NAME
,      PRINTER_API_VALUE
,      USER_ID
FROM APPS.JTF_FM_PRINTER_LOOKUPS_USERS_V;

Dependencies

[top of page]

APPS.JTF_FM_PRINTER_LOOKUPS_USERS_V references the following:

APPS: JTF_FM_GROUPS_ALL; JTF_FM_GROUP_FND_USER; JTF_FM_PRINTER; JTF_FM_PRINTERS; JTF_FM_PRINT_SERVERS; JTF_FM_SERVICE_ALL

APPS.JTF_FM_PRINTER_LOOKUPS_USERS_V is not referenced by any database object