Delete items and mfg part with pl sql
I have some item and mfg part need to delete with pl sql.
delete from ….. where item in (AAAA’,’BBBB’,’CCCC)
delete from …. where mfgpart in (‘XXXXXX’,’YYYYY’,’ZZZZZ’)
Provide plsql statement to me,Please.
I don’t think it is advised to do so. Item can have multiple dependencies and so does MPNs. If you must delete then try using sdk codes. First try to programmatically remove the dependencies, make the object orphan and then soft-delete it.