APPS.ENG_REVISED_ITEM_UTIL dependencies on MTL_ITEM_REVISIONS_TL

Line 350: /* delete from MTL_ITEM_REVISIONS_TL

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

Line 355: 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
357: from eng_revised_items I
358: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
359: DELETE FROM MTL_ITEM_REVISIONS_B I

Line 1104: update MTL_ITEM_REVISIONS_TL

1100: RETURNING revision_id INTO l_revision_id;
1101:
1102:
1103: SELECT userenv('LANG') INTO l_language_code FROM dual;
1104: update MTL_ITEM_REVISIONS_TL
1105: set
1106: last_update_date = SYSDATE, --who column
1107: last_update_login = l_login_id, --who column
1108: last_updated_by = l_user_id, --who column

Line 1206: update MTL_ITEM_REVISIONS_TL

1202: AND revision = nvl( p_revised_item_rec.new_revised_item_revision,'NULL')
1203: RETURNING revision_id INTO l_revision_id;
1204:
1205: SELECT userenv('LANG') INTO l_language_code FROM dual;
1206: update MTL_ITEM_REVISIONS_TL
1207: set
1208: last_update_date = SYSDATE, --who column
1209: last_update_login = l_login_id, --who column
1210: last_updated_by = l_user_id, --who column

Line 1458: update MTL_ITEM_REVISIONS_TL

1454:
1455: /* Item revision description support Bug: 1667419*/
1456:
1457: SELECT userenv('LANG') INTO l_language_code FROM dual;
1458: update MTL_ITEM_REVISIONS_TL
1459: set
1460: last_update_date = SYSDATE, --who column
1461: last_update_login = l_login_id, --who column
1462: last_updated_by = l_user_id, --who column