{"id":15775,"date":"2017-12-13T14:05:34","date_gmt":"2017-12-13T16:05:34","guid":{"rendered":"http:\/\/orabr.com\/?p=15775"},"modified":"2017-12-13T14:05:34","modified_gmt":"2017-12-13T16:05:34","slug":"query-para-buscar-funcoes-forms-etc-nos-menus-do-ebs","status":"publish","type":"post","link":"https:\/\/orabr.virttus.com\/?p=15775","title":{"rendered":"QUERY PARA BUSCAR FUN\u00c7\u00d5ES\/FORMS\/ETC… NOS MENUS DO EBS"},"content":{"rendered":"

<\/p>\n

\u00a0SELECT<\/span> lvl r_lvl,<\/p>\n

\u00a0\u00a0 \u00a0 \u00a0 \u00a0 rownumber rw_num,<\/p>\n

\u00a0\u00a0 \u00a0 \u00a0 \u00a0 entry_sequence seq,<\/p>\n

\u00a0\u00a0 \u00a0 \u00a0 \u00a0 (lvl || ‘.’<\/span> || rownumber || ‘.’<\/span> || entry_sequence) menu_seq,<\/p>\n

\u00a0\u00a0 \u00a0 \u00a0 \u00a0 menu_name,<\/p>\n

\u00a0\u00a0 \u00a0 \u00a0 \u00a0 sub_menu_name,<\/p>\n

\u00a0\u00a0 \u00a0 \u00a0 \u00a0 prompt,<\/p>\n

\u00a0\u00a0 \u00a0 \u00a0 \u00a0 fm.description,<\/p>\n

\u00a0\u00a0 \u00a0 \u00a0 \u00a0 TYPE<\/span>,<\/p>\n

\u00a0\u00a0 \u00a0 \u00a0 \u00a0 function_name,<\/p>\n

\u00a0\u00a0 \u00a0 \u00a0 \u00a0 user_function_name,<\/p>\n

\u00a0\u00a0 \u00a0 \u00a0 \u00a0 fff.description form_description<\/p>\n

\u00a0 \u00a0 FROM<\/span> (\u00a0 \u00a0 SELECT<\/span> LEVEL<\/span> lvl,<\/p>\n

\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ROW_NUMBER ()<\/p>\n

\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 OVER<\/span> (PARTITION<\/span> BY<\/span> LEVEL<\/span>, menu_id, entry_sequence<\/p>\n

\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ORDER<\/span> BY<\/span> entry_sequence)<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 AS<\/span> rownumber,<\/p>\n

\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 entry_sequence,<\/p>\n

\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 (SELECT<\/span> user_menu_name<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 FROM<\/span> fnd_menus_vl fmvl<\/p>\n

\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 WHERE<\/span> 1<\/span> = 1<\/span> AND<\/span> fmvl.menu_id = fmv.menu_id)<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 menu_name,<\/p>\n

\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 (SELECT<\/span> user_menu_name<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 FROM<\/span> fnd_menus_vl fmvl<\/p>\n

\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 WHERE<\/span> 1<\/span> = 1<\/span> AND<\/span> fmvl.menu_id = fmv.sub_menu_id)<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 sub_menu_name,<\/p>\n

\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 function_id,<\/p>\n

\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 prompt,<\/p>\n

\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 description<\/span><\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 FROM<\/span> apps.fnd_menu_entries_vl fmv<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 START<\/span> WITH<\/span> menu_id =<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 (SELECT<\/span> menu_id<\/p>\n

\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 FROM<\/span> apps.fnd_responsibility_vl<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 WHERE<\/span> UPPER<\/span> (responsibility_name) =<\/p>\n

\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 UPPER<\/span> (‘NOME_DA_RESPONSABILIDADE’<\/span>))<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 CONNECT<\/span> BY<\/span> PRIOR<\/span> sub_menu_id = menu_id) fm,<\/p>\n

\u00a0\u00a0 \u00a0 \u00a0 \u00a0 apps.fnd_form_functions_vl fff<\/p>\n

\u00a0\u00a0 WHERE<\/span> fff.function_id(+) = fm.function_id<\/p>\n

ORDER<\/span> BY<\/span> lvl, entry_sequence<\/p>\n

\u00a0<\/p>\n

<\/HTML><\/HTML><\/p>\n","protected":false},"excerpt":{"rendered":"

\u00a0SELECT lvl r_lvl, \u00a0\u00a0 \u00a0 \u00a0 \u00a0 rownumber rw_num, \u00a0\u00a0 \u00a0 \u00a0 \u00a0 entry_sequence seq, \u00a0\u00a0 \u00a0 \u00a0 \u00a0 (lvl || ‘.’ || rownumber ||… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29,124,138],"tags":[],"class_list":["post-15775","post","type-post","status-publish","format-standard","hentry","category-base-de-conhecimentos","category-database","category-sql"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/15775","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=15775"}],"version-history":[{"count":0,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/15775\/revisions"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=15775"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=15775"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=15775"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}