VIEW: APPS.HXC_ALIAS_TYPES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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