VIEW: APPS.HXC_PREF_HIERARCHIES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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