View: HXC_TIMECARD_DETAILS_V

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

View Text

SELECT HTB.TIME_BUILDING_BLOCK_ID
, HTB.OBJECT_VERSION_NUMBER
, HTB.START_TIME
, HTB.STOP_TIME
, HTB.COMMENT_TEXT
, HTB.PARENT_BUILDING_BLOCK_ID
, HTB.PARENT_BUILDING_BLOCK_OVN
, HTB.RESOURCE_ID
, HTB.SCOPE
, HTB.MEASURE
, HTB.UNIT_OF_MEASURE
, HTA.BLD_BLK_INFO_TYPE_ID
, HTA.ATTRIBUTE_CATEGORY
, HTA.ATTRIBUTE1
, HTA.ATTRIBUTE2
, HTA.ATTRIBUTE3
, HTA.ATTRIBUTE4
, HTA.ATTRIBUTE5
, HTA.ATTRIBUTE6
, HTA.ATTRIBUTE7
, HTA.ATTRIBUTE8
, HTA.ATTRIBUTE9
, HTA.ATTRIBUTE10
, HTA.ATTRIBUTE11
, HTA.ATTRIBUTE12
, HTA.ATTRIBUTE13
, HTA.ATTRIBUTE14
, HTA.ATTRIBUTE15
, HTA.ATTRIBUTE16
, HTA.ATTRIBUTE17
, HTA.ATTRIBUTE18
, HTA.ATTRIBUTE19
, HTA.ATTRIBUTE20
, HTA.ATTRIBUTE21
, HTA.ATTRIBUTE22
, HTA.ATTRIBUTE23
, HTA.ATTRIBUTE24
, HTA.ATTRIBUTE25
, HTA.ATTRIBUTE26
, HTA.ATTRIBUTE27
, HTA.ATTRIBUTE28
, HTA.ATTRIBUTE29
, HTA.ATTRIBUTE30
FROM HXC_TIME_BUILDING_BLOCKS HTB
, HXC_TIME_ATTRIBUTE_USAGES HTAU
, HXC_TIME_ATTRIBUTES HTA
WHERE HTB.TIME_BUILDING_BLOCK_ID = HTAU.TIME_BUILDING_BLOCK_ID
AND HTB.OBJECT_VERSION_NUMBER = HTAU.TIME_BUILDING_BLOCK_OVN
AND HTAU.TIME_ATTRIBUTE_ID = HTA.TIME_ATTRIBUTE_ID
AND HTB.RESOURCE_TYPE = 'PERSON'
AND HTB.DATE_TO = HR_GENERAL.END_OF_TIME
AND HTB.SCOPE = 'DETAIL'

Columns