update gl_je_batches gjb
set gjb.approval_status_code = 'R'
where gjb.je_batch_id in (select gjh.je_batch_id
from gl_je_headers gjh
where gjh.name = '2013123101') ;
name : 日记帐名称
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13387766/viewspace-754374/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/13387766/viewspace-754374/