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.AMS_EVTREGS_PVT dependencies on AMS_ACT_LISTS

Line 682: , ams_act_lists al

678: CURSOR c_exists_in_invite_list
679: IS
680: SELECT 1
681: FROM ams_list_entries le
682: , ams_act_lists al
683: WHERE al.list_used_by_id = p_event_offer_id
684: AND al.list_used_by in ('EVEO', 'EONE')
685: AND al.list_act_type = 'TARGET'
686: AND le.list_header_id = al.list_header_id

Line 695: FROM ams_act_lists al

691: IS
692: SELECT COUNT(1)
693: FROM ams_list_entries le
694: WHERE EXISTS (SELECT 1
695: FROM ams_act_lists al
696: WHERE list_used_by_id = p_event_offer_id
697: AND list_used_by in ('EVEO', 'EONE')
698: AND list_act_type = 'TARGET'
699: AND le.list_header_id = al.list_header_id

Line 708: FROM ams_act_lists al

704: IS
705: SELECT COUNT(1)
706: FROM ams_list_entries le
707: WHERE EXISTS (SELECT 1
708: FROM ams_act_lists al
709: WHERE list_used_by_id = p_event_offer_id
710: AND list_used_by in ('EVEO', 'EONE')
711: AND list_act_type = 'TARGET'
712: AND le.list_header_id = al.list_header_id

Line 741: from ams_act_lists al

737: */
738: /* select count(1)
739: from ams_list_entries le
740: where exists (select 1
741: from ams_act_lists al
742: where list_used_by_id = p_event_offer_id
743: and list_used_by in ('EVEO', 'EONE')
744: and list_act_type = 'TARGET'
745: and le.list_header_id = al.list_header_id