{"id":895,"date":"2016-10-19T16:10:46","date_gmt":"2016-10-19T08:10:46","guid":{"rendered":"http:\/\/www.oracle.name\/?p=895"},"modified":"2016-10-19T16:10:46","modified_gmt":"2016-10-19T08:10:46","slug":"ebs%e5%b9%b6%e5%8f%91%e7%a8%8b%e5%ba%8f%e7%9b%b8%e5%85%b3sql","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=895","title":{"rendered":"EBS\u5e76\u53d1\u7a0b\u5e8f\u76f8\u5173SQL"},"content":{"rendered":"<p>\n\t&#8211;\u6240\u6709\u5ba2\u6237\u5316\u5e76\u53d1\u7a0b\u5e8f<br \/>\n\tSELECT FC.USER_CONCURRENT_PROGRAM_NAME,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FC.DESCRIPTION,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FC.CONCURRENT_PROGRAM_NAME,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; UPPER(FE.EXECUTION_FILE_NAME)<br \/>\n\t&nbsp; FROM FND_CONCURRENT_PROGRAMS_VL FC,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FND_EXECUTABLES_FORM_V&nbsp;&nbsp;&nbsp;&nbsp; FE,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FND_APPLICATION&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FA<br \/>\n\t&nbsp;WHERE 1 = 1<br \/>\n\t&nbsp;&nbsp; AND FA.APPLICATION_ID = FC.APPLICATION_ID<br \/>\n\t&nbsp;&nbsp; AND FA.APPLICATION_SHORT_NAME = &#39;CUX&#39;<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;ORDER BY FC.CREATION_DATE DESC;\n<\/p>\n<p>\n\t&#8211;\u5e76\u53d1\u7a0b\u5e8f\u5bf9\u5e94\u53c2\u6570<br \/>\n\tSELECT FV.COLUMN_SEQ_NUM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \u5e8f\u53f7,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FV.END_USER_COLUMN_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \u53c2\u6570,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FV.DESCRIPTIVE_FLEXFIELD_NAME&nbsp;&nbsp;&nbsp; \u53ef\u6267\u884c\u7a0b\u5e8f,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FV.ENABLED_FLAG&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \u662f\u5426\u542f\u7528,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FV.DISPLAY_FLAG&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \u663e\u793a,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FFVS.FLEX_VALUE_SET_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \u503c\u96c6\u540d\u79f0,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FV.DEFAULT_TYPE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \u9ed8\u8ba4\u7c7b\u578b,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FV.DEFAULT_VALUE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \u9ed8\u8ba4\u503c,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FV.REQUIRED_FLAG&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \u5fc5\u9700,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FV.SECURITY_ENABLED_FLAG&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \u542f\u7528\u5b89\u5168\u6027,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FV.RANGE_CODE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \u8303\u56f4,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FV.DISPLAY_SIZE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \u663e\u793a\u5927\u5c0f,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FV.MAXIMUM_DESCRIPTION_LEN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \u8bf4\u660e\u5927\u5c0f,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FV.CONCATENATION_DESCRIPTION_LEN \u7ea7\u8054\u8bf4\u660e\u5927\u5c0f,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FV.FORM_ABOVE_PROMPT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \u63d0\u793a,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FV.SRW_PARAM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \u53d8\u91cf<br \/>\n\t&nbsp; FROM FND_DESCR_FLEX_COL_USAGE_VL FV, FND_FLEX_VALUE_SETS FFVS<br \/>\n\t&nbsp;WHERE FV.FLEX_VALUE_SET_ID = FFVS.FLEX_VALUE_SET_ID<br \/>\n\t&nbsp;&nbsp; AND SUBSTR(FV.DESCRIPTIVE_FLEXFIELD_NAME, 7) IN<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (SELECT FC.CONCURRENT_PROGRAM_NAME<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM FND_CONCURRENT_PROGRAMS_VL FC,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FND_EXECUTABLES_FORM_V&nbsp;&nbsp;&nbsp;&nbsp; FE,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FND_APPLICATION&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FA<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE 1 = 1<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND FA.APPLICATION_ID = FC.APPLICATION_ID<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND FA.APPLICATION_SHORT_NAME = &#39;CUX&#39;<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND FC.CONCURRENT_PROGRAM_NAME = FE.EXECUTABLE_NAME<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND FC.ENABLED_FLAG = &#39;Y&#39;)<br \/>\n\t&nbsp;ORDER BY FV.DESCRIPTIVE_FLEXFIELD_NAME, FV.COLUMN_SEQ_NUM;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8211;\u6240\u6709\u5ba2\u6237\u5316\u5e76\u53d1\u7a0b\u5e8f SELECT FC.USER_CONCURRENT_PROGRAM_NAME &hellip; <a href=\"https:\/\/www.llku.com\/?p=895\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb<span class=\"screen-reader-text\">EBS\u5e76\u53d1\u7a0b\u5e8f\u76f8\u5173SQL<\/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":[31],"tags":[134],"_links":{"self":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/895"}],"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=895"}],"version-history":[{"count":1,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/895\/revisions"}],"predecessor-version":[{"id":896,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/895\/revisions\/896"}],"wp:attachment":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=895"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=895"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}