View: HXC_MAPPING_ATTRIBUTES_V

Product:	HXC - Time and Labor Engine
Description:
Implementation/DBA Data:	APPS.HXC_MAPPING_ATTRIBUTES_V

View Text

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

Columns