insert into a select

INSERT INTO MTRL_INOUT
(MTRL_INOUT_NO,MTRL_NO,MTRL_STORE_NO,INTS_YN,INOUT_DT,INOUT_AMT,CRTOR_NO,CRT_DTM,INOUT_UNIT,REQ_USER_NO,REQ_DEPT_NO,BUY_UNPR)
select SQ_MTRL_INOUT.NEXTVAL, m.mtrl_no, msk.mtrl_store_no,'I',TO_CHAR(SYSDATE,'YYYY-MM-DD'),msk.cur_stock,1,sysdate,M.TEST_UNIT_NO,ui.user_no,ui.dept_no,m.BUY_UNPR
from mtrl_stock msk
inner join mtrl m on m.mtrl_no = msk.mtrl_no
LEFT OUTER JOIN USER_INFO UI ON M.CRTOR_NO = UI.USER_NO
where  msk.cur_stock !=0;