APPS.FND_DATA_SECURITY dependencies on FND_MENU_ENTRIES_VL

Line 6145: from fnd_menu_entries_vl

6141: ) ,
6142: FMEV_EXT AS
6143: (
6144: select /*+materialize */ distinct menu_id,entry_sequence
6145: from fnd_menu_entries_vl
6146: where sub_menu_id is NOT NULL
6147: and prompt is NULL
6148: ) ,
6149: PROMPT1 AS

Line 6153: from (select * from fnd_menu_entries_vl where (menu_id,entry_sequence) not in (select /*+ HASH_FMEV_EXT */ menu_id, entry_sequence

6149: PROMPT1 AS
6150: (
6151: select /*+ leading(fmev) index(fmev) use_hash(base) */ base.menu_path, base.function_id, fmev.menu_id, base.prompt1 prompt
6152: from (select sys_connect_by_path(menu_id,'/')||'/'||nvl(function_id,-1) menu_path, menu_id, entry_sequence, nvl(sub_menu_id,-1) sub_menu_id, nvl(function_id,-1) function_id, sys_connect_by_path(prompt,':->') prompt1
6153: from (select * from fnd_menu_entries_vl where (menu_id,entry_sequence) not in (select /*+ HASH_FMEV_EXT */ menu_id, entry_sequence
6154: from FMEV_EXT
6155: where menu_id IS NOT NULL and entry_sequence IS NOT NULL))fmev
6156: connect by prior SUB_MENU_ID = MENU_ID
6157: start with MENU_ID in (select fr.menu_id from fnd_responsibility fr, fu_furg where fu_furg.responsibility_id=fr.responsibility_id and fu_furg.responsibility_application_id=fr.application_id)