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 OZF_SD_STATUS_TRANSITIONS

Line 265: FROM ozf_sd_status_transitions

261: l_owner_pm_count NUMBER :=0;
262:
263: CURSOR c_external_transition (p_cur_owner_flag IN VARCHAR2,p_cur_pm_flag IN VARCHAR2) IS
264: SELECT COUNT(1)
265: FROM ozf_sd_status_transitions
266: WHERE enabled_flag ='Y'
267: AND from_status = p_from_status
268: AND to_status = p_to_status
269: AND NVL(owner_flag,'N') = p_cur_owner_flag

Line 276: FROM ozf_sd_status_transitions

272: AND system_flag IS NULL;
273:
274: CURSOR c_internal_transition (p_cur_owner_flag IN VARCHAR2,p_cur_pm_flag IN VARCHAR2) IS
275: SELECT COUNT(1)
276: FROM ozf_sd_status_transitions
277: WHERE enabled_flag ='Y'
278: AND from_status = p_from_status
279: AND to_status = p_to_status
280: AND NVL(owner_flag,'N') = p_cur_owner_flag