APPS.ENG_REVISED_ITEM_UTIL dependencies on MTL_ITEM_REVISIONS_TL

Line 367: /* delete from MTL_ITEM_REVISIONS_TL

363: DELETE FROM bom_components_b --BOM_INVENTORY_COMPONENTS IC -- R12: Modified for common bom changes
364: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq;
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

Line 372: 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
374: from eng_revised_items I
375: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
376: DELETE FROM MTL_ITEM_REVISIONS_B I

Line 1121: update MTL_ITEM_REVISIONS_TL

1117: RETURNING revision_id INTO l_revision_id;
1118:
1119:
1120: SELECT userenv('LANG') INTO l_language_code FROM dual;
1121: update MTL_ITEM_REVISIONS_TL
1122: set
1123: last_update_date = SYSDATE, --who column
1124: last_update_login = l_login_id, --who column
1125: last_updated_by = l_user_id, --who column

Line 1223: update MTL_ITEM_REVISIONS_TL

1219: AND revision = nvl( p_revised_item_rec.new_revised_item_revision,'NULL')
1220: RETURNING revision_id INTO l_revision_id;
1221:
1222: SELECT userenv('LANG') INTO l_language_code FROM dual;
1223: update MTL_ITEM_REVISIONS_TL
1224: set
1225: last_update_date = SYSDATE, --who column
1226: last_update_login = l_login_id, --who column
1227: last_updated_by = l_user_id, --who column

Line 1476: update MTL_ITEM_REVISIONS_TL

1472:
1473: /* Item revision description support Bug: 1667419*/
1474:
1475: SELECT userenv('LANG') INTO l_language_code FROM dual;
1476: update MTL_ITEM_REVISIONS_TL
1477: set
1478: last_update_date = SYSDATE, --who column
1479: last_update_login = l_login_id, --who column
1480: last_updated_by = l_user_id, --who column