View: HXC_ALIAS_TYPES_V

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

View Text

SELECT HAT.ALIAS_TYPE_ID
, HAT.ALIAS_TYPE
, HAT.REFERENCE_OBJECT
, FF.FLEX_VALUE_SET_NAME D_REFERENCE_OBJECT_NAME
, HAT.LAST_UPDATE_DATE
, HAT.LAST_UPDATED_BY
, HAT.LAST_UPDATE_LOGIN
, HAT.CREATED_BY
, HAT.CREATION_DATE
, HAT.OBJECT_VERSION_NUMBER
, HR_BIS.BIS_DECODE_LOOKUP('HXC_ALT_NAME_TYPE'
, HAT.ALIAS_TYPE)
FROM HXC_ALIAS_TYPES HAT
, FND_FLEX_VALUE_SETS FF
WHERE (HAT.ALIAS_TYPE = 'VALUE_SET_NONE' OR HAT.ALIAS_TYPE = 'VALUE_SET_TABLE' OR HAT.ALIAS_TYPE = 'VALUE_SET_INDEPENDENT')
AND TO_CHAR(FF.FLEX_VALUE_SET_ID) = HAT.REFERENCE_OBJECT UNION SELECT HAT.ALIAS_TYPE_ID
, HAT.ALIAS_TYPE
, HAT.REFERENCE_OBJECT
, FDFC.DESCRIPTIVE_FLEX_CONTEXT_NAME D_REFERENCE_OBJECT_NAME
, HAT.LAST_UPDATE_DATE
, HAT.LAST_UPDATED_BY
, HAT.LAST_UPDATE_LOGIN
, HAT.CREATED_BY
, HAT.CREATION_DATE
, HAT.OBJECT_VERSION_NUMBER
, HR_BIS.BIS_DECODE_LOOKUP('HXC_ALT_NAME_TYPE'
, HAT.ALIAS_TYPE)
FROM HXC_ALIAS_TYPES HAT
, FND_DESCR_FLEX_CONTEXTS_VL FDFC
WHERE HAT.ALIAS_TYPE = 'OTL_ALT_DDF'
AND TO_CHAR(FDFC.DESCRIPTIVE_FLEX_CONTEXT_CODE) = HAT.REFERENCE_OBJECT

Columns