VIEW: APPS.JTF_FM_PRINTER_LOOKUPS_USERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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