APPS.INV_MATERIAL_STATUS_PUB dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 262: SELECT status_id INTO l_old_status_id FROM mtl_onhand_quantities_detail

258:
259: if l_status_rec.status_id is not null or l_status_rec.status_id <> 0 or l_status_rec.status_id <> -1 THEN
260: --Bug 14028205 Added the select statement
261: BEGIN
262: SELECT status_id INTO l_old_status_id FROM mtl_onhand_quantities_detail
263: WHERE inventory_item_id = l_status_rec.inventory_item_id
264: and organization_id = l_status_rec.organization_id
265: and subinventory_code = nvl(l_status_rec.zone_code, subinventory_code)
266: and nvl(lot_number, '@@@@') = nvl(l_status_rec.lot_number, nvl(lot_number, '@@@@'))

Line 286: update mtl_onhand_quantities_detail

282: ,P_lot_number => l_status_rec.lot_number
283: ,p_lpn_id => l_status_rec.lpn_id) ;
284:
285: IF ( l_onhand_fl ) then
286: update mtl_onhand_quantities_detail
287: set status_id = l_status_rec.status_id
288: , last_updated_by = l_status_rec.last_updated_by
289: , last_update_date = l_status_rec.last_update_date
290: , last_update_login = l_status_rec.last_update_login