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))
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