View: JTF_FM_PRINTER_LOOKUPS_USERS_V

Product:	JTF - CRM Foundation
Description:	View to Lookup Printers associated with a user.
Implementation/DBA Data:	APPS.JTF_FM_PRINTER_LOOKUPS_USERS_V

View Text

SELECT A.SERVER_ID
, C.PRINT_SERVER_ID
, C.PHYSICAL_NAME
, C.PRINT_SERVER_TYPE
, D.PRINTER_NAME
, D.PRINTER_API_VALUE
, F.USER_ID
FROM JTF_FM_SERVICE_ALL A
, JTF_FM_PRINTER B
, JTF_FM_PRINT_SERVERS C
, JTF_FM_PRINTERS D
, JTF_FM_GROUPS_ALL E
, JTF_FM_GROUP_FND_USER F
WHERE A.SERVER_ID = B.SERVER_ID
AND B.PRINT_SERVER_ID = C.PRINT_SERVER_ID
AND B.PRINT_SERVER_ID = D.PRINT_SERVER_ID
AND E.SERVER_ID = A.SERVER_ID
AND E.GROUP_ID = F.GROUP_ID
AND E.F_DELETEDFLAG IS NULL
AND F.F_DELETEDFLAG IS NULL

Columns