878: cursor crs_mapping_info is
879: select hmc.bld_blk_info_type_id,segment,bld_blk_info_type,
880: hatc.component_type,hatc.component_name,bldu.building_block_category,
881: reference_object
882: from hxc_mapping_components hmc,
883: hxc_alias_types hat,
884: hxc_alias_type_components hatc,
885: hxc_alias_definitions had,
886: hxc_bld_blk_info_type_usages bldu,
981: cursor crs_mapping_info is
982: select hmc.bld_blk_info_type_id,segment,bld_blk_info_type,
983: hatc.component_type,hatc.component_name,bldu.building_block_category,
984: reference_object
985: from hxc_mapping_components hmc,
986: hxc_alias_types hat,
987: hxc_alias_type_components hatc,
988: hxc_alias_definitions had,
989: hxc_bld_blk_info_type_usages bldu,