APPS.AHL_UTIL_UC_PKG dependencies on MTL_ITEM_LOCATIONS_KFV

Line 45: FROM mtl_item_locations_kfv

41:
42: CURSOR mtl_item_locations_csr(p_inventory_org_id IN NUMBER,
43: p_inventory_locator_id IN NUMBER) IS
44: SELECT concatenated_segments
45: FROM mtl_item_locations_kfv
46: WHERE inventory_location_id = p_inventory_locator_id
47: AND organization_id = p_inventory_org_id;
48:
49: -- Bug# 4902980 SQL id: 14398234

Line 125: l_concatenated_segments mtl_item_locations_kfv.concatenated_segments%TYPE;

121: SELECT name
122: FROM hr_all_organization_units
123: WHERE organization_id = p_organization_id;
124:
125: l_concatenated_segments mtl_item_locations_kfv.concatenated_segments%TYPE;
126: l_location VARCHAR2(2000);
127: l_organization_name hr_all_organization_units.name%TYPE;
128:
129: