1778:
1779: BEGIN
1780: SELECT segment1
1781: INTO arp_product_code_tab(i)
1782: FROM mtl_system_items
1783: WHERE inventory_item_id = l_product_id
1784: AND organization_id = l_master_org_id;
1785: EXCEPTION
1786: WHEN OTHERS THEN