tag:blogger.com,1999:blog-5954268311855527678.post7465015714151091613..comments2024-03-18T05:45:05.913-07:00Comments on Oracle Apps Knowledge Sharing: Query to find Profile Option Details at all levelsUnknownnoreply@blogger.comBlogger3125tag:blogger.com,1999:blog-5954268311855527678.post-86247351808634303942021-09-01T01:22:57.625-07:002021-09-01T01:22:57.625-07:00Lovvely blog you haveLovvely blog you haveRose Whttps://www.roseweber.com/noreply@blogger.comtag:blogger.com,1999:blog-5954268311855527678.post-82999610423920596412013-12-03T09:00:54.263-08:002013-12-03T09:00:54.263-08:00Thank you for sharing your query and FeedbackThank you for sharing your query and FeedbackTeam searchhttps://www.blogger.com/profile/18006386434186479521noreply@blogger.comtag:blogger.com,1999:blog-5954268311855527678.post-37557917849538604512013-10-28T08:15:14.510-07:002013-10-28T08:15:14.510-07:00Thank you for sharing! The "LIKEUPPER" d...Thank you for sharing! The "LIKEUPPER" did not work for me so I changed it to be separate key words. Also I added another column to lookup the level_val if they are Application, Responsibility or User.<br /><br />SELECT p.profile_option_name short_name,<br /> n.user_profile_option_name NAME,<br /> DECODE(v.level_id,<br /> 10001,'Site',<br />zcat08https://www.blogger.com/profile/03260653477508234541noreply@blogger.com