APPS.AHL_UTIL_UC_PKG dependencies on MTL_ITEM_LOCATIONS

Line 43: CURSOR mtl_item_locations_csr(p_inventory_org_id IN NUMBER,

39: p_wip_job_id IN NUMBER)
40: RETURN VARCHAR2 IS
41:
42: -- modified to fix bug# 10264213
43: CURSOR mtl_item_locations_csr(p_inventory_org_id IN NUMBER,
44: p_inventory_locator_id IN NUMBER) IS
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)

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 50: FROM mtl_item_locations LOC

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:
54: -- Bug# 4902980 SQL id: 14398234

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:

Line 143: OPEN mtl_item_locations_csr(p_inventory_org_id, p_inventory_locator_id);

139: OPEN get_org_name_csr(p_inventory_org_id);
140: FETCH get_org_name_csr INTO l_organization_name;
141: IF (get_org_name_csr%FOUND) THEN
142: IF (p_inventory_locator_id IS NOT NULL) THEN
143: OPEN mtl_item_locations_csr(p_inventory_org_id, p_inventory_locator_id);
144:
145: FETCH mtl_item_locations_csr INTO l_concatenated_segments;
146: IF (mtl_item_locations_csr%FOUND) THEN
147: l_location := l_concatenated_segments;

Line 145: FETCH mtl_item_locations_csr INTO l_concatenated_segments;

141: IF (get_org_name_csr%FOUND) THEN
142: IF (p_inventory_locator_id IS NOT NULL) THEN
143: OPEN mtl_item_locations_csr(p_inventory_org_id, p_inventory_locator_id);
144:
145: FETCH mtl_item_locations_csr INTO l_concatenated_segments;
146: IF (mtl_item_locations_csr%FOUND) THEN
147: l_location := l_concatenated_segments;
148: END IF;
149: CLOSE mtl_item_locations_csr;

Line 146: IF (mtl_item_locations_csr%FOUND) THEN

142: IF (p_inventory_locator_id IS NOT NULL) THEN
143: OPEN mtl_item_locations_csr(p_inventory_org_id, p_inventory_locator_id);
144:
145: FETCH mtl_item_locations_csr INTO l_concatenated_segments;
146: IF (mtl_item_locations_csr%FOUND) THEN
147: l_location := l_concatenated_segments;
148: END IF;
149: CLOSE mtl_item_locations_csr;
150: END IF;

Line 149: CLOSE mtl_item_locations_csr;

145: FETCH mtl_item_locations_csr INTO l_concatenated_segments;
146: IF (mtl_item_locations_csr%FOUND) THEN
147: l_location := l_concatenated_segments;
148: END IF;
149: CLOSE mtl_item_locations_csr;
150: END IF;
151: IF (l_location IS NOT NULL) THEN
152: l_location := l_location || ';' || p_subinventory_name || ';' || l_organization_name;
153: ELSE