APPS.ASO_SERVICE_CONTRACTS_INT dependencies on MTL_SYSTEM_ITEMS_VL

Line 948: FROM mtl_system_items_vl

944: CURSOR C_warranty(item_id NUMBER) IS
945: SELECT description, concatenated_segments
946: -- SELECT description, segment1
947: -- FROM aso_i_items_v
948: FROM mtl_system_items_vl
949: WHERE inventory_item_id = item_id
950: AND organization_id = p_organization_id;
951: /* AND bom_item_type in (1,4)
952: AND inventory_item_status_code = 'Active'