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.

No Files Were Attached
sommaip Agile User Asked on April 11, 2018 in Product Collaboration.
Add Comment
1 Answer(s)

Deleting only from item and manu_parts will corrupt the DB, all functionality calling  remaining  orphan rows will fail Unknown Object. Must delete from all related tables ( bom, rev, p2,p3,manu_by, etc…too many too list)

SoCalPLM Agile User Answered on April 16, 2018.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.