View: HXC_TIMECARD_ATTRIBUTES_V

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

View Text

SELECT HTDETAIL.DETAIL_TIMECARD_ID
, HTDETAIL.DETAIL_OBJECT_VERSION
, HTDETAIL.DETAIL_PARENT_TIMECARD_ID
, HTDETAIL.DETAIL_PARENT_OBJECT_VERSION
, DECODE(HTDETAIL.DETAIL_ATTRIBUTE_CATEGORY
, HMA_PROJECT.CONTEXT
, DECODE(HMA_PROJECT.SEGMENT
, 'ATTRIBUTE1'
, HTDETAIL.DETAIL_ATTRIBUTE1
, 'ATTRIBUTE2'
, HTDETAIL.DETAIL_ATTRIBUTE2
, 'ATTRIBUTE3'
, HTDETAIL.DETAIL_ATTRIBUTE3
, 'ATTRIBUTE4'
, HTDETAIL.DETAIL_ATTRIBUTE4
, 'ATTRIBUTE5'
, HTDETAIL.DETAIL_ATTRIBUTE5
, 'ATTRIBUTE6'
, HTDETAIL.DETAIL_ATTRIBUTE6
, 'ATTRIBUTE7'
, HTDETAIL.DETAIL_ATTRIBUTE7
, 'ATTRIBUTE8'
, HTDETAIL.DETAIL_ATTRIBUTE8
, 'ATTRIBUTE9'
, HTDETAIL.DETAIL_ATTRIBUTE9
, 'ATTRIBUTE10'
, HTDETAIL.DETAIL_ATTRIBUTE10
, 'ATTRIBUTE11'
, HTDETAIL.DETAIL_ATTRIBUTE11
, 'ATTRIBUTE12'
, HTDETAIL.DETAIL_ATTRIBUTE12
, 'ATTRIBUTE13'
, HTDETAIL.DETAIL_ATTRIBUTE13
, 'ATTRIBUTE14'
, HTDETAIL.DETAIL_ATTRIBUTE14
, 'ATTRIBUTE15'
, HTDETAIL.DETAIL_ATTRIBUTE15
, 'ATTRIBUTE16'
, HTDETAIL.DETAIL_ATTRIBUTE16
, 'ATTRIBUTE17'
, HTDETAIL.DETAIL_ATTRIBUTE17
, 'ATTRIBUTE18'
, HTDETAIL.DETAIL_ATTRIBUTE18
, 'ATTRIBUTE19'
, HTDETAIL.DETAIL_ATTRIBUTE19
, 'ATTRIBUTE20'
, HTDETAIL.DETAIL_ATTRIBUTE20
, 'ATTRIBUTE21'
, HTDETAIL.DETAIL_ATTRIBUTE21
, 'ATTRIBUTE22'
, HTDETAIL.DETAIL_ATTRIBUTE22
, 'ATTRIBUTE23'
, HTDETAIL.DETAIL_ATTRIBUTE23
, 'ATTRIBUTE24'
, HTDETAIL.DETAIL_ATTRIBUTE24
, 'ATTRIBUTE25'
, HTDETAIL.DETAIL_ATTRIBUTE25
, 'ATTRIBUTE26'
, HTDETAIL.DETAIL_ATTRIBUTE26
, 'ATTRIBUTE27'
, HTDETAIL.DETAIL_ATTRIBUTE27
, 'ATTRIBUTE28'
, HTDETAIL.DETAIL_ATTRIBUTE28
, 'ATTRIBUTE29'
, HTDETAIL.DETAIL_ATTRIBUTE29
, 'ATTRIBUTE30'
, HTDETAIL.DETAIL_ATTRIBUTE30 )
, NULL)
, DECODE(HTDETAIL.DETAIL_ATTRIBUTE_CATEGORY
, HMA_TASK.CONTEXT
, DECODE(HMA_TASK.SEGMENT
, 'ATTRIBUTE1'
, HTDETAIL.DETAIL_ATTRIBUTE1
, 'ATTRIBUTE2'
, HTDETAIL.DETAIL_ATTRIBUTE2
, 'ATTRIBUTE3'
, HTDETAIL.DETAIL_ATTRIBUTE3
, 'ATTRIBUTE4'
, HTDETAIL.DETAIL_ATTRIBUTE4
, 'ATTRIBUTE5'
, HTDETAIL.DETAIL_ATTRIBUTE5
, 'ATTRIBUTE6'
, HTDETAIL.DETAIL_ATTRIBUTE6
, 'ATTRIBUTE7'
, HTDETAIL.DETAIL_ATTRIBUTE7
, 'ATTRIBUTE8'
, HTDETAIL.DETAIL_ATTRIBUTE8
, 'ATTRIBUTE9'
, HTDETAIL.DETAIL_ATTRIBUTE9
, 'ATTRIBUTE10'
, HTDETAIL.DETAIL_ATTRIBUTE10
, 'ATTRIBUTE11'
, HTDETAIL.DETAIL_ATTRIBUTE11
, 'ATTRIBUTE12'
, HTDETAIL.DETAIL_ATTRIBUTE12
, 'ATTRIBUTE13'
, HTDETAIL.DETAIL_ATTRIBUTE13
, 'ATTRIBUTE14'
, HTDETAIL.DETAIL_ATTRIBUTE14
, 'ATTRIBUTE15'
, HTDETAIL.DETAIL_ATTRIBUTE15
, 'ATTRIBUTE16'
, HTDETAIL.DETAIL_ATTRIBUTE16
, 'ATTRIBUTE17'
, HTDETAIL.DETAIL_ATTRIBUTE17
, 'ATTRIBUTE18'
, HTDETAIL.DETAIL_ATTRIBUTE18
, 'ATTRIBUTE19'
, HTDETAIL.DETAIL_ATTRIBUTE19
, 'ATTRIBUTE20'
, HTDETAIL.DETAIL_ATTRIBUTE20
, 'ATTRIBUTE21'
, HTDETAIL.DETAIL_ATTRIBUTE21
, 'ATTRIBUTE22'
, HTDETAIL.DETAIL_ATTRIBUTE22
, 'ATTRIBUTE23'
, HTDETAIL.DETAIL_ATTRIBUTE23
, 'ATTRIBUTE24'
, HTDETAIL.DETAIL_ATTRIBUTE24
, 'ATTRIBUTE25'
, HTDETAIL.DETAIL_ATTRIBUTE25
, 'ATTRIBUTE26'
, HTDETAIL.DETAIL_ATTRIBUTE26
, 'ATTRIBUTE27'
, HTDETAIL.DETAIL_ATTRIBUTE27
, 'ATTRIBUTE28'
, HTDETAIL.DETAIL_ATTRIBUTE28
, 'ATTRIBUTE29'
, HTDETAIL.DETAIL_ATTRIBUTE29
, 'ATTRIBUTE30'
, HTDETAIL.DETAIL_ATTRIBUTE30 )
, NULL)
, DECODE(HTDETAIL.DETAIL_ATTRIBUTE_CATEGORY
, HMA_EXPENDITURE.CONTEXT
, DECODE(HMA_EXPENDITURE.SEGMENT
, 'ATTRIBUTE1'
, HTDETAIL.DETAIL_ATTRIBUTE1
, 'ATTRIBUTE2'
, HTDETAIL.DETAIL_ATTRIBUTE2
, 'ATTRIBUTE3'
, HTDETAIL.DETAIL_ATTRIBUTE3
, 'ATTRIBUTE4'
, HTDETAIL.DETAIL_ATTRIBUTE4
, 'ATTRIBUTE5'
, HTDETAIL.DETAIL_ATTRIBUTE5
, 'ATTRIBUTE6'
, HTDETAIL.DETAIL_ATTRIBUTE6
, 'ATTRIBUTE7'
, HTDETAIL.DETAIL_ATTRIBUTE7
, 'ATTRIBUTE8'
, HTDETAIL.DETAIL_ATTRIBUTE8
, 'ATTRIBUTE9'
, HTDETAIL.DETAIL_ATTRIBUTE9
, 'ATTRIBUTE10'
, HTDETAIL.DETAIL_ATTRIBUTE10
, 'ATTRIBUTE11'
, HTDETAIL.DETAIL_ATTRIBUTE11
, 'ATTRIBUTE12'
, HTDETAIL.DETAIL_ATTRIBUTE12
, 'ATTRIBUTE13'
, HTDETAIL.DETAIL_ATTRIBUTE13
, 'ATTRIBUTE14'
, HTDETAIL.DETAIL_ATTRIBUTE14
, 'ATTRIBUTE15'
, HTDETAIL.DETAIL_ATTRIBUTE15
, 'ATTRIBUTE16'
, HTDETAIL.DETAIL_ATTRIBUTE16
, 'ATTRIBUTE17'
, HTDETAIL.DETAIL_ATTRIBUTE17
, 'ATTRIBUTE18'
, HTDETAIL.DETAIL_ATTRIBUTE18
, 'ATTRIBUTE19'
, HTDETAIL.DETAIL_ATTRIBUTE19
, 'ATTRIBUTE20'
, HTDETAIL.DETAIL_ATTRIBUTE20
, 'ATTRIBUTE21'
, HTDETAIL.DETAIL_ATTRIBUTE21
, 'ATTRIBUTE22'
, HTDETAIL.DETAIL_ATTRIBUTE22
, 'ATTRIBUTE23'
, HTDETAIL.DETAIL_ATTRIBUTE23
, 'ATTRIBUTE24'
, HTDETAIL.DETAIL_ATTRIBUTE24
, 'ATTRIBUTE25'
, HTDETAIL.DETAIL_ATTRIBUTE25
, 'ATTRIBUTE26'
, HTDETAIL.DETAIL_ATTRIBUTE26
, 'ATTRIBUTE27'
, HTDETAIL.DETAIL_ATTRIBUTE27
, 'ATTRIBUTE28'
, HTDETAIL.DETAIL_ATTRIBUTE28
, 'ATTRIBUTE29'
, HTDETAIL.DETAIL_ATTRIBUTE29
, 'ATTRIBUTE30'
, HTDETAIL.DETAIL_ATTRIBUTE30 )
, NULL)
, DECODE(HTDETAIL.DETAIL_ATTRIBUTE_CATEGORY
, HMA_HOURS_TYPE.CONTEXT
, SUBSTR(DECODE(HMA_HOURS_TYPE.SEGMENT
, 'ATTRIBUTE1'
, HTDETAIL.DETAIL_ATTRIBUTE1
, 'ATTRIBUTE2'
, HTDETAIL.DETAIL_ATTRIBUTE2
, 'ATTRIBUTE3'
, HTDETAIL.DETAIL_ATTRIBUTE3
, 'ATTRIBUTE4'
, HTDETAIL.DETAIL_ATTRIBUTE4
, 'ATTRIBUTE5'
, HTDETAIL.DETAIL_ATTRIBUTE5
, 'ATTRIBUTE6'
, HTDETAIL.DETAIL_ATTRIBUTE6
, 'ATTRIBUTE7'
, HTDETAIL.DETAIL_ATTRIBUTE7
, 'ATTRIBUTE8'
, HTDETAIL.DETAIL_ATTRIBUTE8
, 'ATTRIBUTE9'
, HTDETAIL.DETAIL_ATTRIBUTE9
, 'ATTRIBUTE10'
, HTDETAIL.DETAIL_ATTRIBUTE10
, 'ATTRIBUTE11'
, HTDETAIL.DETAIL_ATTRIBUTE11
, 'ATTRIBUTE12'
, HTDETAIL.DETAIL_ATTRIBUTE12
, 'ATTRIBUTE13'
, HTDETAIL.DETAIL_ATTRIBUTE13
, 'ATTRIBUTE14'
, HTDETAIL.DETAIL_ATTRIBUTE14
, 'ATTRIBUTE15'
, HTDETAIL.DETAIL_ATTRIBUTE15
, 'ATTRIBUTE16'
, HTDETAIL.DETAIL_ATTRIBUTE16
, 'ATTRIBUTE17'
, HTDETAIL.DETAIL_ATTRIBUTE17
, 'ATTRIBUTE18'
, HTDETAIL.DETAIL_ATTRIBUTE18
, 'ATTRIBUTE19'
, HTDETAIL.DETAIL_ATTRIBUTE19
, 'ATTRIBUTE20'
, HTDETAIL.DETAIL_ATTRIBUTE20
, 'ATTRIBUTE21'
, HTDETAIL.DETAIL_ATTRIBUTE21
, 'ATTRIBUTE22'
, HTDETAIL.DETAIL_ATTRIBUTE22
, 'ATTRIBUTE23'
, HTDETAIL.DETAIL_ATTRIBUTE23
, 'ATTRIBUTE24'
, HTDETAIL.DETAIL_ATTRIBUTE24
, 'ATTRIBUTE25'
, HTDETAIL.DETAIL_ATTRIBUTE25
, 'ATTRIBUTE26'
, HTDETAIL.DETAIL_ATTRIBUTE26
, 'ATTRIBUTE27'
, HTDETAIL.DETAIL_ATTRIBUTE27
, 'ATTRIBUTE28'
, HTDETAIL.DETAIL_ATTRIBUTE28
, 'ATTRIBUTE29'
, HTDETAIL.DETAIL_ATTRIBUTE29
, 'ATTRIBUTE30'
, HTDETAIL.DETAIL_ATTRIBUTE30 )
, 11
, 20)
, NULL)
FROM HXC_TIMECARD_DETAILS_V HTDETAIL
, HXC_MAPPING_ATTRIBUTES_V HMA_PROJECT
, HXC_MAPPING_ATTRIBUTES_V HMA_TASK
, HXC_MAPPING_ATTRIBUTES_V HMA_EXPENDITURE
, HXC_MAPPING_ATTRIBUTES_V HMA_HOURS_TYPE
WHERE HMA_PROJECT.MAP = 'OTC DEPOSIT PROCESS MAPPING'
AND HMA_PROJECT.FIELD_NAME ='PROJECT_ID'
AND HMA_TASK.MAP = 'OTC DEPOSIT PROCESS MAPPING'
AND HMA_TASK.FIELD_NAME ='TASK_ID'
AND HMA_EXPENDITURE.MAP = 'OTC DEPOSIT PROCESS MAPPING'
AND HMA_EXPENDITURE.FIELD_NAME ='EXPENDITURE_TYPE'
AND HMA_HOURS_TYPE.MAP = 'OTC DEPOSIT PROCESS MAPPING'
AND HMA_HOURS_TYPE.FIELD_NAME = 'DUMMY ELEMENT CONTEXT'

Columns