APPS.ENG_CANCEL_ECO dependencies on EGO_MTL_SY_ITEMS_EXT_TL

Line 673: DELETE FROM EGO_MTL_SY_ITEMS_EXT_TL A

669: ** delete UDA data created by revised items of ECO
670: */
671: stmt_num := 70;
672:
673: DELETE FROM EGO_MTL_SY_ITEMS_EXT_TL A
674: WHERE A.REVISION_ID IN (SELECT NEW_ITEM_REVISION_ID
675: FROM ENG_REVISED_ITEMS
676: WHERE NEW_ITEM_REVISION_ID IS NOT NULL
677: AND CHANGE_NOTICE = change_order

Line 1027: DELETE FROM EGO_MTL_SY_ITEMS_EXT_TL A

1023: ** delete UDA data created by revised items on ECO
1024: */
1025: stmt_num := 60;
1026:
1027: DELETE FROM EGO_MTL_SY_ITEMS_EXT_TL A
1028: WHERE A.REVISION_ID IN (SELECT NEW_ITEM_REVISION_ID
1029: FROM ENG_REVISED_ITEMS
1030: WHERE NEW_ITEM_REVISION_ID IS NOT NULL
1031: AND REVISED_ITEM_SEQUENCE_ID = rev_item_seq);