DBA Data[Home] [Help]

APPS.FND_DATA_SECURITY dependencies on FND_RESPONSIBILITY_VL

Line 6193: from fnd_compiled_menu_functions fcmf, fnd_responsibility_vl fr,FU_FURG, PROMPT1,NFT

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'

Line 6237: from fnd_compiled_menu_functions fcmf, fnd_responsibility_vl fr,FU_FURG

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