test

UPDATE t_pro_productrecordbill
SET fvarietytypeid = 'a/QAAAAFs9wqTyRm',
fqualitylevelid = 'a/QAAAAFs+O98uWB',
cforderlevelid = 'a/QAAAAFs+C98uWB',
fstorageorgunitid = 'a/QAAAAAAM7M567U',
fworkcenterid = 'a/QAAAAFTfp6/c3d',
flot = '0120140817',
flivepiglot = '0120140817',
ffirstweightlot = '0120140817',
fcostcenterid = 'a/QAAAAAB3XM567U',
fproductionplanbil = 'a/QAAABbfeDV8deT',
ffurcolor = '1',
fanimalmark = '',
fartfiauxiliary = '',
fsizedegradationgrade = '0',
ftestthreetestvalue = 1,
fproducttemp = '0',
fphvalue = '0',
cfbuckleweightrate = 0,
fpsevalue = '',
ffatthickness = '0',
fleanmeatthick = '0',
fleanmeatrate = '0',
ftestonetestvalue = '',
ftesttwotestvalue = '',
ftestfourtestvalue = '',
ftestfivetestvalue_1 = '',
fpurpointstotal = 0,
fpropointstotal = 0,
fpoints = 0,
fproducttype = '1',
fremark = '',
fpurinwarehsbillid = 'CHhPl8yiSmeB48wdNwyql3gwYeM=',
fsupplierid = 'a/QAAAAEFuE3xn38',
fpurchaseorgunitid = 'a/QAAAAAAM7M567U',
fpurcasegroupid = '',
fpurchasepersonid = '',
farrivetime = To_date('2014-08-17','yyyy-mm-dd hh24:mi:ss'),
ftinwarehstime = To_date('2014-08-17','yyyy-mm-dd hh24:mi:ss'),
fbanlancetype = '10',
fstoragecellid = 'Ady4ac2ORcOiMy28sHjs144IhhY=',
fsupplytypeid = '',
flastupdateuserid = '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F',
ffirstqualitytime = sysdate,
flastupdatetime = sysdate,
cfclasslistid = 'a/QAAAAK6QTMifO2'
WHERE fid = 'FmSFjEMXQXCd33dis4zEoXa11B0=';

/*dialect*/

UPDATE ct_pro_productionpbfe
SET cfnoproductqty = Nvl(cfnoproductqty,0) + 1
WHERE fparentid = (SELECT fid
FROM ct_pro_productionplanbill
WHERE fnumber = '20141030-0007')
AND cfpiglot = '0120140817';

/*dialect*/
UPDATE ct_pro_productionpbfe
SET cfnoproductqty = Nvl(cfnoproductqty,0) - 1
WHERE fparentid = (SELECT fid
FROM ct_pro_productionplanbill
WHERE fnumber = '20141030-0007')
AND cfpiglot = '0120140817';