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