VIEW: APPS.HXC_ALIAS_DEFINITIONS_V

Source

View Text - Preformatted

SELECT ad.ALIAS_DEFINITION_ID, adtl.ALIAS_DEFINITION_NAME, ff.DESCRIPTIVE_FLEX_CONTEXT_NAME, ad.ALIAS_CONTEXT_CODE, ad.business_group_id, ad.legislation_code, adtl.DESCRIPTION, ad.LAST_UPDATE_DATE, ad.LAST_UPDATED_BY, ad.LAST_UPDATE_LOGIN, ad.CREATED_BY, ad.CREATION_DATE, ad.OBJECT_VERSION_NUMBER, hat.alias_type, hat.alias_type_id, adtl.prompt FROM hxc_alias_definitions ad, hxc_alias_definitions_tl adtl, hxc_alias_types hat, fnd_descr_flex_contexts_vl ff WHERE ad.ALIAS_DEFINITION_ID = adtl.ALIAS_DEFINITION_ID AND adtl.LANGUAGE = userenv('LANG') and hat.reference_object = to_char(ff.descriptive_flex_context_code) and hat.alias_type = 'OTL_ALT_DDF' and hat.alias_type_id = ad.alias_type_id Union SELECT ad.ALIAS_DEFINITION_ID, adtl.ALIAS_DEFINITION_NAME, ff.FLEX_VALUE_SET_NAME, ad.ALIAS_CONTEXT_CODE, ad.business_group_id, ad.legislation_code, adtl.DESCRIPTION, ad.LAST_UPDATE_DATE, ad.LAST_UPDATED_BY, ad.LAST_UPDATE_LOGIN, ad.CREATED_BY, ad.CREATION_DATE, ad.OBJECT_VERSION_NUMBER, hat.alias_type, hat.alias_type_id, adtl.prompt from hxc_alias_definitions ad, hxc_alias_definitions_tl adtl, hxc_alias_types hat, fnd_flex_value_sets ff where ad.ALIAS_DEFINITION_ID = adtl.ALIAS_DEFINITION_ID AND adtl.LANGUAGE = userenv('LANG') and hat.reference_object =to_char(ff.FLEX_VALUE_SET_ID) and hat.ALIAS_TYPE in ('VALUE_SET_NONE','VALUE_SET_TABLE','VALUE_SET_INDEPENDENT') and hat.alias_type_id = ad.alias_type_id

View Text - HTML Formatted

SELECT AD.ALIAS_DEFINITION_ID
, ADTL.ALIAS_DEFINITION_NAME
, FF.DESCRIPTIVE_FLEX_CONTEXT_NAME
, AD.ALIAS_CONTEXT_CODE
, AD.BUSINESS_GROUP_ID
, AD.LEGISLATION_CODE
, ADTL.DESCRIPTION
, AD.LAST_UPDATE_DATE
, AD.LAST_UPDATED_BY
, AD.LAST_UPDATE_LOGIN
, AD.CREATED_BY
, AD.CREATION_DATE
, AD.OBJECT_VERSION_NUMBER
, HAT.ALIAS_TYPE
, HAT.ALIAS_TYPE_ID
, ADTL.PROMPT
FROM HXC_ALIAS_DEFINITIONS AD
, HXC_ALIAS_DEFINITIONS_TL ADTL
, HXC_ALIAS_TYPES HAT
, FND_DESCR_FLEX_CONTEXTS_VL FF
WHERE AD.ALIAS_DEFINITION_ID = ADTL.ALIAS_DEFINITION_ID
AND ADTL.LANGUAGE = USERENV('LANG')
AND HAT.REFERENCE_OBJECT = TO_CHAR(FF.DESCRIPTIVE_FLEX_CONTEXT_CODE)
AND HAT.ALIAS_TYPE = 'OTL_ALT_DDF'
AND HAT.ALIAS_TYPE_ID = AD.ALIAS_TYPE_ID UNION SELECT AD.ALIAS_DEFINITION_ID
, ADTL.ALIAS_DEFINITION_NAME
, FF.FLEX_VALUE_SET_NAME
, AD.ALIAS_CONTEXT_CODE
, AD.BUSINESS_GROUP_ID
, AD.LEGISLATION_CODE
, ADTL.DESCRIPTION
, AD.LAST_UPDATE_DATE
, AD.LAST_UPDATED_BY
, AD.LAST_UPDATE_LOGIN
, AD.CREATED_BY
, AD.CREATION_DATE
, AD.OBJECT_VERSION_NUMBER
, HAT.ALIAS_TYPE
, HAT.ALIAS_TYPE_ID
, ADTL.PROMPT
FROM HXC_ALIAS_DEFINITIONS AD
, HXC_ALIAS_DEFINITIONS_TL ADTL
, HXC_ALIAS_TYPES HAT
, FND_FLEX_VALUE_SETS FF
WHERE AD.ALIAS_DEFINITION_ID = ADTL.ALIAS_DEFINITION_ID
AND ADTL.LANGUAGE = USERENV('LANG')
AND HAT.REFERENCE_OBJECT =TO_CHAR(FF.FLEX_VALUE_SET_ID)
AND HAT.ALIAS_TYPE IN ('VALUE_SET_NONE'
, 'VALUE_SET_TABLE'
, 'VALUE_SET_INDEPENDENT')
AND HAT.ALIAS_TYPE_ID = AD.ALIAS_TYPE_ID