[Home] [Help]
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)
6158: ) base,
6159: fnd_menu_entries_tl fmev
6160: where base.menu_id=fmev.menu_id
6161: and base.entry_sequence=fmev.entry_sequence
6189: U.function_id,U.responsibility_name,U.responsibility_id, U.application_id, U.security_group_id, U.menu_id,U.prompt
6190: from
6191: (select /*+ use_hash(prompt1) swap_join_inputs(prompt1) */ fcmf.function_id,fr.responsibility_name,
6192: fr.responsibility_id, fr.application_id, fu_furg.security_group_id, prompt1.menu_id, prompt1.prompt
6193: from fnd_compiled_menu_functions fcmf, fnd_responsibility_vl fr,FU_FURG, PROMPT1,NFT
6194: where fu_furg.responsibility_id=fr.responsibility_id
6195: and fu_furg.responsibility_application_id=fr.application_id
6196: and fcmf.menu_id=fr.menu_id
6197: and fcmf.grant_flag='Y'
6233: where GRANTS.menu_id = fcmf_in.menu_id
6234: ) GRANTS_FN,
6235: (select /*+ no_merge */ distinct
6236: fcmf.function_id,fr.responsibility_name,fr.responsibility_id,fr.application_id, fu_furg.security_group_id, fr.menu_id
6237: from fnd_compiled_menu_functions fcmf, fnd_responsibility_vl fr,FU_FURG
6238: where fu_furg.responsibility_id=fr.responsibility_id
6239: and fu_furg.responsibility_application_id=fr.application_id
6240: and fcmf.menu_id=fr.menu_id
6241: ) FLAT, prompt1, NFT