eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ENG_ECO_PVT dependencies on FND_MENUS

Line 13958: fnd_menus_tl tl,

13954: v_assignee_type IN VARCHAR)
13955: IS
13956: SELECT fg.grantee_orig_system_id
13957: FROM fnd_grants fg,
13958: fnd_menus_tl tl,
13959: fnd_menus m,
13960: (SELECT distinct f.object_id,
13961: e.menu_id
13962: FROM fnd_form_functions f,

Line 13959: fnd_menus m,

13955: IS
13956: SELECT fg.grantee_orig_system_id
13957: FROM fnd_grants fg,
13958: fnd_menus_tl tl,
13959: fnd_menus m,
13960: (SELECT distinct f.object_id,
13961: e.menu_id
13962: FROM fnd_form_functions f,
13963: fnd_menu_entries e

Line 16795: fnd_menus granted_menu,

16791: grants.ROWID as row_id,
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

Line 16797: fnd_menus_tl menutl

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'
16801: AND NVL(grants.end_date, SYSDATE + 1) >= TRUNC(SYSDATE)

Line 16840: fnd_menus granted_menu,

16836: grants.ROWID as row_id,
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

Line 16842: fnd_menus_tl menutl

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'
16846: AND NVL(grants.end_date, SYSDATE + 1) >= TRUNC(SYSDATE)

Line 16881: fnd_menus granted_menu,

16877: grants.ROWID as row_id,
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

Line 16883: fnd_menus_tl menutl

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'
16887: AND TO_NUMBER(REPLACE(grants.grantee_key, 'HZ_GROUP:', '')) =

Line 16928: fnd_menus granted_menu,

16924: grants.ROWID as row_id,
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

Line 16930: fnd_menus_tl menutl

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'
16934: AND TO_NUMBER(REPLACE(grants.grantee_key, 'HZ_GROUP:', '')) =

Line 16971: fnd_menus granted_menu,

16967: grants.ROWID as row_id,
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

Line 16973: fnd_menus_tl menutl

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'
16977: AND TO_NUMBER(REPLACE(grants.grantee_key, 'HZ_PARTY:', '')) =

Line 17018: fnd_menus granted_menu,

17014: grants.ROWID as row_id,
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

Line 17020: fnd_menus_tl menutl

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'
17024: AND TO_NUMBER(REPLACE(grants.grantee_key, 'HZ_PARTY:', '')) =

Line 17061: fnd_menus granted_menu,

17057: grants.ROWID as row_id,
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

Line 17063: fnd_menus_tl menutl

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'
17067: AND NVL(grants.end_date, SYSDATE + 1) >= TRUNC(SYSDATE)

Line 17108: fnd_menus granted_menu,

17104: grants.ROWID as row_id,
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

Line 17110: fnd_menus_tl menutl

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'
17114: AND NVL(grants.end_date, SYSDATE + 1) >= TRUNC(SYSDATE)

Line 17139: fnd_menus_vl menus,

17135: lookup.change_mgmt_type_code CHANGE_MGMT_TYPE,
17136: lookup.name CHANGE_MGMT_TYPE_NAME,
17137: 'ENG_CHANGE'
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

Line 17293: from fnd_menus

17289: ---bug 13921167 start
17290: l_menu_id := cr.assignee_id;
17291: select count(1)
17292: into l_row_count
17293: from fnd_menus
17294: where menu_id = l_menu_id;
17295:
17296: if (l_row_count > 0) then
17297: select menu_name

Line 17299: from fnd_menus

17295:
17296: if (l_row_count > 0) then
17297: select menu_name
17298: into l_menu_name
17299: from fnd_menus
17300: where menu_id = l_menu_id;
17301: else
17302: l_menu_name := null;
17303: end if;