{"id":4094,"date":"2013-09-30T11:41:07","date_gmt":"2013-09-30T06:11:07","guid":{"rendered":"http:\/\/erpschools.com\/?p=4094"},"modified":"2013-09-30T11:41:07","modified_gmt":"2013-09-30T06:11:07","slug":"concurrent-program-details-name-short-name-executable-execution-method-trace","status":"publish","type":"post","link":"https:\/\/erpschools.com\/erps\/scripts\/sysadmin-aol\/concurrent-program-details-name-short-name-executable-execution-method-trace","title":{"rendered":"Concurrent Program Details: Name, Short name, Executable, Execution method, Trace"},"content":{"rendered":"<p>Script to fetch the following details<br \/>\n1. Concurrent Program Name<br \/>\n2. Concurrent Program Short Name<br \/>\n3. Concurrent Program Application Name<br \/>\n4. Executable Name<br \/>\n5. Executable Short Name<br \/>\n6. Executable Application Name<br \/>\n7. Execution Method<br \/>\n8. Execution file Name<br \/>\n9. Enable Trace flag<\/p>\n<p><code><br \/>\nSELECT fcpt.user_concurrent_program_name ,<br \/>\n  fcp.concurrent_program_name short_name ,<br \/>\n  fat.application_name program_application_name ,<br \/>\n  fet.executable_name ,<br \/>\n  fat1.application_name executable_application_name ,<br \/>\n  flv.meaning execution_method ,<br \/>\n  fet.execution_file_name ,<br \/>\n  fcp.enable_trace<br \/>\nFROM fnd_concurrent_programs_tl fcpt ,<br \/>\n  fnd_concurrent_programs fcp ,<br \/>\n  fnd_application_tl fat ,<br \/>\n  fnd_executables fet ,<br \/>\n  fnd_application_tl fat1 ,<br \/>\n  FND_LOOKUP_VALUES FLV<br \/>\nWHERE 1                              =1<br \/>\nAND fcpt.user_concurrent_program_name='Supplier Audit Report'<br \/>\nAND fcpt.concurrent_program_id       = fcp.concurrent_program_id<br \/>\nAND fcpt.application_id              = fcp.application_id<br \/>\nAND fcp.application_id               = fat.application_id<br \/>\nAND fcpt.application_id              = fat.application_id<br \/>\nAND fcp.executable_id                = fet.executable_id<br \/>\nAND fcp.executable_application_id    = fet.application_id<br \/>\nAND fet.application_id               = fat1.application_id<br \/>\nAND flv.lookup_code                  = fet.execution_method_code<br \/>\nAND FLV.LOOKUP_TYPE                  ='CP_EXECUTION_METHOD_CODE'<br \/>\n;<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Script to fetch the following details 1. Concurrent Program Name 2. Concurrent Program Short Name 3. Concurrent Program Application Name 4. Executable Name 5. Executable Short Name 6. Executable Application Name 7. Execution Method 8. Execution file Name 9. Enable Trace flag SELECT fcpt.user_concurrent_program_name , fcp.concurrent_program_name short_name , fat.application_name program_application_name , fet.executable_name , fat1.application_name executable_application_name [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[129],"class_list":["post-4094","post","type-post","status-publish","format-standard","hentry","category-sysadmin-aol","tag-concurrent-program-script"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Concurrent Program Query to fetch executable, application, short name<\/title>\n<meta name=\"description\" content=\"Concurrent Program Query to fetch Concurrent Program Name, short name, application, executable, execution method, execution file, enable trace flag\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/erpschools.com\/erps\/scripts\/sysadmin-aol\/concurrent-program-details-name-short-name-executable-execution-method-trace\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prudhvi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/erpschools.com\/erps\/scripts\/sysadmin-aol\/concurrent-program-details-name-short-name-executable-execution-method-trace#article\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/scripts\/sysadmin-aol\/concurrent-program-details-name-short-name-executable-execution-method-trace\"},\"author\":{\"name\":\"Prudhvi\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512\"},\"headline\":\"Concurrent Program Details: Name, Short name, Executable, Execution method, Trace\",\"datePublished\":\"2013-09-30T06:11:07+00:00\",\"dateModified\":\"2013-09-30T06:11:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/scripts\/sysadmin-aol\/concurrent-program-details-name-short-name-executable-execution-method-trace\"},\"wordCount\":43,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"keywords\":[\"concurrent program script\"],\"articleSection\":[\"Sysadmin and AOL Scripts\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/erpschools.com\/erps\/scripts\/sysadmin-aol\/concurrent-program-details-name-short-name-executable-execution-method-trace#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/erpschools.com\/erps\/scripts\/sysadmin-aol\/concurrent-program-details-name-short-name-executable-execution-method-trace\",\"url\":\"https:\/\/erpschools.com\/erps\/scripts\/sysadmin-aol\/concurrent-program-details-name-short-name-executable-execution-method-trace\",\"name\":\"Concurrent Program Query to fetch executable, application, short name\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#website\"},\"datePublished\":\"2013-09-30T06:11:07+00:00\",\"dateModified\":\"2013-09-30T06:11:07+00:00\",\"description\":\"Concurrent Program Query to fetch Concurrent Program Name, short name, application, executable, execution method, execution file, enable trace flag\",\"breadcrumb\":{\"@id\":\"https:\/\/erpschools.com\/erps\/scripts\/sysadmin-aol\/concurrent-program-details-name-short-name-executable-execution-method-trace#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/erpschools.com\/erps\/scripts\/sysadmin-aol\/concurrent-program-details-name-short-name-executable-execution-method-trace\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/erpschools.com\/erps\/scripts\/sysadmin-aol\/concurrent-program-details-name-short-name-executable-execution-method-trace#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/erpschools.com\/erps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Concurrent Program Details: Name, Short name, Executable, Execution method, Trace\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/erpschools.com\/erps\/#website\",\"url\":\"https:\/\/erpschools.com\/erps\/\",\"name\":\"erpSchools\",\"description\":\"Oracle Apps\",\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/erpschools.com\/erps\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\",\"name\":\"erpSchools\",\"url\":\"https:\/\/erpschools.com\/erps\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png\",\"contentUrl\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png\",\"width\":250,\"height\":60,\"caption\":\"erpSchools\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/facebook.com\/erpschools\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512\",\"name\":\"Prudhvi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g\",\"caption\":\"Prudhvi\"},\"sameAs\":[\"http:\/\/www.erpschools.com\"],\"url\":\"https:\/\/erpschools.com\/erps\/author\/prudhvi\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Concurrent Program Query to fetch executable, application, short name","description":"Concurrent Program Query to fetch Concurrent Program Name, short name, application, executable, execution method, execution file, enable trace flag","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/erpschools.com\/erps\/scripts\/sysadmin-aol\/concurrent-program-details-name-short-name-executable-execution-method-trace","twitter_misc":{"Written by":"Prudhvi","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/erpschools.com\/erps\/scripts\/sysadmin-aol\/concurrent-program-details-name-short-name-executable-execution-method-trace#article","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/scripts\/sysadmin-aol\/concurrent-program-details-name-short-name-executable-execution-method-trace"},"author":{"name":"Prudhvi","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512"},"headline":"Concurrent Program Details: Name, Short name, Executable, Execution method, Trace","datePublished":"2013-09-30T06:11:07+00:00","dateModified":"2013-09-30T06:11:07+00:00","mainEntityOfPage":{"@id":"https:\/\/erpschools.com\/erps\/scripts\/sysadmin-aol\/concurrent-program-details-name-short-name-executable-execution-method-trace"},"wordCount":43,"commentCount":0,"publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"keywords":["concurrent program script"],"articleSection":["Sysadmin and AOL Scripts"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/erpschools.com\/erps\/scripts\/sysadmin-aol\/concurrent-program-details-name-short-name-executable-execution-method-trace#respond"]}]},{"@type":"WebPage","@id":"https:\/\/erpschools.com\/erps\/scripts\/sysadmin-aol\/concurrent-program-details-name-short-name-executable-execution-method-trace","url":"https:\/\/erpschools.com\/erps\/scripts\/sysadmin-aol\/concurrent-program-details-name-short-name-executable-execution-method-trace","name":"Concurrent Program Query to fetch executable, application, short name","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/#website"},"datePublished":"2013-09-30T06:11:07+00:00","dateModified":"2013-09-30T06:11:07+00:00","description":"Concurrent Program Query to fetch Concurrent Program Name, short name, application, executable, execution method, execution file, enable trace flag","breadcrumb":{"@id":"https:\/\/erpschools.com\/erps\/scripts\/sysadmin-aol\/concurrent-program-details-name-short-name-executable-execution-method-trace#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/erpschools.com\/erps\/scripts\/sysadmin-aol\/concurrent-program-details-name-short-name-executable-execution-method-trace"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/erpschools.com\/erps\/scripts\/sysadmin-aol\/concurrent-program-details-name-short-name-executable-execution-method-trace#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/erpschools.com\/erps"},{"@type":"ListItem","position":2,"name":"Concurrent Program Details: Name, Short name, Executable, Execution method, Trace"}]},{"@type":"WebSite","@id":"https:\/\/erpschools.com\/erps\/#website","url":"https:\/\/erpschools.com\/erps\/","name":"erpSchools","description":"Oracle Apps","publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/erpschools.com\/erps\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/erpschools.com\/erps\/#organization","name":"erpSchools","url":"https:\/\/erpschools.com\/erps\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/","url":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png","contentUrl":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png","width":250,"height":60,"caption":"erpSchools"},"image":{"@id":"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/facebook.com\/erpschools"]},{"@type":"Person","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512","name":"Prudhvi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g","caption":"Prudhvi"},"sameAs":["http:\/\/www.erpschools.com"],"url":"https:\/\/erpschools.com\/erps\/author\/prudhvi"}]}},"_links":{"self":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/4094","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/comments?post=4094"}],"version-history":[{"count":0,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/4094\/revisions"}],"wp:attachment":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/media?parent=4094"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/categories?post=4094"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/tags?post=4094"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}