APPS.ENG_CANCEL_ECO dependencies on MTL_ITEM_REVISIONS_TL

Line 640: delete from MTL_ITEM_REVISIONS_TL

636: ** delete item revisions created by revised items on ECO
637: */
638: stmt_num := 60;
639:
640: delete from MTL_ITEM_REVISIONS_TL
641: where revision_id IN (select revision_id
642: from MTL_ITEM_REVISIONS_B I
643: WHERE CHANGE_NOTICE = change_order
644: AND ORGANIZATION_ID = org_id

Line 1003: delete from MTL_ITEM_REVISIONS_TL

999: ** delete item revisions created by revised items on ECO
1000: */
1001: stmt_num := 50;
1002: -- Modified where clause for performance bug 4251776
1003: delete from MTL_ITEM_REVISIONS_TL
1004: WHERE revision_id IN (select new_item_revision_id
1005: from eng_revised_items I
1006: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
1007: