APPS.AHL_UTIL_UC_PKG dependencies on MTL_ITEM_LOCATIONS_KFV

Line 49: --FROM mtl_item_locations_kfv

45: --SELECT concatenated_segments
46: SELECT INV_PROJECT.GET_LOCSEGS(LOC.inventory_location_id, LOC.ORGANIZATION_ID) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
47: || INV_ProjectLocator_PUB.get_project_number(LOC.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
48: || INV_ProjectLocator_PUB.get_task_number(LOC.segment20)
49: --FROM mtl_item_locations_kfv
50: FROM mtl_item_locations LOC
51: WHERE inventory_location_id = p_inventory_locator_id
52: AND organization_id = p_inventory_org_id;
53:

Line 130: l_concatenated_segments mtl_item_locations_kfv.concatenated_segments%TYPE;

126: SELECT name
127: FROM hr_all_organization_units
128: WHERE organization_id = p_organization_id;
129:
130: l_concatenated_segments mtl_item_locations_kfv.concatenated_segments%TYPE;
131: l_location VARCHAR2(2000);
132: l_organization_name hr_all_organization_units.name%TYPE;
133:
134: