{"id":178,"date":"2007-04-27T12:49:57","date_gmt":"2007-04-27T10:49:57","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=178"},"modified":"2012-04-03T09:49:59","modified_gmt":"2012-04-03T07:49:59","slug":"sql-zestawienie-programow-wspolbieznych-plikow-wykonywalnych-i-rodzajow","status":"publish","type":"post","link":"http:\/\/oracle.malin.pl\/?p=178","title":{"rendered":"SQL &#8211; zestawienie program\u00f3w wsp\u00f3\u0142bie\u017cnych, plik\u00f3w wykonywalnych i rodzaj\u00f3w"},"content":{"rendered":"<pre lang=\"PLSQL\">select p.CONCURRENT_PROGRAM_NAME skrot_programu_wspolbieznego,\r\n       p.USER_CONCURRENT_PROGRAM_NAME nazwa_programu_wspolbieznego,\r\n       p.CREATION_DATE data_utworzenia,\r\n       p.EXECUTABLE_ID,\r\n       ex.EXECUTABLE_NAME skrot_pliku_wykonywalnego,\r\n       ex.EXECUTION_FILE_NAME nazwa_pliku_wykonywalnego,\r\n       p.EXECUTION_METHOD_CODE rodzaj_wykonywania,\r\n       pr.MEANING rodzaj_wykonywania_opis,\r\n       p.OUTPUT_FILE_TYPE typ_wyjscia\r\n\r\n  from apps.fnd_concurrent_programs_vl p,\r\n       apps.fnd_lookup_values_vl pr,\r\n       apps.fnd_executables_vl ex\r\n\r\n where p.APPLICATION_ID =\r\n       (select a.APPLICATION_ID\r\n          from fnd_application_vl a\r\n         where a.APPLICATION_SHORT_NAME = 'XXCU')\r\n\r\n   and p.EXECUTION_METHOD_CODE = pr.LOOKUP_CODE(+)\r\n   and pr.LOOKUP_TYPE(+) = 'CP_EXECUTION_METHOD_CODE'\r\n   and ex.EXECUTABLE_ID(+) = p.EXECUTABLE_ID\r\n   and ex.APPLICATION_ID(+) = p.APPLICATION_ID\r\n   and p.ENABLED_FLAG = 'Y'\r\n   and upper(p.USER_CONCURRENT_PROGRAM_NAME) like upper('%Rem%')\r\n order by 1<\/pre>\n<p lang=\"PLSQL\"><span style=\"color: #999999;\">s\u0142owa kluczowe: zlecenie wsp\u00f3\u0142bie\u017cne, nazwa zlecenia, zlecenie &#8211; plik wykonywalny <\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>select p.CONCURRENT_PROGRAM_NAME skrot_programu_wspolbieznego, p.USER_CONCURRENT_PROGRAM_NAME nazwa_programu_wspolbieznego, p.CREATION_DATE data_utworzenia, p.EXECUTABLE_ID, ex.EXECUTABLE_NAME skrot_pliku_wykonywalnego, ex.EXECUTION_FILE_NAME nazwa_pliku_wykonywalnego, p.EXECUTION_METHOD_CODE rodzaj_wykonywania, pr.MEANING rodzaj_wykonywania_opis, p.OUTPUT_FILE_TYPE typ_wyjscia from apps.fnd_concurrent_programs_vl p, apps.fnd_lookup_values_vl pr, apps.fnd_executables_vl ex where p.APPLICATION_ID = (select a.APPLICATION_ID from fnd_application_vl a where a.APPLICATION_SHORT_NAME = 'XXCU&#8217;) and p.EXECUTION_METHOD_CODE = &hellip; <a href=\"http:\/\/oracle.malin.pl\/?p=178\">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\/178"}],"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=178"}],"version-history":[{"count":4,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/178\/revisions"}],"predecessor-version":[{"id":690,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/178\/revisions\/690"}],"wp:attachment":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=178"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=178"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=178"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}