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.EGO_DOM_SECURITY_PVT dependencies on HZ_PARTIES

Line 117: FROM hz_parties parties,

113: grantee_type,
114: role_name,
115: role_display_name,
116: menu_id
117: FROM hz_parties parties,
118: (
119: SELECT DISTINCT
120: GRANTS.grantee_orig_system_id grantee_orig_system_id,
121: DECODE(grants.grantee_key,'GLOBAL','HZ_GLOBAL', SUBSTR(grants.grantee_key,0, INSTR(grants.grantee_key,':',1,1)-1)) grantee_orig_system,

Line 328: 'hz_parties grantee_person, ' ||

324: 'grantee_person_company.party_name company_name, ' ||
325: 'trunc(grants.start_date) start_date , ' ||
326: 'trunc(grants.end_date) end_date ' ||
327: 'FROM fnd_grants grants, ' ||
328: 'hz_parties grantee_person, ' ||
329: 'hz_parties grantee_person_company, ' ||
330: 'hz_relationships grantee_person_company_rel, ' ||
331: 'fnd_menus_tl granted_menu, ' ||
332: 'fnd_menus granted_menu_data, ' ||

Line 329: 'hz_parties grantee_person_company, ' ||

325: 'trunc(grants.start_date) start_date , ' ||
326: 'trunc(grants.end_date) end_date ' ||
327: 'FROM fnd_grants grants, ' ||
328: 'hz_parties grantee_person, ' ||
329: 'hz_parties grantee_person_company, ' ||
330: 'hz_relationships grantee_person_company_rel, ' ||
331: 'fnd_menus_tl granted_menu, ' ||
332: 'fnd_menus granted_menu_data, ' ||
333: 'fnd_objects obj ' ||

Line 339: 'AND grantee_person_company_rel.subject_table_name (+) = ''HZ_PARTIES'' ' ||

335: 'AND grants.grantee_type = ''USER'' ' ||
336: 'AND grantee_person.status = ''A'' ' ||
337: 'AND grantee_person.party_type = ''PERSON'' ' ||
338: 'AND grantee_person_company_rel.subject_type (+) = ''PERSON'' ' ||
339: 'AND grantee_person_company_rel.subject_table_name (+) = ''HZ_PARTIES'' ' ||
340: 'AND grantee_person_company_rel.object_table_name (+) = ''HZ_PARTIES'' ' ||
341: 'AND grantee_person.party_id (+) = grantee_person_company_rel.subject_id ' ||
342: 'AND grantee_person_company_rel.relationship_code(+) = ''EMPLOYEE_OF'' ' ||
343: 'AND grantee_person_company_rel.status(+) = ''A'' ' ||

Line 340: 'AND grantee_person_company_rel.object_table_name (+) = ''HZ_PARTIES'' ' ||

336: 'AND grantee_person.status = ''A'' ' ||
337: 'AND grantee_person.party_type = ''PERSON'' ' ||
338: 'AND grantee_person_company_rel.subject_type (+) = ''PERSON'' ' ||
339: 'AND grantee_person_company_rel.subject_table_name (+) = ''HZ_PARTIES'' ' ||
340: 'AND grantee_person_company_rel.object_table_name (+) = ''HZ_PARTIES'' ' ||
341: 'AND grantee_person.party_id (+) = grantee_person_company_rel.subject_id ' ||
342: 'AND grantee_person_company_rel.relationship_code(+) = ''EMPLOYEE_OF'' ' ||
343: 'AND grantee_person_company_rel.status(+) = ''A'' ' ||
344: 'AND grantee_person_company_rel.start_date(+) <= SYSDATE ' ||

Line 408: 'hz_parties grantee_group, ' ||

404: 'null company_name, ' ||
405: 'trunc(grants.start_date) start_date , ' ||
406: 'trunc(grants.end_date) end_date ' ||
407: 'FROM fnd_grants grants, ' ||
408: 'hz_parties grantee_group, ' ||
409: 'fnd_menus_tl granted_menu, ' ||
410: 'fnd_menus granted_menu_data, ' ||
411: 'fnd_objects obj ' ||
412: 'WHERE grants.object_id = obj.object_id ' ||

Line 491: 'hz_parties grantee_company, ' ||

487: 'grantee_company.party_name company_name, ' ||
488: 'trunc(grants.start_date) start_date , ' ||
489: 'trunc(grants.end_date) end_date ' ||
490: 'FROM fnd_grants grants, ' ||
491: 'hz_parties grantee_company, ' ||
492: 'fnd_menus_tl granted_menu, ' ||
493: 'fnd_menus granted_menu_data, ' ||
494: 'fnd_objects obj ' ||
495: 'WHERE grants.object_id = obj.object_id ' ||

Line 544: 'hz_parties grantee_global, ' ||

540: 'null company_name, ' ||
541: 'trunc(grants.start_date) start_date, ' ||
542: 'trunc(grants.end_date) end_date ' ||
543: 'FROM fnd_grants grants, ' ||
544: 'hz_parties grantee_global, ' ||
545: 'fnd_menus_tl granted_menu, ' ||
546: 'fnd_menus granted_menu_data, ' ||
547: 'fnd_objects obj ' ||
548: 'WHERE grants.object_id = obj.object_id ' ||

Line 581: ' hz_parties grantee_person, ' ||

577: ' trunc(grants.end_date) end_date ' ||
578: ' FROM fnd_grants grants, ' ||
579: ' fnd_menus granted_menu, ' ||
580: ' fnd_objects obj, ' ||
581: ' hz_parties grantee_person, ' ||
582: ' fnd_menus_tl granted_menu_tl ' ||
583: ' WHERE granted_menu.menu_id = grants.menu_id ' ||
584: ' AND grants.instance_type = ''SET'' AND grants.instance_pk1_value = ''*NULL*''' ||
585: ' AND grants.instance_set_id IN ( select instance_set.instance_set_id ' ||

Line 629: ' hz_parties member , ' ||

625: ' FROM ' ||
626: ' fnd_grants grants , ' ||
627: ' fnd_menus granted_menu, ' ||
628: ' fnd_objects obj , ' ||
629: ' hz_parties member , ' ||
630: ' hz_relationships member_group , ' ||
631: ' hz_parties grantee_group, ' ||
632: ' fnd_menus_tl granted_menu_tl ' ||
633: ' WHERE grants.menu_id = granted_menu.menu_id ' ||

Line 631: ' hz_parties grantee_group, ' ||

627: ' fnd_menus granted_menu, ' ||
628: ' fnd_objects obj , ' ||
629: ' hz_parties member , ' ||
630: ' hz_relationships member_group , ' ||
631: ' hz_parties grantee_group, ' ||
632: ' fnd_menus_tl granted_menu_tl ' ||
633: ' WHERE grants.menu_id = granted_menu.menu_id ' ||
634: ' AND grants.instance_type= ''SET'' AND grants.instance_pk1_value = ''*NULL*'' AND ' ||
635: ' grants.instance_set_id IN ( select instance_set.instance_set_id from ' ||