Delete formula line
select * FROM FM_MATL_DTL WHERE line_no=3 and RELEASE_TYPE='1' and trunc(LAST_UPDATE_DATE)=trunc(sysdate)
SELECT * FROM FM_MATL_DTL WHERE FORMULA_ID=(select FORMULA_ID FROM FM_FORM_MST WHERE FORMULA_NO='940589') AND RELEASE_TYPE='1'
delete from FM_MATL_DTL WHERE FORMULALINE_ID='784760' and FORMULA_ID='65818' AND RELEASE_TYPE='1';
Comments
Post a Comment