View: HXC_LAYOUT_COMPONENTS_V

Product:	HXC - Time and Labor Engine
Description:
Implementation/DBA Data:	APPS.HXC_LAYOUT_COMPONENTS_V

View Text

SELECT /*+ INDEX (LAYQUAL HXC_LAYOUT_COMP_QUALIFIERS_FK1) */ COMP.LAYOUT_COMPONENT_ID
, COMP.LAYOUT_ID
, COMP.PARENT_COMPONENT_ID
, COMP.COMPONENT_NAME
, COMP.COMPONENT_VALUE
, COMP.SEQUENCE
, COMP.NAME_VALUE_STRING
, COMPDEF.COMPONENT_TYPE
, COMPDEF.COMPONENT_CLASS
, COMPDEF.RENDER_TYPE
, AKTL.ATTRIBUTE_LABEL_LONG LABEL
, AKTL.DESCRIPTION
, AK.CSS_LABEL_CLASS_NAME CSS_CLASS
, COMP.COMPONENT_ALIAS
, COMP.PARENT_BEAN
, COMP.ATTRIBUTE1
, COMP.ATTRIBUTE2
, COMP.ATTRIBUTE3
, COMP.ATTRIBUTE4
, COMP.ATTRIBUTE5
, LAYQUAL.QUALIFIER_NAME
, LAYQUAL.QUALIFIER_ATTRIBUTE_CATEGORY
, LAYQUAL.QUALIFIER_ATTRIBUTE1
, LAYQUAL.QUALIFIER_ATTRIBUTE2
, LAYQUAL.QUALIFIER_ATTRIBUTE3
, LAYQUAL.QUALIFIER_ATTRIBUTE4
, LAYQUAL.QUALIFIER_ATTRIBUTE5
, LAYQUAL.QUALIFIER_ATTRIBUTE6
, LAYQUAL.QUALIFIER_ATTRIBUTE7
, LAYQUAL.QUALIFIER_ATTRIBUTE8
, LAYQUAL.QUALIFIER_ATTRIBUTE9
, LAYQUAL.QUALIFIER_ATTRIBUTE10
, LAYQUAL.QUALIFIER_ATTRIBUTE11
, LAYQUAL.QUALIFIER_ATTRIBUTE12
, LAYQUAL.QUALIFIER_ATTRIBUTE13
, LAYQUAL.QUALIFIER_ATTRIBUTE14
, LAYQUAL.QUALIFIER_ATTRIBUTE15
, LAYQUAL.QUALIFIER_ATTRIBUTE16
, LAYQUAL.QUALIFIER_ATTRIBUTE17
, LAYQUAL.QUALIFIER_ATTRIBUTE18
, LAYQUAL.QUALIFIER_ATTRIBUTE19
, LAYQUAL.QUALIFIER_ATTRIBUTE20
, LAYQUAL.QUALIFIER_ATTRIBUTE21
, LAYQUAL.QUALIFIER_ATTRIBUTE22
, LAYQUAL.QUALIFIER_ATTRIBUTE23
, LAYQUAL.QUALIFIER_ATTRIBUTE24
, LAYQUAL.QUALIFIER_ATTRIBUTE25
, LAYQUAL.QUALIFIER_ATTRIBUTE26
, LAYQUAL.QUALIFIER_ATTRIBUTE27
, LAYQUAL.QUALIFIER_ATTRIBUTE28
, LAYQUAL.QUALIFIER_ATTRIBUTE29
, LAYQUAL.QUALIFIER_ATTRIBUTE30
FROM HXC_LAYOUT_COMPONENTS COMP
, HXC_LAYOUT_COMP_DEFINITIONS COMPDEF
, HXC_LAYOUT_COMP_QUALIFIERS LAYQUAL
, AK_REGION_ITEMS AK
, AK_REGION_ITEMS_TL AKTL
WHERE COMP.LAYOUT_COMP_DEFINITION_ID = COMPDEF.LAYOUT_COMP_DEFINITION_ID
AND COMP.LAYOUT_COMPONENT_ID = LAYQUAL.LAYOUT_COMPONENT_ID (+)
AND COMP.REGION_CODE = AK.REGION_CODE (+)
AND COMP.REGION_CODE_APP_ID = AK.REGION_APPLICATION_ID (+)
AND COMP.ATTRIBUTE_CODE = AK.ATTRIBUTE_CODE (+)
AND COMP.ATTRIBUTE_CODE_APP_ID = AK.ATTRIBUTE_APPLICATION_ID (+)
AND AK.REGION_CODE = AKTL.REGION_CODE (+)
AND AK.REGION_APPLICATION_ID = AKTL.REGION_APPLICATION_ID (+)
AND AK.ATTRIBUTE_CODE = AKTL.ATTRIBUTE_CODE (+)
AND AK.ATTRIBUTE_APPLICATION_ID = AKTL.ATTRIBUTE_APPLICATION_ID (+)
AND AKTL.LANGUAGE (+) = USERENV('LANG')

Columns