VIEW: APPS.HXC_TIMECARD_DETAIL_HOURS_V

Source

View Text - Preformatted

SELECT htd.detail_timecard_id, htd.detail_object_version, htd.detail_start_time, htd.detail_stop_time, htd.detail_parent_timecard_id, htd.detail_parent_object_version, htd.detail_resource_id, htd.detail_measure, htd.detail_unit_of_measure, substr(decode(hm.segment, 'ATTRIBUTE1' , htd.detail_attribute1, 'ATTRIBUTE2' , htd.detail_attribute2, 'ATTRIBUTE3' , htd.detail_attribute3, 'ATTRIBUTE4' , htd.detail_attribute4, 'ATTRIBUTE5' , htd.detail_attribute5, 'ATTRIBUTE6' , htd.detail_attribute6, 'ATTRIBUTE7' , htd.detail_attribute7, 'ATTRIBUTE8' , htd.detail_attribute8, 'ATTRIBUTE9' , htd.detail_attribute9, 'ATTRIBUTE10' , htd.detail_attribute10, 'ATTRIBUTE11' , htd.detail_attribute11, 'ATTRIBUTE12' , htd.detail_attribute12, 'ATTRIBUTE13' , htd.detail_attribute13, 'ATTRIBUTE14' , htd.detail_attribute14, 'ATTRIBUTE15' , htd.detail_attribute15, 'ATTRIBUTE16' , htd.detail_attribute16, 'ATTRIBUTE17' , htd.detail_attribute17, 'ATTRIBUTE18' , htd.detail_attribute18, 'ATTRIBUTE19' , htd.detail_attribute19, 'ATTRIBUTE20' , htd.detail_attribute20, 'ATTRIBUTE21' , htd.detail_attribute21, 'ATTRIBUTE22' , htd.detail_attribute22, 'ATTRIBUTE23' , htd.detail_attribute23, 'ATTRIBUTE24' , htd.detail_attribute24, 'ATTRIBUTE25' , htd.detail_attribute25, 'ATTRIBUTE26' , htd.detail_attribute26, 'ATTRIBUTE27' , htd.detail_attribute27, 'ATTRIBUTE28' , htd.detail_attribute28, 'ATTRIBUTE29' , htd.detail_attribute29, 'ATTRIBUTE30' , htd.detail_attribute30 ),11,20) , hm.context, hm.segment from hxc_timecard_details_v htd,hxc_mapping_attributes_v hm WHERE htd.detail_bld_blk_info_type_id = hm.bld_blk_info_type_id (+) and hm.map = 'OTL Deposit Process Mapping' and hm.field_name = 'Dummy Element Context' and htd.detail_object_version = (select max(detail_object_version) from hxc_timecard_details_v where detail_timecard_id = htd.detail_timecard_id)

View Text - HTML Formatted

SELECT HTD.DETAIL_TIMECARD_ID
, HTD.DETAIL_OBJECT_VERSION
, HTD.DETAIL_START_TIME
, HTD.DETAIL_STOP_TIME
, HTD.DETAIL_PARENT_TIMECARD_ID
, HTD.DETAIL_PARENT_OBJECT_VERSION
, HTD.DETAIL_RESOURCE_ID
, HTD.DETAIL_MEASURE
, HTD.DETAIL_UNIT_OF_MEASURE
, SUBSTR(DECODE(HM.SEGMENT
, 'ATTRIBUTE1'
, HTD.DETAIL_ATTRIBUTE1
, 'ATTRIBUTE2'
, HTD.DETAIL_ATTRIBUTE2
, 'ATTRIBUTE3'
, HTD.DETAIL_ATTRIBUTE3
, 'ATTRIBUTE4'
, HTD.DETAIL_ATTRIBUTE4
, 'ATTRIBUTE5'
, HTD.DETAIL_ATTRIBUTE5
, 'ATTRIBUTE6'
, HTD.DETAIL_ATTRIBUTE6
, 'ATTRIBUTE7'
, HTD.DETAIL_ATTRIBUTE7
, 'ATTRIBUTE8'
, HTD.DETAIL_ATTRIBUTE8
, 'ATTRIBUTE9'
, HTD.DETAIL_ATTRIBUTE9
, 'ATTRIBUTE10'
, HTD.DETAIL_ATTRIBUTE10
, 'ATTRIBUTE11'
, HTD.DETAIL_ATTRIBUTE11
, 'ATTRIBUTE12'
, HTD.DETAIL_ATTRIBUTE12
, 'ATTRIBUTE13'
, HTD.DETAIL_ATTRIBUTE13
, 'ATTRIBUTE14'
, HTD.DETAIL_ATTRIBUTE14
, 'ATTRIBUTE15'
, HTD.DETAIL_ATTRIBUTE15
, 'ATTRIBUTE16'
, HTD.DETAIL_ATTRIBUTE16
, 'ATTRIBUTE17'
, HTD.DETAIL_ATTRIBUTE17
, 'ATTRIBUTE18'
, HTD.DETAIL_ATTRIBUTE18
, 'ATTRIBUTE19'
, HTD.DETAIL_ATTRIBUTE19
, 'ATTRIBUTE20'
, HTD.DETAIL_ATTRIBUTE20
, 'ATTRIBUTE21'
, HTD.DETAIL_ATTRIBUTE21
, 'ATTRIBUTE22'
, HTD.DETAIL_ATTRIBUTE22
, 'ATTRIBUTE23'
, HTD.DETAIL_ATTRIBUTE23
, 'ATTRIBUTE24'
, HTD.DETAIL_ATTRIBUTE24
, 'ATTRIBUTE25'
, HTD.DETAIL_ATTRIBUTE25
, 'ATTRIBUTE26'
, HTD.DETAIL_ATTRIBUTE26
, 'ATTRIBUTE27'
, HTD.DETAIL_ATTRIBUTE27
, 'ATTRIBUTE28'
, HTD.DETAIL_ATTRIBUTE28
, 'ATTRIBUTE29'
, HTD.DETAIL_ATTRIBUTE29
, 'ATTRIBUTE30'
, HTD.DETAIL_ATTRIBUTE30 )
, 11
, 20)
, HM.CONTEXT
, HM.SEGMENT
FROM HXC_TIMECARD_DETAILS_V HTD
, HXC_MAPPING_ATTRIBUTES_V HM
WHERE HTD.DETAIL_BLD_BLK_INFO_TYPE_ID = HM.BLD_BLK_INFO_TYPE_ID (+)
AND HM.MAP = 'OTL DEPOSIT PROCESS MAPPING'
AND HM.FIELD_NAME = 'DUMMY ELEMENT CONTEXT'
AND HTD.DETAIL_OBJECT_VERSION = (SELECT MAX(DETAIL_OBJECT_VERSION)
FROM HXC_TIMECARD_DETAILS_V
WHERE DETAIL_TIMECARD_ID = HTD.DETAIL_TIMECARD_ID)