1703:
1704: BEGIN
1705: SELECT segment1
1706: INTO arp_product_code_tab(i)
1707: FROM mtl_system_items
1708: WHERE inventory_item_id = l_product_id
1709: AND organization_id = l_master_org_id;
1710: EXCEPTION
1711: WHEN OTHERS THEN