Product: | HXC - Time and Labor Engine |
---|---|
Description: | |
Implementation/DBA Data: | APPS.HXC_PREF_HIERARCHIES_V |
SELECT HPH.ROWID ROW_ID
, HPH.PREF_HIERARCHY_ID
, HPH.TYPE
, HPH.NAME PREF_HIERARCHY
, HPH.BUSINESS_GROUP_ID
, HPH.LEGISLATION_CODE
, HPH.EDIT_ALLOWED
, HPH.DISPLAYED
, HPH.PARENT_PREF_HIERARCHY_ID
, (SELECT NAME
FROM HXC_PREF_HIERARCHIES
WHERE HPH.PARENT_PREF_HIERARCHY_ID = PREF_HIERARCHY_ID ) PARENT_PREF_HIERARCHY
, HPH.PREF_DEFINITION_ID
, NVL( (SELECT DF.DESCRIPTIVE_FLEX_CONTEXT_NAME
FROM FND_DESCR_FLEX_CONTEXTS_VL DF
, HXC_PREF_DEFINITIONS HPD
WHERE DF.APPLICATION_ID =809
AND DF.DESCRIPTIVE_FLEXFIELD_NAME ='OTC PREFERENCES'
AND DF.DESCRIPTIVE_FLEX_CONTEXT_CODE = HPD.CODE
AND HPH.PREF_DEFINITION_ID = HPD.PREF_DEFINITION_ID)
, TO_CHAR(NULL) ) PREFERENCE_NAME
, HPH.ATTRIBUTE_CATEGORY
, HPH.ATTRIBUTE1
, HPH.ATTRIBUTE2
, HPH.ATTRIBUTE3
, HPH.ATTRIBUTE4
, HPH.ATTRIBUTE5
, HPH.ATTRIBUTE6
, HPH.ATTRIBUTE7
, HPH.ATTRIBUTE8
, HPH.ATTRIBUTE9
, HPH.ATTRIBUTE10
, HPH.ATTRIBUTE11
, HPH.ATTRIBUTE12
, HPH.ATTRIBUTE13
, HPH.ATTRIBUTE14
, HPH.ATTRIBUTE15
, HPH.ATTRIBUTE16
, HPH.ATTRIBUTE17
, HPH.ATTRIBUTE18
, HPH.ATTRIBUTE19
, HPH.ATTRIBUTE20
, HPH.ATTRIBUTE21
, HPH.ATTRIBUTE22
, HPH.ATTRIBUTE23
, HPH.ATTRIBUTE24
, HPH.ATTRIBUTE25
, HPH.ATTRIBUTE26
, HPH.ATTRIBUTE27
, HPH.ATTRIBUTE28
, HPH.ATTRIBUTE29
, HPH.ATTRIBUTE30
, HPH.ORIG_PREF_HIERARCHY_ID
, HPH.ORIG_PARENT_HIERARCHY_ID
, HPH.OBJECT_VERSION_NUMBER
, HPH.CREATED_BY
, HPH.CREATION_DATE
, HPH.LAST_UPDATED_BY
, HPH.LAST_UPDATE_DATE
, HPH.LAST_UPDATE_LOGIN
, HPH.TOP_LEVEL_PARENT_ID
, HPH.CODE
FROM HXC_PREF_HIERARCHIES HPH