APPS.OZF_SD_REQUEST_PUB dependencies on AMS_USER_STATUSES_VL

Line 3425: FROM ams_user_statuses_vl

3421: WHERE request_number =p_request_number;
3422:
3423: CURSOR c_user_status_name(p_user_status_id IN NUMBER)IS
3424: SELECT name
3425: FROM ams_user_statuses_vl
3426: WHERE user_status_id = p_user_status_id;
3427:
3428: CURSOR c_communication(p_supplier_id IN NUMBER,p_supplier_site_id IN NUMBER)IS
3429: SELECT request_communication