APPS.ENGPKIMP dependencies on MTL_ITEM_REVISIONS_TL

Line 4352: Update mtl_item_revisions_tl MIR

4348: X_implementation_date => today);
4349: --Start of changes Bug 2963301
4350: Begin
4351: SELECT userenv('LANG') INTO l_language_code FROM dual;
4352: Update mtl_item_revisions_tl MIR
4353: set description =
4354: (select MIR1.description
4355: from mtl_item_revisions_tl MIR1
4356: where revision_id IN (SELECT revision_id

Line 4355: from mtl_item_revisions_tl MIR1

4351: SELECT userenv('LANG') INTO l_language_code FROM dual;
4352: Update mtl_item_revisions_tl MIR
4353: set description =
4354: (select MIR1.description
4355: from mtl_item_revisions_tl MIR1
4356: where revision_id IN (SELECT revision_id
4357: FROM MTL_ITEM_REVISIONS_B
4358: WHERE
4359: inventory_item_id = item.revised_item_id

Line 4387: --- as there is no updation of description ,updation to mtl_item_revisions_tl is not required

4383: end if;
4384:
4385: end if; -- end of "if new_item_revision is not null"
4386:
4387: --- as there is no updation of description ,updation to mtl_item_revisions_tl is not required
4388: -- Moved this code here so that if new revision gets implemented rev effective structure will get implement successfully 5243333
4389: -- Added For 11510+ Enhancement
4390: -- Fetch the effectivity control of the bill
4391: Open get_bill_effectivity_control(bill_sequence_id);