APPS.CSI_ML_UTIL_PVT dependencies on MTL_MATERIAL_STATUSES

Line 150: FROM mtl_material_statuses

146: FORALL i3 in 1 .. inst_intf_id_upd.count
147: UPDATE csi_instance_interface a
148: SET a.instance_condition_id =
149: (SELECT status_id
150: FROM mtl_material_statuses
151: WHERE status_code = a.instance_condition)
152: WHERE inst_interface_id=inst_intf_id_upd(i3)
153: AND a.instance_condition_id IS NULL
154: AND a.instance_condition IS NOT NULL;

Line 679: FROM mtl_material_statuses

675: FORALL i3 in 1 .. inst_intf_id_upd.count
676: UPDATE csi_instance_interface a
677: SET a.instance_condition_id =
678: (SELECT status_id
679: FROM mtl_material_statuses
680: WHERE status_code = a.instance_condition)
681: WHERE inst_interface_id=inst_intf_id_upd(i3)
682: AND a.instance_condition_id IS NULL
683: AND a.instance_condition IS NOT NULL;