APPS.INV_LABEL_PVT4 dependencies on MTL_MATERIAL_STATUSES_VL

Line 709: , mtl_material_statuses_vl mmsv

705: FROM mtl_parameters mp
706: , mtl_system_items_kfv msik
707: , mtl_lot_numbers mln
708: , po_hazard_classes poh
709: , mtl_material_statuses_vl mmsv
710: WHERE msik.inventory_item_id = p_item_id
711: AND msik.organization_id = p_org_id
712: AND mp.organization_id = msik.organization_id
713: AND mln.organization_id (+) = msik.organization_id

Line 2204: FROM mtl_material_statuses_vl

2200: trace('Status_id returned is '||l_return_status_id);
2201: END IF;
2202: BEGIN
2203: SELECT status_code INTO l_material_status_code
2204: FROM mtl_material_statuses_vl
2205: WHERE status_id = l_return_status_id;
2206: EXCEPTION
2207: WHEN No_Data_Found THEN
2208: l_material_status_code := NULL;