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.OZF_SD_REQUEST_PUB dependencies on AMS_USER_STATUSES_B

Line 202: FROM ams_user_statuses_b

198: l_user_status_id NUMBER;
199:
200: CURSOR c_user_status_id IS
201: SELECT user_status_id
202: FROM ams_user_statuses_b
203: WHERE system_status_type ='OZF_SD_REQUEST_STATUS'
204: AND enabled_flag ='Y'
205: AND default_flag ='Y'
206: AND system_status_code = p_system_status_code;

Line 234: FROM ams_user_statuses_b

230: l_system_status_code VARCHAR2(30);
231:
232: CURSOR c_system_status_code IS
233: SELECT system_status_code
234: FROM ams_user_statuses_b
235: WHERE system_status_type ='OZF_SD_REQUEST_STATUS'
236: AND enabled_flag ='Y'
237: AND user_status_id = p_user_status_id ;
238:

Line 682: FROM ams_user_statuses_b

678: WHERE request_number =p_request_number;
679:
680: CURSOR c_system_status_code(p_user_status_id IN VARCHAR2)IS
681: SELECT system_status_code
682: FROM ams_user_statuses_b
683: WHERE system_status_type ='OZF_SD_REQUEST_STATUS'
684: AND user_status_id = p_user_status_id;
685:
686: CURSOR c_order_no(p_internal_order_number IN NUMBER,p_org_id IN NUMBER)IS