VIEW: APPS.HXC_MAPPING_ATTRIBUTES_V

Source

View Text - Preformatted

SELECT hbbit.bld_blk_info_type_id, hm.name, hmc.name, hmc.field_name, hmc.segment, hbbit.bld_blk_info_type from hxc_mapping_components hmc, hxc_mapping_comp_usages hmcu, hxc_mappings hm, hxc_bld_blk_info_types hbbit WHERE hm.mapping_id = hmcu.mapping_id and hmcu.mapping_component_id = hmc.mapping_component_id and hbbit.bld_blk_info_type_id = hmc.bld_blk_info_type_id

View Text - HTML Formatted

SELECT HBBIT.BLD_BLK_INFO_TYPE_ID
, HM.NAME
, HMC.NAME
, HMC.FIELD_NAME
, HMC.SEGMENT
, HBBIT.BLD_BLK_INFO_TYPE
FROM HXC_MAPPING_COMPONENTS HMC
, HXC_MAPPING_COMP_USAGES HMCU
, HXC_MAPPINGS HM
, HXC_BLD_BLK_INFO_TYPES HBBIT
WHERE HM.MAPPING_ID = HMCU.MAPPING_ID
AND HMCU.MAPPING_COMPONENT_ID = HMC.MAPPING_COMPONENT_ID
AND HBBIT.BLD_BLK_INFO_TYPE_ID = HMC.BLD_BLK_INFO_TYPE_ID