DBA Data[Home] [Help]

APPS.ENG_ECO_PVT dependencies on FND_OBJECTS

Line 13965: fnd_objects o

13961: e.menu_id
13962: FROM fnd_form_functions f,
13963: fnd_menu_entries e
13964: WHERE e.function_id = f.function_id) r,
13965: fnd_objects o
13966: WHERE fg.grantee_orig_system='HZ_PARTY'
13967: AND fg.grantee_type = 'USER'
13968: AND fg.menu_id = tl.menu_id
13969: AND fg.object_id = o.object_id

Line 16796: fnd_objects obj,

16792: LTRIM(grantee_global.party_name, '* ') as decoded_party_name
16793: FROM fnd_grants grants,
16794: hz_parties grantee_global,
16795: fnd_menus granted_menu,
16796: fnd_objects obj,
16797: fnd_menus_tl menutl
16798: WHERE obj.obj_name = 'EGO_ITEM'
16799: AND grants.object_id = obj.object_id
16800: AND grants.grantee_type = 'GLOBAL'

Line 16841: fnd_objects obj,

16837: LTRIM(grantee_global.party_name, '* ') as decoded_party_name
16838: FROM fnd_grants grants,
16839: hz_parties grantee_global,
16840: fnd_menus granted_menu,
16841: fnd_objects obj,
16842: fnd_menus_tl menutl
16843: WHERE obj.obj_name = 'EGO_ITEM'
16844: AND grants.object_id = obj.object_id
16845: AND grants.grantee_type = 'GLOBAL'

Line 16882: fnd_objects obj,

16878: grantee_group.group_name as decoded_party_name
16879: FROM fnd_grants grants,
16880: ego_groups_v grantee_group,
16881: fnd_menus granted_menu,
16882: fnd_objects obj,
16883: fnd_menus_tl menutl
16884: WHERE obj.obj_name = 'EGO_ITEM'
16885: AND grants.object_id = obj.object_id
16886: AND grants.grantee_type = 'GROUP'

Line 16929: fnd_objects obj,

16925: grantee_group.group_name decoded_party_name
16926: FROM fnd_grants grants,
16927: ego_groups_v grantee_group,
16928: fnd_menus granted_menu,
16929: fnd_objects obj,
16930: fnd_menus_tl menutl
16931: WHERE obj.obj_name = 'EGO_ITEM'
16932: AND grants.object_id = obj.object_id
16933: AND grants.grantee_type = 'GROUP'

Line 16972: fnd_objects obj,

16968: LTRIM(grantee_person.person_name, '* ') as decoded_party_name
16969: FROM fnd_grants grants,
16970: ego_person_company_v grantee_person,
16971: fnd_menus granted_menu,
16972: fnd_objects obj,
16973: fnd_menus_tl menutl
16974: WHERE obj.obj_name = 'EGO_ITEM'
16975: AND grants.object_id = obj.object_id
16976: AND grants.grantee_type = 'USER'

Line 17019: fnd_objects obj,

17015: LTRIM(grantee_person.person_name, '* ') as decoded_party_name
17016: FROM fnd_grants grants,
17017: ego_person_company_v grantee_person,
17018: fnd_menus granted_menu,
17019: fnd_objects obj,
17020: fnd_menus_tl menutl
17021: WHERE obj.obj_name = 'EGO_ITEM'
17022: AND grants.object_id = obj.object_id
17023: AND grants.grantee_type = 'USER'

Line 17062: fnd_objects obj,

17058: grantee_company.company_name decoded_party_name
17059: FROM fnd_grants grants,
17060: ego_companies_v grantee_company,
17061: fnd_menus granted_menu,
17062: fnd_objects obj,
17063: fnd_menus_tl menutl
17064: WHERE obj.obj_name = 'EGO_ITEM'
17065: AND grants.object_id = obj.object_id
17066: AND grants.grantee_type = 'COMPANY'

Line 17109: fnd_objects obj,

17105: grantee_company.company_name decoded_party_name
17106: FROM fnd_grants grants,
17107: ego_companies_v grantee_company,
17108: fnd_menus granted_menu,
17109: fnd_objects obj,
17110: fnd_menus_tl menutl
17111: WHERE obj.obj_name = 'EGO_ITEM'
17112: AND grants.object_id = obj.object_id
17113: AND grants.grantee_type = 'COMPANY'

Line 17142: fnd_objects fo

17138: FROM EGO_OBJ_ROLE_MAPPINGS map,
17139: fnd_menus_vl menus,
17140: eng_change_mgmt_types_vl lookup,
17141: fnd_menu_entries e,
17142: fnd_objects fo
17143: WHERE menus.menu_id(+) = map.child_role_id
17144: AND e.menu_id(+) = menus.menu_id
17145: AND map.CHILD_OBJECT_TYPE(+) = lookup.change_mgmt_type_code
17146: AND lookup.disable_flag = 'N'