APPS.ENG_CANCEL_ECO dependencies on EGO_MTL_SY_ITEMS_EXT_B

Line 683: /* DELETE FROM EGO_MTL_SY_ITEMS_EXT_B A

679:
680: -- Begin Bug 7381299 fixing
681: -- Fixed by Gabriel on 10/29/2008.
682:
683: /* DELETE FROM EGO_MTL_SY_ITEMS_EXT_B A
684: WHERE A.REVISION_ID IN (SELECT NEW_ITEM_REVISION_ID
685: FROM ENG_REVISED_ITEMS
686: WHERE NEW_ITEM_REVISION_ID IS NOT NULL
687: AND CHANGE_NOTICE = change_order

Line 695: FROM EGO_MTL_SY_ITEMS_EXT_B A

691: ---- A.INVENTORY_ITEM_ID that have indexes built on it to avoid
692: ---- full table scan.
693:
694: DELETE
695: FROM EGO_MTL_SY_ITEMS_EXT_B A
696: WHERE (A.ORGANIZATION_ID, A.INVENTORY_ITEM_ID, A.REVISION_ID) IN
697: (SELECT ORGANIZATION_ID,
698: REVISED_ITEM_ID ,
699: NEW_ITEM_REVISION_ID

Line 1033: DELETE FROM EGO_MTL_SY_ITEMS_EXT_B A

1029: FROM ENG_REVISED_ITEMS
1030: WHERE NEW_ITEM_REVISION_ID IS NOT NULL
1031: AND REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
1032:
1033: DELETE FROM EGO_MTL_SY_ITEMS_EXT_B A
1034: WHERE A.REVISION_ID IN (SELECT NEW_ITEM_REVISION_ID
1035: FROM ENG_REVISED_ITEMS
1036: WHERE NEW_ITEM_REVISION_ID IS NOT NULL
1037: AND REVISED_ITEM_SEQUENCE_ID = rev_item_seq);