APPS.ENG_CANCEL_ECO dependencies on EGO_MTL_SY_ITEMS_EXT_B

Line 699: /* DELETE FROM EGO_MTL_SY_ITEMS_EXT_B A

695:
696: -- Begin Bug 7381299 fixing
697: -- Fixed by Gabriel on 10/29/2008.
698:
699: /* DELETE FROM EGO_MTL_SY_ITEMS_EXT_B A
700: WHERE A.REVISION_ID IN (SELECT NEW_ITEM_REVISION_ID
701: FROM ENG_REVISED_ITEMS
702: WHERE NEW_ITEM_REVISION_ID IS NOT NULL
703: AND CHANGE_NOTICE = change_order

Line 711: FROM EGO_MTL_SY_ITEMS_EXT_B A

707: ---- A.INVENTORY_ITEM_ID that have indexes built on it to avoid
708: ---- full table scan.
709:
710: DELETE
711: FROM EGO_MTL_SY_ITEMS_EXT_B A
712: WHERE (A.ORGANIZATION_ID, A.INVENTORY_ITEM_ID, A.REVISION_ID) IN
713: (SELECT ORGANIZATION_ID,
714: REVISED_ITEM_ID ,
715: NEW_ITEM_REVISION_ID

Line 1058: DELETE FROM EGO_MTL_SY_ITEMS_EXT_B A

1054: FROM ENG_REVISED_ITEMS
1055: WHERE NEW_ITEM_REVISION_ID IS NOT NULL
1056: AND REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
1057:
1058: DELETE FROM EGO_MTL_SY_ITEMS_EXT_B A
1059: WHERE A.REVISION_ID IN (SELECT NEW_ITEM_REVISION_ID
1060: FROM ENG_REVISED_ITEMS
1061: WHERE NEW_ITEM_REVISION_ID IS NOT NULL
1062: AND REVISED_ITEM_SEQUENCE_ID = rev_item_seq);

Line 1351: bug 8659653, after remove the revised item,the revised item should be deleted in table EGO_MTL_SY_ITEMS_EXT_B.

1347: APP_EXCEPTION.RAISE_EXCEPTION;
1348: END Change_Att_Status;
1349:
1350: /**
1351: bug 8659653, after remove the revised item,the revised item should be deleted in table EGO_MTL_SY_ITEMS_EXT_B.
1352: add the new procedure Delete_Revised_Item for it
1353: **/
1354: Procedure Delete_Revised_Item (
1355: rev_item_seq number

Line 1368: DELETE FROM EGO_MTL_SY_ITEMS_EXT_B A

1364: FROM ENG_REVISED_ITEMS
1365: WHERE NEW_ITEM_REVISION_ID IS NOT NULL
1366: AND REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
1367: stmt_num := 20;
1368: DELETE FROM EGO_MTL_SY_ITEMS_EXT_B A
1369: WHERE A.REVISION_ID IN (SELECT NEW_ITEM_REVISION_ID
1370: FROM ENG_REVISED_ITEMS
1371: WHERE NEW_ITEM_REVISION_ID IS NOT NULL
1372: AND REVISED_ITEM_SEQUENCE_ID = rev_item_seq);