{"id":176,"date":"2007-04-27T09:38:54","date_gmt":"2007-04-27T07:38:54","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=176"},"modified":"2025-10-24T09:22:16","modified_gmt":"2025-10-24T07:22:16","slug":"sql-sprawdzenie-w-jakich-autoryzacjach-jest-program-wspolbiezny","status":"publish","type":"post","link":"http:\/\/oracle.malin.pl\/?p=176","title":{"rendered":"SQL &#8211; sprawdzenie w jakich autoryzacjach\/grupach zlece\u0144 jest program wsp\u00f3\u0142bie\u017cny\/raport"},"content":{"rendered":"<pre lang=\"plsql\">select\ncpt.user_concurrent_program_name Nazwa_Programu,\ncp.concurrent_program_name Skrot_programu,\nfrv.RESPONSIBILITY_NAME Autoryzacja,\nfrg.request_group_name Grupa_Zlecen,\nfa.APPLICATION_NAME Modul\nfrom\nfnd_concurrent_programs cp,\nfnd_concurrent_programs_tl cpt,\nFND_REQUEST_GROUPS frg,\nFND_REQUEST_GROUP_UNITS frgu,\napps.fnd_application_all_view fa,\napps.FND_RESPONSIBILITY_VL frv,\napps.FND_EXECUTABLES_FORM_V fefv,\napps.fnd_application_vl faa\nwhere cp.application_id=cpt.application_id\nand cpt.concurrent_program_id=cp.concurrent_program_id\nand cpt.language='PL'\nand frgu.application_id=frg.application_id\nand frg.request_group_id=frgu.request_group_id\nand frgu.request_unit_id=cp.concurrent_program_id\nand fa.application_id=frg.application_id\nand frv.REQUEST_GROUP_ID(+)=frg.request_group_id\nand fefv.EXECUTABLE_ID=cp.executable_id\nand fefv.EXECUTION_METHOD_CODE='P'\nand faa.APPLICATION_ID=cp.application_id\nand faa.APPLICATION_NAME='Rozszerzenia'\n--and cp.concurrent_program_name = \u02dcXX_RAP_CR00434_AR'\nand cpt.user_concurrent_program_name like 'XX: Wydruk zapotrzebowania na RW ODM'<\/pre>\n<p><span style=\"color: #999999;\">s\u0142owa kluczowe: raport, program wsp\u00f3\u0142bie\u017cny, autoryzacja, autoryzacje, grupa zlece\u0144<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>select cpt.user_concurrent_program_name Nazwa_Programu, cp.concurrent_program_name Skrot_programu, frv.RESPONSIBILITY_NAME Autoryzacja, frg.request_group_name Grupa_Zlecen, fa.APPLICATION_NAME Modul from fnd_concurrent_programs cp, fnd_concurrent_programs_tl cpt, FND_REQUEST_GROUPS frg, FND_REQUEST_GROUP_UNITS frgu, apps.fnd_application_all_view fa, apps.FND_RESPONSIBILITY_VL frv, apps.FND_EXECUTABLES_FORM_V fefv, apps.fnd_application_vl faa where cp.application_id=cpt.application_id and cpt.concurrent_program_id=cp.concurrent_program_id and cpt.language=&#8217;PL&#8217; and frgu.application_id=frg.application_id and frg.request_group_id=frgu.request_group_id and frgu.request_unit_id=cp.concurrent_program_id &hellip; <a href=\"http:\/\/oracle.malin.pl\/?p=176\">Czytaj dalej <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":20,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[97],"tags":[225,226],"_links":{"self":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/176"}],"collection":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/20"}],"replies":[{"embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=176"}],"version-history":[{"count":7,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/176\/revisions"}],"predecessor-version":[{"id":1494,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/176\/revisions\/1494"}],"wp:attachment":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=176"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}