APPS.AHL_FMP_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 18: (select kfv.concatenated_segments from mtl_system_items_kfv kfv

14: WHERE csi_item_instance_id = c_item_instance_id;
15: */
16:
17: SELECT ii.serial_number,
18: (select kfv.concatenated_segments from mtl_system_items_kfv kfv
19: where kfv.inventory_item_id = ii.inventory_item_id
20: AND kfv.organization_id = ii.inv_master_organization_id) item_number,
21: ii.inventory_item_id,
22: ahl_util_uc_pkg.getcsi_locationDesc(ii.location_id, ii.location_type_code,