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 271: FROM ozf_sd_status_transitions

267: l_owner_pm_count NUMBER :=0;
268:
269: CURSOR c_external_transition (p_cur_owner_flag IN VARCHAR2,p_cur_pm_flag IN VARCHAR2) IS
270: SELECT COUNT(1)
271: FROM ozf_sd_status_transitions
272: WHERE enabled_flag ='Y'
273: AND from_status = p_from_status
274: AND to_status = p_to_status
275: AND NVL(owner_flag,'N') = p_cur_owner_flag

Line 282: FROM ozf_sd_status_transitions

278: AND system_flag IS NULL;
279:
280: CURSOR c_internal_transition (p_cur_owner_flag IN VARCHAR2,p_cur_pm_flag IN VARCHAR2) IS
281: SELECT COUNT(1)
282: FROM ozf_sd_status_transitions
283: WHERE enabled_flag ='Y'
284: AND from_status = p_from_status
285: AND to_status = p_to_status
286: AND NVL(owner_flag,'N') = p_cur_owner_flag