{"id":1299,"date":"2018-05-14T11:03:31","date_gmt":"2018-05-14T03:03:31","guid":{"rendered":"http:\/\/www.oracle.name\/?p=1299"},"modified":"2018-05-14T11:04:13","modified_gmt":"2018-05-14T03:04:13","slug":"%e5%b9%b6%e5%8f%91%e7%a8%8b%e5%ba%8f%e4%b8%8e%e6%a8%a1%e6%9d%bf%e7%9a%84%e5%85%b3%e7%b3%bbsql","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=1299","title":{"rendered":"\u5e76\u53d1\u7a0b\u5e8f\u4e0e\u6a21\u677f\u7684\u5173\u7cfbSQL"},"content":{"rendered":"<p>\n\t&#8211;\u5e76\u53d1\u7a0b\u5e8f\u4e0e\u6a21\u677f\u7684\u5173\u7cfb<br \/>\n\tSELECT FC.USER_CONCURRENT_PROGRAM_NAME,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;FC.DESCRIPTION,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;FC.CONCURRENT_PROGRAM_NAME,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;UPPER(FE.EXECUTION_FILE_NAME),<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;XTV.DEFAULT_OUTPUT_TYPE,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;FC.OUTPUT_FILE_TYPE<br \/>\n\t&nbsp; FROM FND_CONCURRENT_PROGRAMS_VL FC,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;FND_EXECUTABLES_FORM_V &nbsp; &nbsp; FE,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;FND_APPLICATION &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FA,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;XDO_TEMPLATES_VL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; XTV<br \/>\n\t&nbsp;WHERE 1 = 1<br \/>\n\t&nbsp; &nbsp;AND XTV.TEMPLATE_CODE = FC.CONCURRENT_PROGRAM_NAME<br \/>\n\t&nbsp; &nbsp;AND XTV.APPLICATION_SHORT_NAME = FA.APPLICATION_SHORT_NAME<br \/>\n\t&nbsp; &nbsp;AND FA.APPLICATION_ID = FC.APPLICATION_ID<br \/>\n\t&nbsp; &nbsp;AND FC.CONCURRENT_PROGRAM_NAME = FE.EXECUTABLE_NAME<br \/>\n\t&nbsp; &nbsp;AND FC.ENABLED_FLAG = &#39;Y&#39;<br \/>\n\t&nbsp; &nbsp;&#8211;AND FA.APPLICATION_SHORT_NAME = &#39;CUX&#39;<br \/>\n\t&nbsp; &nbsp;&#8211;AND FC.USER_CONCURRENT_PROGRAM_NAME = &#39;CUX:\u8d26\u6237\u4f59\u989d\u8868&#39;<br \/>\n\t&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8211;\u5e76\u53d1\u7a0b\u5e8f\u4e0e\u6a21\u677f\u7684\u5173\u7cfb SELECT FC.USER_CONCURRENT_PROGRAM_NAM &hellip; <a href=\"https:\/\/www.llku.com\/?p=1299\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb<span class=\"screen-reader-text\">\u5e76\u53d1\u7a0b\u5e8f\u4e0e\u6a21\u677f\u7684\u5173\u7cfbSQL<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[19],"tags":[219],"_links":{"self":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1299"}],"collection":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1299"}],"version-history":[{"count":2,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1299\/revisions"}],"predecessor-version":[{"id":1301,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1299\/revisions\/1301"}],"wp:attachment":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1299"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1299"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1299"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}