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');
Subscribe to:
Post Comments
(
Atom
)
Thanks for sharing is so amazing and helpful to us.
ReplyDeleteBuy Hydrocodone online
Looking for English to Spanish Translators? We provide professional Translation Services at highly competitive rates without compromising the quality.
ReplyDeletespanish to english translation services
we are best calgary roofing companies & Best roofing contractors calgary. Contact us for transparent quotes. roofing calgary & roofing services calgary Roofing Company in Calgary
ReplyDeletebuy heroin online
ReplyDeletebuy alprazolam powder online
buy cocaine online
buy mephedrone online
buy 3meo pcp online
buy xenax online
buy pills online
buy fentanyl powder online
buy scopolamine powder online
buy vyvanse powder online
buy coke powder online
buy research powder online
buy humalog kwikpen online
ReplyDeletebuy lantus solostar pen online
buy novolog flextouch pens online
buy basaglar kwikpen online
buy apidra solostar pens online
buy apidra insulin vail online
buy ozempic online
buy saxenda online
buy Toujeo solostar pen online
buy victoza online
buy trulicity online
buy adipex-p online
buy belviq online
buy orlistat online
buy meridia online
buy contrave online
buy insuline online
Dear friends, many thanks for your intention to assist your readers.Information you supplied is very helpful, this is just what I looked for.
ReplyDeleteMr Sanjay Baghela focus to reflects as the best leader of SEO in the world, and his dedication and expertise in SEO field make him enable as the owner of the best BEST SEO Expert India. You can connect with him anytime and you can see his knowledge about SEO itself. Drop your request and dial his number now!
ReplyDeletebest seo expert in india