VIEW: APPS.JTF_FM_PRINTER_LOOKUPS_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 from jtf_fm_service_all a, jtf_fm_printer b, jtf_fm_print_servers c, jtf_fm_printers d 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

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
FROM JTF_FM_SERVICE_ALL A
, JTF_FM_PRINTER B
, JTF_FM_PRINT_SERVERS C
, JTF_FM_PRINTERS D
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