{"id":17720,"date":"2019-01-14T11:51:50","date_gmt":"2019-01-14T13:51:50","guid":{"rendered":"https:\/\/orabr.com\/?p=17720"},"modified":"2020-12-30T12:46:26","modified_gmt":"2020-12-30T14:46:26","slug":"localizar-package-pelo-nome-do-concurrent","status":"publish","type":"post","link":"https:\/\/orabr.virttus.com\/?p=17720","title":{"rendered":"Localizar package pelo nome do concurrent"},"content":{"rendered":"
SELECT a.user_concurrent_program_name\n      ,b.executable_name\n      ,b.execution_file_name package_name\n  FROM apps.fnd_concurrent_programs_vl a\n      ,apps.fnd_executables_vl         b\n WHERE a.executable_id = b.executable_id\n   AND upper(user_concurrent_program_name) like\u00a0'%NOME_CONCORRENTE%'<\/pre>\n
\u00a0<\/p>\n\n\n
\u00a0<\/p>\n
NO CASO DO CONCORRENTE SER UM REPORT OU ALGO DIFERENTE, USAR A QUERY ABAIXO<\/p>\n
\u00a0<\/p>\n\n\n\n
SELECT prog. user_concurrent_program_name \"Concurrent Program Name\"\n \u00a0\u00a0 \u00a0 \u00a0 ,prog.concurrent_program_name \"Concurrent Program short name\"\n \u00a0\u00a0 \u00a0 \u00a0 ,exe.executable_name \"Executable Name\"\n \u00a0\u00a0 \u00a0 \u00a0 ,exe.execution_file_name \"executable file name\"\n \u00a0\u00a0 \u00a0 \u00a0 ,decode(exe.execution_method_code, 'I', 'PLSQL Stored Procedure', 'P',\n \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 'Report', 'L', 'SQL Loader', 'Q', 'SQL*Plus',\n \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 exe.execution_method_code) \"Program Execution Method\"\n \u00a0\u00a0 \u00a0 \u00a0 ,appl.application_name \"application name\"\n \u00a0\u00a0 \u00a0 \u00a0 ,prog.description \"Program description\"\n \u00a0 FROM apps.fnd_executables\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 exe\n \u00a0 \u00a0 \u00a0 ,apps.fnd_application_tl \u00a0 \u00a0 \u00a0 \u00a0 appl\n \u00a0 \u00a0 \u00a0 ,apps.fnd_concurrent_programs_vl prog\n \u00a0WHERE exe.application_id = appl.application_id\n \u00a0\u00a0 AND exe.executable_id = prog.executable_id\n \u00a0\u00a0 AND UPPER(prog.user_concurrent_program_name) like UPPER('%NOME DO CONCORRENTE%')\n \n<\/pre>\n<\/HTML>","protected":false},"excerpt":{"rendered":"
SELECT a.user_concurrent_program_name ,b.executable_name ,b.execution_file_name package_name FROM apps.fnd_concurrent_programs_vl a ,apps.fnd_executables_vl b WHERE a.executable_id = b.executable_id AND upper(user_concurrent_program_name) like\u00a0‘%NOME_CONCORRENTE%’ \u00a0 SELECT prog. user_concurrent_program_name “Concurrent Program Name” \u00a0\u00a0… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[138],"tags":[],"class_list":["post-17720","post","type-post","status-publish","format-standard","hentry","category-sql"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/17720","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=17720"}],"version-history":[{"count":7,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/17720\/revisions"}],"predecessor-version":[{"id":21477,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/17720\/revisions\/21477"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=17720"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=17720"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=17720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}