{"id":1175,"date":"2018-01-16T16:53:56","date_gmt":"2018-01-16T08:53:56","guid":{"rendered":"http:\/\/www.oracle.name\/?p=1175"},"modified":"2018-01-16T16:54:30","modified_gmt":"2018-01-16T08:54:30","slug":"oracle-ebs-%e6%9f%a5%e7%9c%8b%e8%8f%9c%e5%8d%95%e5%b1%95%e5%bc%80%e9%a1%b9%e7%9b%ae","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=1175","title":{"rendered":"Oracle ebs \u67e5\u770b\u83dc\u5355\u5c55\u5f00\u9879"},"content":{"rendered":"<p>\n\tSELECT LPAD(&#39; &#39;, 6 * (LEVEL &#8211; 1)) || menu_entry.entry_sequence sequence,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;LPAD(&#39; &#39;, 6 * (LEVEL &#8211; 1)) || menu.user_menu_name SubMenu_Descrition,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;LPAD(&#39; &#39;, 6 * (LEVEL &#8211; 1)) || func.user_function_name Function_Description,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;menu.menu_id,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;func.function_id,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;menu_entry.grant_flag Grant_Flag,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;DECODE(menu_entry.sub_menu_id,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; null,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &#39;FUNCTION&#39;,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DECODE(menu_entry.function_id, null, &#39;SUBMENU&#39;, &#39;BOTH&#39;)) Type<br \/>\n\t&nbsp; FROM fnd_menu_entries &nbsp; &nbsp; &nbsp;menu_entry,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;fnd_menus_vl &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;menu,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;fnd_form_functions_vl func<br \/>\n\t&nbsp;WHERE 1 = 1<br \/>\n\t&nbsp; &nbsp;AND menu_entry.sub_menu_id = menu.menu_id(+)<br \/>\n\t&nbsp; &nbsp;AND menu_entry.function_id = func.function_id(+)<br \/>\n\t&nbsp; &nbsp;AND grant_flag = &#39;Y&#39;<br \/>\n\t&nbsp;START WITH menu_entry.menu_id =<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (SELECT menu_id<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FROM fnd_menus_tl menu2<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WHERE menu2.user_menu_name = &#39;FIN_GL_MANAGER&#39;&#8211;\u6839\u636e\u81ea\u5df1\u5b9e\u9645\u60c5\u51b5\u66ff\u6362<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; and menu2.language = &#39;ZHS&#39;)<br \/>\n\tCONNECT BY menu_entry.menu_id = PRIOR menu_entry.sub_menu_id<br \/>\n\t&nbsp;ORDER SIBLINGS BY menu_entry.entry_sequence;<br \/>\n\t&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SELECT LPAD(&#39; &#39;, 6 * (LEVEL &#8211; 1)) || menu &hellip; <a href=\"https:\/\/www.llku.com\/?p=1175\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb<span class=\"screen-reader-text\">Oracle ebs \u67e5\u770b\u83dc\u5355\u5c55\u5f00\u9879<\/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":[5],"tags":[189],"_links":{"self":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1175"}],"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=1175"}],"version-history":[{"count":2,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1175\/revisions"}],"predecessor-version":[{"id":1177,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1175\/revisions\/1177"}],"wp:attachment":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1175"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1175"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1175"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}