{"id":1047,"date":"2013-09-03T15:28:08","date_gmt":"2013-09-03T13:28:08","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=1047"},"modified":"2013-09-03T15:28:08","modified_gmt":"2013-09-03T13:28:08","slug":"sprawdzanie-ustawien-opcji-profilu-sql","status":"publish","type":"post","link":"https:\/\/oracle.malin.pl\/?p=1047","title":{"rendered":"sprawdzanie ustawie\u0144 opcji profilu &#8211; SQL"},"content":{"rendered":"<pre lang=\"sql\">SELECT\r\nsubstr(pro1.user_profile_option_name,1,35) Profile,\r\ndecode(pov.level_id,\r\n10001,'Site',\r\n10002,'Application',\r\n10003,'Resp',\r\n10004,'User') Option_Level,\r\ndecode(pov.level_id,\r\n10001,'Site',\r\n10002,appl.application_short_name,\r\n10003,resp.responsibility_name,\r\n10004,u.user_name) Level_Value,\r\nnvl(pov.profile_option_value,'Is Null') Profile_option_Value\r\nFROM\r\nfnd_profile_option_values pov,\r\nfnd_responsibility_tl resp,\r\nfnd_application appl,\r\nfnd_user u,\r\nfnd_profile_options pro,\r\nfnd_profile_options_tl pro1\r\nWHERE\r\npro1.user_profile_option_name like ('%Ledger%')\r\nand pro.profile_option_name = pro1.profile_option_name\r\nand pro.profile_option_id = pov.profile_option_id\r\nand resp.responsibility_name like '%General%Ledger%' \/* comment this line if you need to check profiles for all responsibilities *\/\r\nand pov.level_value = resp.responsibility_id (+)\r\nand pov.level_value = appl.application_id (+)\r\nand pov.level_value = u.user_id (+)\r\norder by 1,2;<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>SELECT substr(pro1.user_profile_option_name,1,35) Profile, decode(pov.level_id, 10001,&#8217;Site&#8217;, 10002,&#8217;Application&#8217;, 10003,&#8217;Resp&#8217;, 10004,&#8217;User&#8217;) Option_Level, decode(pov.level_id, 10001,&#8217;Site&#8217;, 10002,appl.application_short_name, 10003,resp.responsibility_name, 10004,u.user_name) Level_Value, nvl(pov.profile_option_value,&#8217;Is Null&#8217;) Profile_option_Value FROM fnd_profile_option_values pov, fnd_responsibility_tl resp, fnd_application appl, fnd_user u, fnd_profile_options pro, fnd_profile_options_tl pro1 WHERE pro1.user_profile_option_name like (&#8217;%Ledger%&#8217;) and pro.profile_option_name = pro1.profile_option_name and &hellip; <a href=\"https:\/\/oracle.malin.pl\/?p=1047\">Czytaj dalej <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":38,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[40,97],"tags":[57,200,73],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1047"}],"collection":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/38"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1047"}],"version-history":[{"count":1,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1047\/revisions"}],"predecessor-version":[{"id":1048,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1047\/revisions\/1048"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1047"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1047"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1047"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}