Delete items and mfg part with pl sql
Dear sir,
I have some item and mfg part need to delete with pl sql.
Example :
delete from ….. where item in (AAAA’,’BBBB’,’CCCC)
delete from …. where mfgpart in (‘XXXXXX’,’YYYYY’,’ZZZZZ’)
Provide plsql statement to me,Please.
Thanks you.
Hi,
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.
Regards,
Arif
Definitely Arif has a point.
Do not delete in database.
SDK codes is the best approach but you can also try to use DataLoad.
My best
Carlos