View: JTF_FM_PRINTER_LOOKUPS_V

Product:	JTF - CRM Foundation
Description:	View to lookup printers
Implementation/DBA Data:	APPS.JTF_FM_PRINTER_LOOKUPS_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
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

Columns