APPS.AHL_CMP_UTIL_PKG dependencies on MTL_ITEM_LOCATIONS_KFV

Line 658: FROM MTL_ITEM_LOCATIONS MIL,MTL_ITEM_LOCATIONS_KFV MIL_kfv

654: || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
655: || INV_ProjectLocator_PUB.get_project_number(MIL.segment19)
656: || FND_FLEX_EXT.GET_DELIMITER('INV', 'MTLL', 101)
657: || INV_ProjectLocator_PUB.get_task_number(MIL.segment20)) locator_segments
658: FROM MTL_ITEM_LOCATIONS MIL,MTL_ITEM_LOCATIONS_KFV MIL_kfv
659: WHERE MIL_kfv.INVENTORY_LOCATION_ID = MIL.INVENTORY_LOCATION_ID AND
660: MIL_kfv.ORGANIZATION_ID = MIL.ORGANIZATION_ID AND
661: MIL.INVENTORY_LOCATION_ID = p_locator_id;
662:

Line 671: FROM MTL_ITEM_LOCATIONS_KFV MIL

667: || INV_ProjectLocator_PUB.get_project_number(MIL.segment19)
668: || FND_FLEX_EXT.GET_DELIMITER('INV', 'MTLL', 101)
669: || INV_PROJECTLOCATOR_PUB.GET_TASK_NUMBER(MIL.SEGMENT20))
670: INTO l_concat_segs
671: FROM MTL_ITEM_LOCATIONS_KFV MIL
672: WHERE MIL.INVENTORY_LOCATION_ID = p_locator_id;*/
673:
674: OPEN get_locator_segments(p_locator_id);
675: FETCH get_locator_segments INTO l_concat_segs;