DBA Data[Home] [Help]

APPS.WMS_PACKING_WORKBENCH_PVT dependencies on MTL_ITEM_LOCATIONS_KFV

Line 1226: FROM mtl_item_locations_kfv

1222: (l_material_rec.locator_id IS NOT NULL AND l_material_rec.locator_id NOT IN (-1,0)) THEN
1223: BEGIN
1224: SELECT
1225: inv_project.get_locsegs(l_material_rec.locator_id,l_material_rec.organization_id) /*bug344642 concatenated_segments*/ INTO l_material_rec.locator
1226: FROM mtl_item_locations_kfv
1227: WHERE organization_id = l_material_rec.organization_id
1228: AND subinventory_code = l_material_rec.subinventory
1229: AND inventory_location_id = l_material_rec.locator_id;
1230: EXCEPTION

Line 2227: FROM mtl_item_locations_kfv

2223: ELSIF l_material_rec.locator_id IS NOT NULL THEN
2224: BEGIN
2225: SELECT
2226: inv_project.get_locsegs(l_material_rec.locator_id,l_material_rec.organization_id) /*bug344642 concatenated_segments*/ INTO l_material_rec.locator
2227: FROM mtl_item_locations_kfv
2228: WHERE organization_id = l_material_rec.organization_id
2229: AND subinventory_code = l_material_rec.subinventory
2230: AND inventory_location_id = l_material_rec.locator_id;
2231: EXCEPTION