{"id":1138,"date":"2014-10-02T16:12:32","date_gmt":"2014-10-02T14:12:32","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=1138"},"modified":"2014-10-02T16:13:44","modified_gmt":"2014-10-02T14:13:44","slug":"sql-profil-wartosci","status":"publish","type":"post","link":"https:\/\/oracle.malin.pl\/?p=1138","title":{"rendered":"SQL &#8211; Profil &#8211; warto\u015bci"},"content":{"rendered":"<p>SQL &#8211; Profil &#8211; warto\u015bci dla danego profilu:<br \/>\n<!--more--><\/p>\n<pre lang=\"sql\">\r\nselect\r\nb.user_profile_option_name \"Long Name\"\r\n, a.profile_option_name \"Short Name\"\r\n, decode(to_char(c.level_id),'10001','Site'\r\n,'10002','Application'\r\n,'10003','Responsibility'\r\n,'10004','User'\r\n,'Unknown') \"Level\"\r\n, decode(to_char(c.level_id),'10001','Site'\r\n,'10002',nvl(h.application_short_name,to_char(c.level_value))\r\n,'10003',nvl(g.responsibility_name,to_char(c.level_value))\r\n,'10004',nvl(e.user_name,to_char(c.level_value))\r\n,'Unknown') \"Level Value\"\r\n, c.PROFILE_OPTION_VALUE \"Profile Value\"\r\n, c.profile_option_id \"Profile ID\"\r\n, to_char(c.LAST_UPDATE_DATE,'DD-MON-YYYY HH24:MI') \"Updated Date\"\r\n, nvl(d.user_name,to_char(c.last_updated_by)) \"Updated By\"\r\nfrom\r\napps.fnd_profile_options a\r\n, apps.FND_PROFILE_OPTIONS_VL b\r\n, apps.FND_PROFILE_OPTION_VALUES c\r\n, apps.FND_USER d\r\n, apps.FND_USER e\r\n, apps.FND_RESPONSIBILITY_VL g\r\n, apps.FND_APPLICATION h\r\nwhere\r\n--a.application_id = nvl(401, a.application_id)\r\n--and a.profile_option_name = nvl('INV', a.profile_option_name)\r\nb.user_profile_option_name like '&amp;ProfileName' -- 'AFLOG_ENABLED'\r\nand a.profile_option_name = b.profile_option_name\r\nand a.profile_option_id = c.profile_option_id\r\nand a.application_id = c.application_id\r\nand c.last_updated_by = d.user_id (+)\r\nand c.level_value = e.user_id (+)\r\nand c.level_value = g.responsibility_id (+)\r\nand c.level_value = h.application_id (+)\r\norder by\r\nb.user_profile_option_name, c.level_id,\r\ndecode(to_char(c.level_id),'10001','Site'\r\n,'10002',nvl(h.application_short_name,to_char(c.level_value))\r\n,'10003',nvl(g.responsibility_name,to_char(c.level_value))\r\n,'10004',nvl(e.user_name,to_char(c.level_value))\r\n,'Unknown');<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>SQL &#8211; Profil &#8211; warto\u015bci dla danego profilu:<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[97],"tags":[73],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1138"}],"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\/37"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1138"}],"version-history":[{"count":2,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1138\/revisions"}],"predecessor-version":[{"id":1140,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1138\/revisions\/1140"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1138"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1138"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1138"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}