APPS.ENG_CANCEL_ECO dependencies on EGO_MTL_SY_ITEMS_EXT_TL

Line 689: DELETE FROM EGO_MTL_SY_ITEMS_EXT_TL A

685: ** delete UDA data created by revised items of ECO
686: */
687: stmt_num := 70;
688:
689: DELETE FROM EGO_MTL_SY_ITEMS_EXT_TL A
690: WHERE A.REVISION_ID IN (SELECT NEW_ITEM_REVISION_ID
691: FROM ENG_REVISED_ITEMS
692: WHERE NEW_ITEM_REVISION_ID IS NOT NULL
693: AND CHANGE_NOTICE = change_order

Line 1052: DELETE FROM EGO_MTL_SY_ITEMS_EXT_TL A

1048: ** delete UDA data created by revised items on ECO
1049: */
1050: stmt_num := 60;
1051:
1052: DELETE FROM EGO_MTL_SY_ITEMS_EXT_TL A
1053: WHERE A.REVISION_ID IN (SELECT NEW_ITEM_REVISION_ID
1054: FROM ENG_REVISED_ITEMS
1055: WHERE NEW_ITEM_REVISION_ID IS NOT NULL
1056: AND REVISED_ITEM_SEQUENCE_ID = rev_item_seq);

Line 1362: DELETE FROM EGO_MTL_SY_ITEMS_EXT_TL A

1358: stmt_num number;
1359:
1360: Begin
1361: stmt_num := 10;
1362: DELETE FROM EGO_MTL_SY_ITEMS_EXT_TL A
1363: WHERE A.REVISION_ID IN (SELECT NEW_ITEM_REVISION_ID
1364: FROM ENG_REVISED_ITEMS
1365: WHERE NEW_ITEM_REVISION_ID IS NOT NULL
1366: AND REVISED_ITEM_SEQUENCE_ID = rev_item_seq);