
/************************************************************************************************************************
*
*  Please run only once 
*
************************************************************************************************************************/

update ypkf set ypkf_revenuetype=2;
update ybef set ybef_revenuetype=2 where nvl(ybef_ypkd_id, 0) > 0;
update ybef set ybef_revenuetype=0 where nvl(ybef_ypkd_id, 0) = 0;