89:
90: BEGIN
91:
92: --Bug 13023056 item number not shows fully in project inquiry screen, replace the MTL_SYSTEM_ITEMS_B/segment1
93: --with mtl_system_items_kfv/CONCATENATED_SEGMENTS (varchar40 as well).
94: SELECT CONCATENATED_SEGMENTS into L_Item_Number
95: from mtl_system_items_kfv
96: where inventory_item_id = X_Item_Id
97: and organization_id = X_Organization_Id;
91:
92: --Bug 13023056 item number not shows fully in project inquiry screen, replace the MTL_SYSTEM_ITEMS_B/segment1
93: --with mtl_system_items_kfv/CONCATENATED_SEGMENTS (varchar40 as well).
94: SELECT CONCATENATED_SEGMENTS into L_Item_Number
95: from mtl_system_items_kfv
96: where inventory_item_id = X_Item_Id
97: and organization_id = X_Organization_Id;
98:
99: RETURN ( L_Item_Number );