Product: | HXC - Time and Labor Engine |
---|---|
Description: | |
Implementation/DBA Data: | APPS.HXC_ALIAS_DEFINITIONS_V |
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