VIEW: APPS.HXC_TIMECARD_DETAILS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'