DBA Data[Home] [Help]

APPS.PO_ITEMS_SV dependencies on MTL_SYSTEM_ITEMS_TL

Line 458: ** is added to get the description from mtl_system_items_tl.

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

Line 464: FROM mtl_system_items_tl

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: