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_STATUS_PVT dependencies on AMS_USER_STATUSES_VL

Line 156: FROM ams_user_statuses_vl

152: )
153: IS
154: CURSOR c_system_stat IS
155: SELECT system_status_code,system_status_type
156: FROM ams_user_statuses_vl
157: WHERE user_status_id = p_current_status_id ;
158:
159: CURSOR c_next_statuses(l_stat_code VARCHAR2,l_stat_type VARCHAR2) IS
160: SELECT next_status_code

Line 169: FROM ams_user_statuses_vl

165:
166: CURSOR c_user_statuses(l_stat_code VARCHAR2,l_stat_type VARCHAR2) IS
167: SELECT user_status_id,system_status_type,system_status_code,
168: default_flag,name
169: FROM ams_user_statuses_vl
170: WHERE system_status_code = l_stat_code
171: AND system_status_type = l_stat_type
172: AND start_date_active < SYSDATE
173: AND (end_date_active IS NULL OR