222: upper(replace(replace(hoi2.org_information2,'-',''),',','')) naics, --removed hyphens and commas bug 13905482
223: upper(replace(replace(hoi2.org_information4,'-',''),',','')) duns, --removed hyphens and commas bug 13905482
224: upper(replace(replace(hoi2.org_information3,'-',''),',','')) ein --removed hyphens and commas bug 13905482
225: from per_gen_hierarchy_nodes pgn,
226: hr_all_organization_units hou,
227: hr_organization_information hoi1,
228: hr_organization_information hoi2,
229: hr_locations_all loc
230: where pgn.hierarchy_version_id = p_hierarchy_version_id