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_LIST_ENTRIES

Line 681: FROM ams_list_entries le

677:
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'

Line 693: FROM ams_list_entries le

689: /*
690: CURSOR c_exists_in_invite_list
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')

Line 706: FROM ams_list_entries le

702: /*
703: CURSOR c_exists_in_invite_list
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')

Line 739: from ams_list_entries le

735: AND object_id = p_attendant_party_id)
736: and le.list_entry_source_system_type ='ORGANIZATION_CONTACT_LIST')));
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')