Stay at Home!! Be Safe!! Take Care!!

For Any queries, please mail us at support@funoracleapps.com

Query to find the profile assigned to a Responsibility in Oracle Apps

No comments

 Query to find the profile assigned to a Responsibility in Oracle Apps


Query:

select distinct * from (SELECT  b.user_profile_option_name "Long Name" ,
  a.profile_option_name "Short Name" ,
  NVL(g.responsibility_name,c.level_value)  "Level Value" ,
  c.PROFILE_OPTION_VALUE "Profile Value"
FROM apps.fnd_profile_options a ,
  apps.FND_PROFILE_OPTIONS_tL b ,
  apps.FND_PROFILE_OPTION_VALUES c ,
  apps.FND_USER d ,
  apps.FND_USER e ,
  apps.FND_RESPONSIBILITY_tL g ,
  apps.FND_APPLICATION h
WHERE 1                   =1
AND a.profile_option_name = b.profile_option_name
AND a.profile_option_id   = c.profile_option_id
AND a.application_id      = c.application_id
AND c.last_updated_by     = d.user_id (+)
AND c.level_value         = e.user_id (+)
AND c.level_value         = g.responsibility_id (+)
AND c.level_value         = h.application_id (+)
  --
AND c.level_id            = 10003
and b.language='US'
AND g.responsibility_name = '%&Responsibility Name%'
ORDER BY b.user_profile_option_name,  c.level_id
);

No comments :

Post a Comment