DBA Data[Home] [Help]

APPS.WMS_PACKING_WORKBENCH_PVT dependencies on MTL_ITEM_LOCATIONS_KFV

Line 1289: FROM mtl_item_locations_kfv

1285: (l_material_rec.locator_id IS NOT NULL AND l_material_rec.locator_id NOT IN (-1,0)) THEN
1286: BEGIN
1287: SELECT
1288: inv_project.get_locsegs(l_material_rec.locator_id,l_material_rec.organization_id) /*bug344642 concatenated_segments*/ INTO l_material_rec.locator
1289: FROM mtl_item_locations_kfv
1290: WHERE organization_id = l_material_rec.organization_id
1291: AND subinventory_code = l_material_rec.subinventory
1292: AND inventory_location_id = l_material_rec.locator_id;
1293: EXCEPTION

Line 2300: FROM mtl_item_locations_kfv

2296: ELSIF l_material_rec.locator_id IS NOT NULL THEN
2297: BEGIN
2298: SELECT
2299: inv_project.get_locsegs(l_material_rec.locator_id,l_material_rec.organization_id) /*bug344642 concatenated_segments*/ INTO l_material_rec.locator
2300: FROM mtl_item_locations_kfv
2301: WHERE organization_id = l_material_rec.organization_id
2302: AND subinventory_code = l_material_rec.subinventory
2303: AND inventory_location_id = l_material_rec.locator_id;
2304: EXCEPTION