DBA Data[Home] [Help]

APPS.INV_MATERIAL_STATUS_PUB dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 122: update mtl_onhand_quantities_detail

118: elsif p_object_type = 'H' then
119: -- Need to add code to make sure that not serial controlled one.
120: -- I think as this is in else of serial .. no need to check the serial control again
121: if l_status_rec.status_id is not null or l_status_rec.status_id <> 0 or l_status_rec.status_id <> -1 then
122: update mtl_onhand_quantities_detail
123: set status_id = l_status_rec.status_id
124: , last_updated_by = l_status_rec.last_updated_by
125: , last_update_date = l_status_rec.last_update_date
126: , last_update_login = l_status_rec.last_update_login