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_LIST_PURGE_PVT dependencies on AMS_LOOKUPS

Line 656: FROM ams_lookups

652:
653: -- get lookup_code for type 'TARGET'
654: l_lookup_type := null;
655: SELECT lookup_code INTO l_lookup_type
656: FROM ams_lookups
657: WHERE lookup_type = 'AMS_LIST_TYPE'
658: AND lookup_code = 'TARGET';
659:
660: -- get lookup_code for status 'ARCHIVED'

Line 663: FROM ams_lookups

659:
660: -- get lookup_code for status 'ARCHIVED'
661: l_lookup_status := null;
662: SELECT lookup_code INTO l_lookup_status
663: FROM ams_lookups
664: WHERE lookup_type = 'AMS_LIST_STATUS'
665: AND lookup_code = 'ARCHIVED';
666:
667: