APPS.ENGPKIMP dependencies on MTL_ITEM_REVISIONS_TL

Line 4094: Update mtl_item_revisions_tl MIR

4090: X_implementation_date => today);
4091: --Start of changes Bug 2963301
4092: Begin
4093: SELECT userenv('LANG') INTO l_language_code FROM dual;
4094: Update mtl_item_revisions_tl MIR
4095: set description =
4096: (select MIR1.description
4097: from mtl_item_revisions_tl MIR1
4098: where revision_id IN (SELECT revision_id

Line 4097: from mtl_item_revisions_tl MIR1

4093: SELECT userenv('LANG') INTO l_language_code FROM dual;
4094: Update mtl_item_revisions_tl MIR
4095: set description =
4096: (select MIR1.description
4097: from mtl_item_revisions_tl MIR1
4098: where revision_id IN (SELECT revision_id
4099: FROM MTL_ITEM_REVISIONS_B
4100: WHERE
4101: inventory_item_id = item.revised_item_id

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

4125: end if;
4126:
4127: end if; -- end of "if new_item_revision is not null"
4128:
4129: --- as there is no updation of description ,updation to mtl_item_revisions_tl is not required
4130: -- Moved this code here so that if new revision gets implemented rev effective structure will get implement successfully 5243333
4131: -- Added For 11510+ Enhancement
4132: -- Fetch the effectivity control of the bill
4133: Open get_bill_effectivity_control(bill_sequence_id);