APPS.OZF_SD_REQUEST_PUB dependencies on AMS_USER_STATUSES_VL
Line 3995: FROM ams_user_statuses_vl
3991: WHERE request_number =p_request_number;
3992:
3993: CURSOR c_user_status_name(p_user_status_id IN NUMBER)IS
3994: SELECT name 3995: FROM ams_user_statuses_vl 3996: WHERE user_status_id = p_user_status_id;
3997:
3998: CURSOR c_communication(p_supplier_id IN NUMBER,p_supplier_site_id IN NUMBER)IS
3999: SELECT request_communication