APPS.AHL_PP_MATERIALS_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 303: FROM MTL_SYSTEM_ITEMS_KFV

299: IF (p_inventory_item_id IS NOT NULL AND
300: p_inventory_item_id <> FND_API.G_MISS_NUM) THEN
301: --
302: SELECT inventory_item_id INTO x_inventory_item_id
303: FROM MTL_SYSTEM_ITEMS_KFV
304: WHERE inventory_item_id = p_inventory_item_id
305: AND organization_id = p_organization_id;
306: ELSE
307: --

Line 309: FROM MTL_SYSTEM_ITEMS_KFV

305: AND organization_id = p_organization_id;
306: ELSE
307: --
308: SELECT inventory_item_id INTO x_inventory_item_id
309: FROM MTL_SYSTEM_ITEMS_KFV
310: WHERE concatenated_segments = p_concatenated_segments
311: AND organization_id = p_organization_id;
312: END IF;
313: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 3619: FROM mtl_system_items_kfv

3615: --
3616: CURSOR Get_item_cur(c_segments IN VARCHAR2)
3617: IS
3618: SELECT distinct(inventory_item_id)
3619: FROM mtl_system_items_kfv
3620: WHERE concatenated_segments = c_segments;
3621: --
3622: l_return VARCHAR2(1);
3623: --

Line 3666: FROM mtl_system_items_kfv

3662: --
3663: CURSOR Get_item_cur(c_segments IN VARCHAR2)
3664: IS
3665: SELECT distinct(inventory_item_id)
3666: FROM mtl_system_items_kfv
3667: WHERE concatenated_segments = c_segments;
3668: --
3669: l_inventory_item_id NUMBER;
3670: l_rt_oper_material_id NUMBER;