第一句详细解释作用?对于此句left join MA_COA_ACC A on A.COA_CODE=
(select COA_CODE from MA_COMPANY where CO_CODE=@CO_CODE)第二句:
delete SP_GL_BAL_T where (code1,code2,code3,code4,code5,code6,code7,code8,code9,CUR_CODE) in (select code1,code2,code3,code4,code5,code6,code7,code8,code9,CUR_CODE from SP_GL_BAL_T where RECLEVEL=7) and RECLEVEL=8;
(select COA_CODE from MA_COMPANY where CO_CODE=@CO_CODE)第二句:
delete SP_GL_BAL_T where (code1,code2,code3,code4,code5,code6,code7,code8,code9,CUR_CODE) in (select code1,code2,code3,code4,code5,code6,code7,code8,code9,CUR_CODE from SP_GL_BAL_T where RECLEVEL=7) and RECLEVEL=8;
P.code1 in (select A.acc_code from MA_COA_ACC A where A.IS_CURR<>'Y' OR A.IS_CURR is NULL OR A.IS_QTY<>'Y' OR A.IS_QTY is NULL AND A.ACC_CODE=P.CODE1(+)
and A.COA_CODE=(select COA_CODE from MA_COMPANY where CO_CODE=@CO_CODE));