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.AME_MIGRATION_REPORT dependencies on AME_APPROVAL_GROUPS

Line 449: ,ame_approval_groups grp

445: select distinct grpitems.approval_group_id
446: ,parameter person_id
447: ,grp.name
448: from ame_approval_group_items grpitems
449: ,ame_approval_groups grp
450: where grpitems.parameter_name = ame_util.approverPersonId
451: and grp.approval_group_id = grpitems.approval_group_id
452: and grp.start_date = (select max(start_date)
453: from ame_approval_groups

Line 453: from ame_approval_groups

449: ,ame_approval_groups grp
450: where grpitems.parameter_name = ame_util.approverPersonId
451: and grp.approval_group_id = grpitems.approval_group_id
452: and grp.start_date = (select max(start_date)
453: from ame_approval_groups
454: where approval_group_id = grp.approval_group_id)
455: and not exists (select null from wf_roles wf
456: where wf.orig_system_id = grpitems.parameter
457: and wf.orig_system = 'PER'

Line 470: ,ame_approval_groups grp

466: select distinct grpmem.approval_group_id
467: ,grpmem.parameter person_id
468: ,grp.name
469: from ame_approval_group_members grpmem
470: ,ame_approval_groups grp
471: where grpmem.parameter_name = ame_util.approverPersonId
472: and grp.approval_group_id = grpmem.approval_group_id
473: and grp.start_date = (select max(start_date)
474: from ame_approval_groups

Line 474: from ame_approval_groups

470: ,ame_approval_groups grp
471: where grpmem.parameter_name = ame_util.approverPersonId
472: and grp.approval_group_id = grpmem.approval_group_id
473: and grp.start_date = (select max(start_date)
474: from ame_approval_groups
475: where approval_group_id = grp.approval_group_id)
476: and not exists (select null from wf_roles wf
477: where wf.orig_system_id = grpmem.parameter
478: and wf.orig_system = 'PER'

Line 601: ,ame_approval_groups grp

597: ,substrb(parameter, instrb(parameter,'AME_MIGRATION_')+14) person_id
598: ,parameter
599: ,grp.name
600: from ame_approval_group_items grpitems
601: ,ame_approval_groups grp
602: where grpitems.parameter_name = 'wf_roles_name'
603: and grp.approval_group_id = grpitems.approval_group_id
604: and grp.start_date = (select max(start_date)
605: from ame_approval_groups

Line 605: from ame_approval_groups

601: ,ame_approval_groups grp
602: where grpitems.parameter_name = 'wf_roles_name'
603: and grp.approval_group_id = grpitems.approval_group_id
604: and grp.start_date = (select max(start_date)
605: from ame_approval_groups
606: where approval_group_id = grp.approval_group_id)
607: and parameter like 'AME_MIGRATION%'
608: and exists (select null from wf_roles wf
609: where wf.name = grpitems.parameter

Line 624: ,ame_approval_groups grp

620: ,substrb(grpmem.parameter,instrb(grpmem.parameter,'AME_MIGRATION_')+14) person_id
621: ,grpmem.parameter
622: ,grp.name
623: from ame_approval_group_members grpmem
624: ,ame_approval_groups grp
625: where grpmem.parameter_name = 'wf_roles_name'
626: and grp.approval_group_id = grpmem.approval_group_id
627: and grp.start_date = (select max(start_date)
628: from ame_approval_groups

Line 628: from ame_approval_groups

624: ,ame_approval_groups grp
625: where grpmem.parameter_name = 'wf_roles_name'
626: and grp.approval_group_id = grpmem.approval_group_id
627: and grp.start_date = (select max(start_date)
628: from ame_approval_groups
629: where approval_group_id = grp.approval_group_id)
630: and grpmem.parameter like 'AME_MIGRATION%'
631: and exists (select null from wf_roles wf
632: where wf.name = grpmem.parameter

Line 737: ,ame_approval_groups grp

733: ,grpitems.parameter user_id
734: ,fnd.employee_id person_id
735: ,fnd.user_name
736: from ame_approval_group_items grpitems
737: ,ame_approval_groups grp
738: ,fnd_user fnd
739: where grpitems.parameter_name = 'user_id'
740: and fnd.employee_id is not null
741: and grpitems.parameter = to_char(fnd.user_id)

Line 744: from ame_approval_groups

740: and fnd.employee_id is not null
741: and grpitems.parameter = to_char(fnd.user_id)
742: and grp.approval_group_id = grpitems.approval_group_id
743: and grp.start_date = (select max(start_date)
744: from ame_approval_groups
745: where approval_group_id = grp.approval_group_id);
746: --
747: --ame_approval_group_members
748: --

Line 755: ,ame_approval_groups grp

751: ,grpmems.parameter user_id
752: ,fnd.employee_id person_id
753: ,fnd.user_name
754: from ame_approval_group_members grpmems
755: ,ame_approval_groups grp
756: ,fnd_user fnd
757: where grpmems.parameter_name = 'user_id'
758: and fnd.employee_id is not null
759: and grpmems.parameter = to_char(fnd.user_id)

Line 762: from ame_approval_groups

758: and fnd.employee_id is not null
759: and grpmems.parameter = to_char(fnd.user_id)
760: and grp.approval_group_id = grpmems.approval_group_id
761: and grp.start_date = (select max(start_date)
762: from ame_approval_groups
763: where approval_group_id = grp.approval_group_id);
764: --
765: --ame_config_vars (adminApprover)
766: --