APPS.EAM_ACTIVITYUTILITIES_PVT dependencies on MTL_ITEM_LOCATIONS_KFV

Line 876: l_locator mtl_item_locations_kfv.concatenated_segments%TYPE;

872: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
873: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
874: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
875:
876: l_locator mtl_item_locations_kfv.concatenated_segments%TYPE;
877: BEGIN
878: if(l_ulog) then
879: l_module := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;
880: end if;

Line 885: FROM mtl_item_locations_kfv

881: IF p_organization_id IS NULL OR p_subinventory_code IS NULL OR p_locator_id IS NULL THEN
882: RETURN NULL;
883: ELSE
884: SELECT concatenated_segments INTO l_locator
885: FROM mtl_item_locations_kfv
886: WHERE organization_id = p_organization_id
887: AND subinventory_code = p_subinventory_code
888: AND (disable_date > sysdate or disable_date is null)
889: AND inventory_location_id = p_locator_id;