APPS.ENG_REVISED_ITEM_UTIL dependencies on MTL_ITEM_REVISIONS_B

Line 369: from MTL_ITEM_REVISIONS_B

365:
366: -- Delete item revisions created by revised items on ECO
367: /* delete from MTL_ITEM_REVISIONS_TL
368: where revision_id IN (select revision_id
369: from MTL_ITEM_REVISIONS_B
370: where REVISED_ITEM_SEQUENCE_ID = rev_item_seq);*/
371: -- Added revision_id to where clause for performance bug 4251776
372: delete from MTL_ITEM_REVISIONS_TL
373: where revision_id IN (select new_item_revision_id

Line 376: DELETE FROM MTL_ITEM_REVISIONS_B I

372: delete from MTL_ITEM_REVISIONS_TL
373: where revision_id IN (select new_item_revision_id
374: from eng_revised_items I
375: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
376: DELETE FROM MTL_ITEM_REVISIONS_B I
377: where revision_id IN (select new_item_revision_id
378: from eng_revised_items I
379: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
380: /*WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq;*/

Line 1072: UPDATE MTL_ITEM_REVISIONS_B

1068: );
1069: */
1070:
1071:
1072: UPDATE MTL_ITEM_REVISIONS_B
1073: SET revision =
1074: DECODE( p_revised_item_rec.updated_revised_item_revision
1075: , FND_API.G_MISS_CHAR
1076: , p_revised_item_rec.new_revised_item_revision

Line 1187: UPDATE MTL_ITEM_REVISIONS_B

1183: /* Item revision description support Bug: 1667419*/
1184: ELSIF Eng_Default_Revised_Item.G_DEL_UPD_INS_ITEM_REV = 0
1185: THEN
1186:
1187: UPDATE MTL_ITEM_REVISIONS_B
1188: SET
1189: description = Decode(p_revised_item_rec.new_revised_item_rev_desc,
1190: FND_API.G_MISS_CHAR,
1191: description,

Line 1445: UPDATE MTL_ITEM_REVISIONS_B

1441: AND inventory_item_id = p_rev_item_unexp_rec.revised_item_id
1442: AND revised_item_sequence_id = p_rev_item_unexp_rec.revised_item_sequence_id ;
1443:
1444:
1445: UPDATE MTL_ITEM_REVISIONS_B
1446: SET effectivity_date =
1447: DECODE( DECODE( p_revised_item_rec.new_effective_date
1448: , to_date(NULL)
1449: , p_revised_item_rec.start_effective_date

Line 2546: UPDATE MTL_ITEM_REVISIONS_B

2542: OPEN c_revised_item(cp_revised_item_sequence_id => p_revised_item_sequence_id);
2543: FETCH c_revised_item INTO l_rev_item;
2544:
2545: -- update item revision
2546: UPDATE MTL_ITEM_REVISIONS_B
2547: SET effectivity_date = p_effectivity_date,
2548: last_update_date = sysdate,
2549: last_updated_by = l_user_id,
2550: last_update_login = l_login_id