Wednesday 19 June 2013

Standard Printer Driver

SELECT printer_driver_name,
       user_printer_driver_name,
       srw_driver
FROM fnd_printer_drivers
where
  ( created_by NOT IN (-1,1,0)
   OR last_updated_by NOT IN (-1,1,0)
  )

Standard Printer Style:

select  PRINTER_STYLE_NAME,SRW_DRIVER
from FND_PRINTER_STYLES
WHERE
 ( created_by NOT IN (-1,1)
   OR last_updated_by NOT IN (-1,1)
  )

Printer Type

select printer_type,DESCRIPTION from FND_PRINTER_TYPES
WHERE
 ( created_by NOT IN (-1,1,0)
   OR last_updated_by NOT IN (-1,1,0)
  )
UNION
select a.printer_type, a.description
from fnd_printer_types a,
     fnd_printer_information b
where a.printer_type = b.printer_type
and ( b.created_by NOT IN (-1,1,0)
OR b.last_updated_by NOT IN (-1,1,0))

No comments:

Post a Comment