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_CHANGE_ROLES_PUB dependencies on HZ_PARTIES

Line 129: FROM hz_parties parties,

125: grantee_type,
126: role_name,
127: role_display_name,
128: menu_id
129: FROM hz_parties parties,
130: (
131: SELECT DISTINCT
132: GRANTS.grantee_orig_system_id grantee_orig_system_id,
133: DECODE(grants.grantee_key,'GLOBAL','HZ_GLOBAL', SUBSTR(grants.grantee_key,0, INSTR(grants.grantee_key,':',1,1)-1)) grantee_orig_system,

Line 322: 'HZ_PARTIES hzei, ' ||

318: 'ltrim(nvl( hzei.party_name,nvl( hzci.party_name,nvl( hzsi.party_name,null))),''* '') grantee_name, ' ||
319: 'granted_menu_data.menu_id menu_id ' ||
320: 'FROM fnd_menus_tl granted_menu, ' ||
321: 'fnd_menus granted_menu_data, ' ||
322: 'HZ_PARTIES hzei, ' ||
323: 'HZ_PARTIES hzci, ' ||
324: 'HZ_PARTIES hzsi, ' ||
325: 'HZ_RELATIONSHIPS hzr, ' ||
326: 'HZ_PARTIES hzc, ' ||

Line 323: 'HZ_PARTIES hzci, ' ||

319: 'granted_menu_data.menu_id menu_id ' ||
320: 'FROM fnd_menus_tl granted_menu, ' ||
321: 'fnd_menus granted_menu_data, ' ||
322: 'HZ_PARTIES hzei, ' ||
323: 'HZ_PARTIES hzci, ' ||
324: 'HZ_PARTIES hzsi, ' ||
325: 'HZ_RELATIONSHIPS hzr, ' ||
326: 'HZ_PARTIES hzc, ' ||
327: '( ' ||

Line 324: 'HZ_PARTIES hzsi, ' ||

320: 'FROM fnd_menus_tl granted_menu, ' ||
321: 'fnd_menus granted_menu_data, ' ||
322: 'HZ_PARTIES hzei, ' ||
323: 'HZ_PARTIES hzci, ' ||
324: 'HZ_PARTIES hzsi, ' ||
325: 'HZ_RELATIONSHIPS hzr, ' ||
326: 'HZ_PARTIES hzc, ' ||
327: '( ' ||
328: 'SELECT ' ||

Line 326: 'HZ_PARTIES hzc, ' ||

322: 'HZ_PARTIES hzei, ' ||
323: 'HZ_PARTIES hzci, ' ||
324: 'HZ_PARTIES hzsi, ' ||
325: 'HZ_RELATIONSHIPS hzr, ' ||
326: 'HZ_PARTIES hzc, ' ||
327: '( ' ||
328: 'SELECT ' ||
329: 'C.CHANGE_ID, ' ||
330: 'P.ASSIGNEE_ID, ' ||

Line 387: 'HZ_PARTIES hzei, ' ||

383: 'ltrim(nvl( hzei.party_name,nvl( hzci.party_name,nvl( hzsi.party_name,null))),''* '') grantee_name, ' ||
384: 'granted_menu_data.menu_id menu_id ' ||
385: 'FROM fnd_menus_tl granted_menu, ' ||
386: 'fnd_menus granted_menu_data, ' ||
387: 'HZ_PARTIES hzei, ' ||
388: 'HZ_PARTIES hzci, ' ||
389: 'HZ_PARTIES hzsi, ' ||
390: 'HZ_RELATIONSHIPS hzr, ' ||
391: 'HZ_PARTIES hzc, ' ||

Line 388: 'HZ_PARTIES hzci, ' ||

384: 'granted_menu_data.menu_id menu_id ' ||
385: 'FROM fnd_menus_tl granted_menu, ' ||
386: 'fnd_menus granted_menu_data, ' ||
387: 'HZ_PARTIES hzei, ' ||
388: 'HZ_PARTIES hzci, ' ||
389: 'HZ_PARTIES hzsi, ' ||
390: 'HZ_RELATIONSHIPS hzr, ' ||
391: 'HZ_PARTIES hzc, ' ||
392: 'FND_USER fuser, ' ||

Line 389: 'HZ_PARTIES hzsi, ' ||

385: 'FROM fnd_menus_tl granted_menu, ' ||
386: 'fnd_menus granted_menu_data, ' ||
387: 'HZ_PARTIES hzei, ' ||
388: 'HZ_PARTIES hzci, ' ||
389: 'HZ_PARTIES hzsi, ' ||
390: 'HZ_RELATIONSHIPS hzr, ' ||
391: 'HZ_PARTIES hzc, ' ||
392: 'FND_USER fuser, ' ||
393: 'FND_USER fpuser, ' ||

Line 391: 'HZ_PARTIES hzc, ' ||

387: 'HZ_PARTIES hzei, ' ||
388: 'HZ_PARTIES hzci, ' ||
389: 'HZ_PARTIES hzsi, ' ||
390: 'HZ_RELATIONSHIPS hzr, ' ||
391: 'HZ_PARTIES hzc, ' ||
392: 'FND_USER fuser, ' ||
393: 'FND_USER fpuser, ' ||
394: 'ENG_ENGINEERING_CHANGES child_table_name ' ||
395: 'WHERE CHANGE_ID = ' || l_pk1_value || ' ' ||

Line 422: 'HZ_PARTIES hzei, ' ||

418: 'ltrim(nvl( hzei.party_name,nvl( hzci.party_name,nvl( hzsi.party_name,null))),''* '') grantee_name, ' ||
419: 'granted_menu_data.menu_id menu_id ' ||
420: 'FROM fnd_menus_tl granted_menu, ' ||
421: 'fnd_menus granted_menu_data, ' ||
422: 'HZ_PARTIES hzei, ' ||
423: 'HZ_PARTIES hzci, ' ||
424: 'HZ_PARTIES hzsi, ' ||
425: 'HZ_RELATIONSHIPS hzr, ' ||
426: 'HZ_PARTIES hzc, ' ||

Line 423: 'HZ_PARTIES hzci, ' ||

419: 'granted_menu_data.menu_id menu_id ' ||
420: 'FROM fnd_menus_tl granted_menu, ' ||
421: 'fnd_menus granted_menu_data, ' ||
422: 'HZ_PARTIES hzei, ' ||
423: 'HZ_PARTIES hzci, ' ||
424: 'HZ_PARTIES hzsi, ' ||
425: 'HZ_RELATIONSHIPS hzr, ' ||
426: 'HZ_PARTIES hzc, ' ||
427: 'ENG_ENGINEERING_CHANGES child_table_name ' ||

Line 424: 'HZ_PARTIES hzsi, ' ||

420: 'FROM fnd_menus_tl granted_menu, ' ||
421: 'fnd_menus granted_menu_data, ' ||
422: 'HZ_PARTIES hzei, ' ||
423: 'HZ_PARTIES hzci, ' ||
424: 'HZ_PARTIES hzsi, ' ||
425: 'HZ_RELATIONSHIPS hzr, ' ||
426: 'HZ_PARTIES hzc, ' ||
427: 'ENG_ENGINEERING_CHANGES child_table_name ' ||
428: 'WHERE CHANGE_ID = ' || l_pk1_value || ' ' ||

Line 426: 'HZ_PARTIES hzc, ' ||

422: 'HZ_PARTIES hzei, ' ||
423: 'HZ_PARTIES hzci, ' ||
424: 'HZ_PARTIES hzsi, ' ||
425: 'HZ_RELATIONSHIPS hzr, ' ||
426: 'HZ_PARTIES hzc, ' ||
427: 'ENG_ENGINEERING_CHANGES child_table_name ' ||
428: 'WHERE CHANGE_ID = ' || l_pk1_value || ' ' ||
429: 'AND child_table_name.ASSIGNEE_ID = hzei.party_id(+) ' ||
430: 'AND child_table_name.ASSIGNEE_ID = hzci.party_id(+) ' ||

Line 454: 'HZ_PARTIES grantee_group, ' ||

450: 'grantee_group.party_name grantee_name, ' ||
451: 'granted_menu_data.menu_id menu_id ' ||
452: 'FROM fnd_menus_tl granted_menu, ' ||
453: 'fnd_menus granted_menu_data, ' ||
454: 'HZ_PARTIES grantee_group, ' ||
455: 'ENG_ENGINEERING_CHANGES child_table_name ' ||
456: 'WHERE CHANGE_ID = ' || l_pk1_value || ' ' ||
457: 'AND child_table_name.ASSIGNEE_ID = grantee_group.party_id(+) ' ||
458: 'AND child_table_name.ASSIGNEE_ID IS NOT NULL ' ||

Line 476: 'HZ_PARTIES hzei, ' ||

472: 'ltrim(nvl( hzei.party_name,nvl( hzci.party_name,nvl( hzsi.party_name,null))),''* '') grantee_name, ' ||
473: 'granted_menu_data.menu_id menu_id ' ||
474: 'FROM fnd_menus_tl granted_menu, ' ||
475: 'fnd_menus granted_menu_data, ' ||
476: 'HZ_PARTIES hzei, ' ||
477: 'HZ_PARTIES hzci, ' ||
478: 'HZ_PARTIES hzsi, ' ||
479: 'HZ_RELATIONSHIPS hzr, ' ||
480: 'HZ_PARTIES hzc, ' ||

Line 477: 'HZ_PARTIES hzci, ' ||

473: 'granted_menu_data.menu_id menu_id ' ||
474: 'FROM fnd_menus_tl granted_menu, ' ||
475: 'fnd_menus granted_menu_data, ' ||
476: 'HZ_PARTIES hzei, ' ||
477: 'HZ_PARTIES hzci, ' ||
478: 'HZ_PARTIES hzsi, ' ||
479: 'HZ_RELATIONSHIPS hzr, ' ||
480: 'HZ_PARTIES hzc, ' ||
481: 'ENG_ENGINEERING_CHANGES child_table_name ' ||

Line 478: 'HZ_PARTIES hzsi, ' ||

474: 'FROM fnd_menus_tl granted_menu, ' ||
475: 'fnd_menus granted_menu_data, ' ||
476: 'HZ_PARTIES hzei, ' ||
477: 'HZ_PARTIES hzci, ' ||
478: 'HZ_PARTIES hzsi, ' ||
479: 'HZ_RELATIONSHIPS hzr, ' ||
480: 'HZ_PARTIES hzc, ' ||
481: 'ENG_ENGINEERING_CHANGES child_table_name ' ||
482: 'WHERE CHANGE_ID = ' || l_pk1_value || ' ' ||

Line 480: 'HZ_PARTIES hzc, ' ||

476: 'HZ_PARTIES hzei, ' ||
477: 'HZ_PARTIES hzci, ' ||
478: 'HZ_PARTIES hzsi, ' ||
479: 'HZ_RELATIONSHIPS hzr, ' ||
480: 'HZ_PARTIES hzc, ' ||
481: 'ENG_ENGINEERING_CHANGES child_table_name ' ||
482: 'WHERE CHANGE_ID = ' || l_pk1_value || ' ' ||
483: 'AND child_table_name.REQUESTOR_ID = hzei.party_id(+) ' ||
484: 'AND child_table_name.REQUESTOR_ID = hzci.party_id(+) ' ||

Line 508: 'HZ_PARTIES grantee_group, ' ||

504: 'grantee_group.party_name grantee_name, ' ||
505: 'granted_menu_data.menu_id menu_id ' ||
506: 'FROM fnd_menus_tl granted_menu, ' ||
507: 'fnd_menus granted_menu_data, ' ||
508: 'HZ_PARTIES grantee_group, ' ||
509: 'ENG_ENGINEERING_CHANGES child_table_name ' ||
510: 'WHERE CHANGE_ID = ' || l_pk1_value || ' ' ||
511: 'AND child_table_name.REQUESTOR_ID = grantee_group.party_id(+) ' ||
512: 'AND child_table_name.REQUESTOR_ID IS NOT NULL ' ||

Line 530: 'HZ_PARTIES hzei, ' ||

526: 'ltrim(nvl( hzei.party_name,nvl( hzci.party_name,nvl( hzsi.party_name,null))),''* '') grantee_name, ' ||
527: 'granted_menu_data.menu_id menu_id ' ||
528: 'FROM fnd_menus_tl granted_menu, ' ||
529: 'fnd_menus granted_menu_data, ' ||
530: 'HZ_PARTIES hzei, ' ||
531: 'HZ_PARTIES hzci, ' ||
532: 'HZ_PARTIES hzsi, ' ||
533: 'HZ_RELATIONSHIPS hzr, ' ||
534: 'HZ_PARTIES hzc, ' ||

Line 531: 'HZ_PARTIES hzci, ' ||

527: 'granted_menu_data.menu_id menu_id ' ||
528: 'FROM fnd_menus_tl granted_menu, ' ||
529: 'fnd_menus granted_menu_data, ' ||
530: 'HZ_PARTIES hzei, ' ||
531: 'HZ_PARTIES hzci, ' ||
532: 'HZ_PARTIES hzsi, ' ||
533: 'HZ_RELATIONSHIPS hzr, ' ||
534: 'HZ_PARTIES hzc, ' ||
535: '( ' ||

Line 532: 'HZ_PARTIES hzsi, ' ||

528: 'FROM fnd_menus_tl granted_menu, ' ||
529: 'fnd_menus granted_menu_data, ' ||
530: 'HZ_PARTIES hzei, ' ||
531: 'HZ_PARTIES hzci, ' ||
532: 'HZ_PARTIES hzsi, ' ||
533: 'HZ_RELATIONSHIPS hzr, ' ||
534: 'HZ_PARTIES hzc, ' ||
535: '( ' ||
536: 'SELECT ' ||

Line 534: 'HZ_PARTIES hzc, ' ||

530: 'HZ_PARTIES hzei, ' ||
531: 'HZ_PARTIES hzci, ' ||
532: 'HZ_PARTIES hzsi, ' ||
533: 'HZ_RELATIONSHIPS hzr, ' ||
534: 'HZ_PARTIES hzc, ' ||
535: '( ' ||
536: 'SELECT ' ||
537: 'C.CHANGE_ID, ' ||
538: 'P.ASSIGNEE_ID, ' ||

Line 595: 'HZ_PARTIES hzei, ' ||

591: 'ltrim(nvl( hzei.party_name,nvl( hzci.party_name,nvl( hzsi.party_name,null))),''* '') grantee_name, ' ||
592: 'granted_menu_data.menu_id menu_id ' ||
593: 'FROM fnd_menus_tl granted_menu, ' ||
594: 'fnd_menus granted_menu_data, ' ||
595: 'HZ_PARTIES hzei, ' ||
596: 'HZ_PARTIES hzci, ' ||
597: 'HZ_PARTIES hzsi, ' ||
598: 'HZ_RELATIONSHIPS hzr, ' ||
599: 'HZ_PARTIES hzc, ' ||

Line 596: 'HZ_PARTIES hzci, ' ||

592: 'granted_menu_data.menu_id menu_id ' ||
593: 'FROM fnd_menus_tl granted_menu, ' ||
594: 'fnd_menus granted_menu_data, ' ||
595: 'HZ_PARTIES hzei, ' ||
596: 'HZ_PARTIES hzci, ' ||
597: 'HZ_PARTIES hzsi, ' ||
598: 'HZ_RELATIONSHIPS hzr, ' ||
599: 'HZ_PARTIES hzc, ' ||
600: 'ENG_CHANGE_LINES child_table_name ' ||

Line 597: 'HZ_PARTIES hzsi, ' ||

593: 'FROM fnd_menus_tl granted_menu, ' ||
594: 'fnd_menus granted_menu_data, ' ||
595: 'HZ_PARTIES hzei, ' ||
596: 'HZ_PARTIES hzci, ' ||
597: 'HZ_PARTIES hzsi, ' ||
598: 'HZ_RELATIONSHIPS hzr, ' ||
599: 'HZ_PARTIES hzc, ' ||
600: 'ENG_CHANGE_LINES child_table_name ' ||
601: 'WHERE CHANGE_ID = ' || l_pk1_value || ' ' ||

Line 599: 'HZ_PARTIES hzc, ' ||

595: 'HZ_PARTIES hzei, ' ||
596: 'HZ_PARTIES hzci, ' ||
597: 'HZ_PARTIES hzsi, ' ||
598: 'HZ_RELATIONSHIPS hzr, ' ||
599: 'HZ_PARTIES hzc, ' ||
600: 'ENG_CHANGE_LINES child_table_name ' ||
601: 'WHERE CHANGE_ID = ' || l_pk1_value || ' ' ||
602: 'AND child_table_name.ASSIGNEE_ID = hzei.party_id(+) ' ||
603: 'AND child_table_name.ASSIGNEE_ID = hzci.party_id(+) ' ||

Line 627: 'HZ_PARTIES grantee_group, ' ||

623: 'grantee_group.party_name grantee_name, ' ||
624: 'granted_menu_data.menu_id menu_id ' ||
625: 'FROM fnd_menus_tl granted_menu, ' ||
626: 'fnd_menus granted_menu_data, ' ||
627: 'HZ_PARTIES grantee_group, ' ||
628: 'ENG_CHANGE_LINES child_table_name ' ||
629: 'WHERE CHANGE_ID = ' || l_pk1_value || ' ' ||
630: 'AND child_table_name.ASSIGNEE_ID = grantee_group.party_id(+) ' ||
631: 'AND child_table_name.ASSIGNEE_ID IS NOT NULL ' ||

Line 649: 'HZ_PARTIES hzei, ' ||

645: 'ltrim(nvl( hzei.party_name,nvl( hzci.party_name,nvl( hzsi.party_name,null))),''* '') grantee_name, ' ||
646: 'granted_menu_data.menu_id menu_id ' ||
647: 'FROM fnd_menus_tl granted_menu, ' ||
648: 'fnd_menus granted_menu_data, ' ||
649: 'HZ_PARTIES hzei, ' ||
650: 'HZ_PARTIES hzci, ' ||
651: 'HZ_PARTIES hzsi, ' ||
652: 'HZ_RELATIONSHIPS hzr, ' ||
653: 'HZ_PARTIES hzc, ' ||

Line 650: 'HZ_PARTIES hzci, ' ||

646: 'granted_menu_data.menu_id menu_id ' ||
647: 'FROM fnd_menus_tl granted_menu, ' ||
648: 'fnd_menus granted_menu_data, ' ||
649: 'HZ_PARTIES hzei, ' ||
650: 'HZ_PARTIES hzci, ' ||
651: 'HZ_PARTIES hzsi, ' ||
652: 'HZ_RELATIONSHIPS hzr, ' ||
653: 'HZ_PARTIES hzc, ' ||
654: 'ENG_ENGINEERING_CHANGES child_table_name ' ||

Line 651: 'HZ_PARTIES hzsi, ' ||

647: 'FROM fnd_menus_tl granted_menu, ' ||
648: 'fnd_menus granted_menu_data, ' ||
649: 'HZ_PARTIES hzei, ' ||
650: 'HZ_PARTIES hzci, ' ||
651: 'HZ_PARTIES hzsi, ' ||
652: 'HZ_RELATIONSHIPS hzr, ' ||
653: 'HZ_PARTIES hzc, ' ||
654: 'ENG_ENGINEERING_CHANGES child_table_name ' ||
655: 'WHERE CHANGE_ID = ' || l_pk1_value || ' ' ||

Line 653: 'HZ_PARTIES hzc, ' ||

649: 'HZ_PARTIES hzei, ' ||
650: 'HZ_PARTIES hzci, ' ||
651: 'HZ_PARTIES hzsi, ' ||
652: 'HZ_RELATIONSHIPS hzr, ' ||
653: 'HZ_PARTIES hzc, ' ||
654: 'ENG_ENGINEERING_CHANGES child_table_name ' ||
655: 'WHERE CHANGE_ID = ' || l_pk1_value || ' ' ||
656: 'AND child_table_name.ASSIGNEE_ID = hzei.party_id(+) ' ||
657: 'AND child_table_name.ASSIGNEE_ID = hzci.party_id(+) ' ||

Line 681: 'HZ_PARTIES grantee_group, ' ||

677: 'grantee_group.party_name grantee_name, ' ||
678: 'granted_menu_data.menu_id menu_id ' ||
679: 'FROM fnd_menus_tl granted_menu, ' ||
680: 'fnd_menus granted_menu_data, ' ||
681: 'HZ_PARTIES grantee_group, ' ||
682: 'ENG_ENGINEERING_CHANGES child_table_name ' ||
683: 'WHERE CHANGE_ID = ' || l_pk1_value || ' ' ||
684: 'AND child_table_name.ASSIGNEE_ID = grantee_group.party_id(+) ' ||
685: 'AND child_table_name.ASSIGNEE_ID IS NOT NULL ' ||

Line 702: 'FROM hz_parties grantee_global, ' ||

698: 'granted_menu.user_menu_name role_display_name, ' ||
699: '''COMPANY'' grantee_type, ' ||
700: 'internal_company.company_name grantee_name, ' ||
701: 'granted_menu_data.menu_id menu_id ' ||
702: 'FROM hz_parties grantee_global, ' ||
703: 'fnd_menus_tl granted_menu, ' ||
704: 'fnd_menus profile_menu_data, ' ||
705: 'fnd_menus granted_menu_data, ' ||
706: 'ego_obj_role_mappings mapping, ' ||

Line 746: 'FROM hz_parties grantee_global, ' ||

742: 'granted_menu.user_menu_name role_display_name, ' ||
743: '''COMPANY'' grantee_type, ' ||
744: 'internal_company.company_name grantee_name, ' ||
745: 'granted_menu_data.menu_id menu_id ' ||
746: 'FROM hz_parties grantee_global, ' ||
747: 'fnd_menus_tl granted_menu, ' ||
748: 'fnd_menus profile_menu_data, ' ||
749: 'fnd_menus granted_menu_data, ' ||
750: 'fnd_objects obj, ' ||

Line 798: 'HZ_PARTIES hzsi, ' ||

794: 'grants.grantee_type grantee_type, ' ||
795: 'hzsi.party_name grantee_name, ' ||
796: 'granted_menu_data.menu_id menu_id ' ||
797: 'FROM fnd_grants grants, ' ||
798: 'HZ_PARTIES hzsi, ' ||
799: 'HZ_RELATIONSHIPS hzr, ' ||
800: 'HZ_PARTIES hzc, ' ||
801: 'fnd_menus_tl granted_menu, ' ||
802: 'fnd_menus granted_menu_data, ' ||

Line 800: 'HZ_PARTIES hzc, ' ||

796: 'granted_menu_data.menu_id menu_id ' ||
797: 'FROM fnd_grants grants, ' ||
798: 'HZ_PARTIES hzsi, ' ||
799: 'HZ_RELATIONSHIPS hzr, ' ||
800: 'HZ_PARTIES hzc, ' ||
801: 'fnd_menus_tl granted_menu, ' ||
802: 'fnd_menus granted_menu_data, ' ||
803: 'ego_obj_role_mappings mapping, ' ||
804: 'fnd_objects obj,' ||

Line 866: 'HZ_PARTIES grantee_group, ' ||

862: 'grants.grantee_type grantee_type, ' ||
863: 'grantee_group.party_name grantee_name, ' ||
864: 'granted_menu_data.menu_id menu_id ' ||
865: 'FROM fnd_grants grants, ' ||
866: 'HZ_PARTIES grantee_group, ' ||
867: 'fnd_menus_tl granted_menu, ' ||
868: 'fnd_menus granted_menu_data, ' ||
869: 'ego_obj_role_mappings mapping, ' ||
870: 'fnd_objects obj , ' ||

Line 927: 'hz_parties grantee_company, ' ||

923: 'grants.grantee_type grantee_type, ' ||
924: 'grantee_company.party_name grantee_name, ' ||
925: 'granted_menu_data.menu_id menu_id ' ||
926: 'FROM fnd_grants grants, ' ||
927: 'hz_parties grantee_company, ' ||
928: 'fnd_menus_tl granted_menu, ' ||
929: 'fnd_menus granted_menu_data, ' ||
930: 'ego_obj_role_mappings mapping, ' ||
931: 'fnd_objects obj, ' ||

Line 991: 'hz_parties grantee_global, ' ||

987: 'grants.grantee_type grantee_type, ' ||
988: 'grantee_global.party_name grantee_name, ' ||
989: 'granted_menu_data.menu_id menu_id ' ||
990: 'FROM fnd_grants grants, ' ||
991: 'hz_parties grantee_global, ' ||
992: 'fnd_menus_tl granted_menu, ' ||
993: 'fnd_menus granted_menu_data, ' ||
994: 'ego_obj_role_mappings mapping, ' ||
995: 'fnd_objects obj, ' ||