49: hatc.component_type,hatc.component_name,bldu.building_block_category,
50: reference_object
51: from hxc_mapping_components hmc,
52: hxc_alias_types hat,
53: hxc_alias_type_components hatc,
54: hxc_alias_definitions had,
55: hxc_bld_blk_info_type_usages bldu,
56: hxc_bld_blk_info_types bld
57: where had.alias_definition_id = 1
1089: hatc.component_type,hatc.component_name,bldu.building_block_category,
1090: reference_object
1091: from hxc_mapping_components hmc,
1092: hxc_alias_types hat,
1093: hxc_alias_type_components hatc,
1094: hxc_alias_definitions had,
1095: hxc_bld_blk_info_type_usages bldu,
1096: hxc_bld_blk_info_types bld
1097: where had.alias_definition_id = p_alias_definition_id
1245: hatc.component_type,hatc.component_name,bldu.building_block_category,
1246: reference_object
1247: from hxc_mapping_components hmc,
1248: hxc_alias_types hat,
1249: hxc_alias_type_components hatc,
1250: hxc_alias_definitions had,
1251: hxc_bld_blk_info_type_usages bldu,
1252: hxc_bld_blk_info_types bld
1253: where had.alias_definition_id = p_alias_definition_id