APPS.INV_UPDATE_ONHAND_STATUS dependencies on MTL_MATERIAL_STATUSES_VL
Line 178: FROM mtl_material_statuses_vl
174: IF (l_count = 0) THEN
175:
176: UPDATE mtl_parameters
177: SET default_status_id = (SELECT status_id 178: FROM mtl_material_statuses_vl 179: WHERE status_code = p_default_status)
180: WHERE organization_id = orgid_list(i);
181: print_debug('Updated Default Material Status at organization level for org: '|| orgid_list(i));
182: ELSE