APPS.ENG_ECO_UTIL dependencies on MTL_ITEM_REVISIONS_B

Line 1230: -- update rev item's new revision in MTL_ITEM_REVISIONS_B

1226: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1227: END IF ;
1228:
1229: -- Modified query for performance bug 4251776
1230: -- update rev item's new revision in MTL_ITEM_REVISIONS_B
1231: UPDATE MTL_ITEM_REVISIONS_B
1232: SET effectivity_date = p_effectivity_date,
1233: last_update_date = sysdate
1234: WHERE change_notice = x_change_notice

Line 1231: UPDATE MTL_ITEM_REVISIONS_B

1227: END IF ;
1228:
1229: -- Modified query for performance bug 4251776
1230: -- update rev item's new revision in MTL_ITEM_REVISIONS_B
1231: UPDATE MTL_ITEM_REVISIONS_B
1232: SET effectivity_date = p_effectivity_date,
1233: last_update_date = sysdate
1234: WHERE change_notice = x_change_notice
1235: AND organization_id = x_organization_id

Line 1581: UPDATE MTL_ITEM_REVISIONS_B

1577: END IF ;
1578:
1579: -- Modified query for performance bug 4251776
1580: -- update rev item's new revision in MTL_ITEM_REVISIONS _B
1581: UPDATE MTL_ITEM_REVISIONS_B
1582: SET effectivity_date = p_effectivity_date,
1583: last_update_date = sysdate
1584: WHERE change_notice = x_change_notice
1585: AND organization_id = x_organization_id

Line 2177: from MTL_ITEM_REVISIONS_B I

2173: -- Delete item revisions created by revised items on ECO
2174:
2175: delete from MTL_ITEM_REVISIONS_TL
2176: where revision_id in(select revision_id
2177: from MTL_ITEM_REVISIONS_B I
2178: WHERE CHANGE_NOTICE = change_order
2179: AND ORGANIZATION_ID = org_id
2180: AND IMPLEMENTATION_DATE IS NULL
2181: AND INVENTORY_ITEM_ID IN

Line 2190: DELETE FROM MTL_ITEM_REVISIONS_B I

2186: AND R.REVISED_ITEM_SEQUENCE_ID = I.REVISED_ITEM_SEQUENCE_ID
2187: AND R.CANCELLATION_DATE IS NOT NULL));
2188:
2189:
2190: DELETE FROM MTL_ITEM_REVISIONS_B I
2191: WHERE CHANGE_NOTICE = change_order
2192: AND ORGANIZATION_ID = org_id
2193: AND IMPLEMENTATION_DATE IS NULL
2194: AND INVENTORY_ITEM_ID IN (SELECT REVISED_ITEM_ID