Query to identify printers set with the Printer profile, at the all profile levels in Oracle Apps

Query to identify printers set with the Printer profile, at the all profile levels in Oracle Apps

Script:

select distinct

t.user_profile_option_name "Profile Option Name",

decode(v.level_id, 10001,'Site Level',

10002,'Application Level --> ' ||application_name ,

10003,'Responsibility level-->'||responsibility_name,

10004,'User Level-->' ||u.user_name,

'XXX') "Profile Option Level",

profile_option_value "Value"

from fnd_profile_options o,

fnd_profile_option_values v,

fnd_profile_options_tl t,

fnd_responsibility_tl r,

fnd_application_tl a,fnd_user u

where o.profile_option_id = v.profile_option_id

and o.application_id = v.application_id

and start_date_active <= SYSDATE

and nvl(end_date_active,SYSDATE) >= SYSDATE

and o.profile_option_name = t.profile_option_name

and a.application_id(+) = decode(level_id,10002,level_value,null)

and r.responsibility_id(+)= decode(level_id,10003,level_value,null)

and u.user_id(+) = decode(level_id,10004,level_value,null)

--and nvl(u.end_date, sysdate) >= sysdate

and t.user_profile_option_name = 'Printer'

and profile_option_value='' --replace with printer name

order by 2, --v.level_id,

t.user_profile_option_name,

decode(v.level_id, 10001,'Site Level',

10002,'Application Level --> ' ||application_name ,

10003,'Responsibility level-->'||responsibility_name,

10004,'User Level-->' ||u.user_name,

'XXX');