1251: CURSOR get_alias_columns ( p_alias_def NUMBER)
1252: IS SELECT 'MAX(DECODE(bld_blk_info_type_id,'||hmc.bld_blk_info_type_id||','
1253: ||DECODE(segment,'ATTRIBUTE_CATEGORY','LTRIM(ha.'||segment||','''||building_block_category||' - '')','ha.'||segment)||'))',
1254: hatc.component_type
1255: FROM hxc_mapping_components hmc,
1256: hxc_alias_types hat,
1257: hxc_alias_type_components hatc,
1258: hxc_alias_definitions had,
1259: hxc_bld_blk_info_type_usages bldu,