454: /*
455: ** Bug 2198247. The item description should be
456: ** fetched from mtl_system_item_tl not from
457: ** mtl_system_items. So the following SELECT statement
458: ** is added to get the description from mtl_system_items_tl.
459: */
460:
461:
462: SELECT description
460:
461:
462: SELECT description
463: INTO X_item_description
464: FROM mtl_system_items_tl
465: WHERE inventory_item_id = X_item_id
466: AND language = USERENV('LANG')
467: AND organization_id = X_inventory_organization_id;
468: