Line 126: and organization_id = cs_std.get_item_valdn_orgzn_id;
122: concatenated_segments,
123: serial_number_control_code
124: from mtl_system_items_kfv
125: where inventory_item_id = p_inventory_item_id 126: and organization_id = cs_std.get_item_valdn_orgzn_id; 127:
128: -- Cursor to get owner
129: Cursor c_get_ib_owner ( p_inventory_item_id in number,p_serial_number in varchar2) is
130: Select owner_party_id,