APPS.ENG_REVISED_ITEM_UTIL dependencies on MTL_ITEM_REVISIONS_B

Line 352: from MTL_ITEM_REVISIONS_B

348:
349: -- Delete item revisions created by revised items on ECO
350: /* delete from MTL_ITEM_REVISIONS_TL
351: where revision_id IN (select revision_id
352: from MTL_ITEM_REVISIONS_B
353: where REVISED_ITEM_SEQUENCE_ID = rev_item_seq);*/
354: -- Added revision_id to where clause for performance bug 4251776
355: delete from MTL_ITEM_REVISIONS_TL
356: where revision_id IN (select new_item_revision_id

Line 359: DELETE FROM MTL_ITEM_REVISIONS_B I

355: delete from MTL_ITEM_REVISIONS_TL
356: where revision_id IN (select new_item_revision_id
357: from eng_revised_items I
358: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
359: DELETE FROM MTL_ITEM_REVISIONS_B I
360: where revision_id IN (select new_item_revision_id
361: from eng_revised_items I
362: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
363: /*WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq;*/

Line 1055: UPDATE MTL_ITEM_REVISIONS_B

1051: );
1052: */
1053:
1054:
1055: UPDATE MTL_ITEM_REVISIONS_B
1056: SET revision =
1057: DECODE( p_revised_item_rec.updated_revised_item_revision
1058: , FND_API.G_MISS_CHAR
1059: , p_revised_item_rec.new_revised_item_revision

Line 1170: UPDATE MTL_ITEM_REVISIONS_B

1166: /* Item revision description support Bug: 1667419*/
1167: ELSIF Eng_Default_Revised_Item.G_DEL_UPD_INS_ITEM_REV = 0
1168: THEN
1169:
1170: UPDATE MTL_ITEM_REVISIONS_B
1171: SET
1172: description = Decode(p_revised_item_rec.new_revised_item_rev_desc,
1173: FND_API.G_MISS_CHAR,
1174: description,

Line 1427: UPDATE MTL_ITEM_REVISIONS_B

1423: AND inventory_item_id = p_rev_item_unexp_rec.revised_item_id
1424: AND revised_item_sequence_id = p_rev_item_unexp_rec.revised_item_sequence_id ;
1425:
1426:
1427: UPDATE MTL_ITEM_REVISIONS_B
1428: SET effectivity_date =
1429: DECODE( DECODE( p_revised_item_rec.new_effective_date
1430: , to_date(NULL)
1431: , p_revised_item_rec.start_effective_date

Line 2522: UPDATE MTL_ITEM_REVISIONS_B

2518: OPEN c_revised_item(cp_revised_item_sequence_id => p_revised_item_sequence_id);
2519: FETCH c_revised_item INTO l_rev_item;
2520:
2521: -- update item revision
2522: UPDATE MTL_ITEM_REVISIONS_B
2523: SET effectivity_date = p_effectivity_date,
2524: last_update_date = sysdate,
2525: last_updated_by = l_user_id,
2526: last_update_login = l_login_id