VIEW: APPS.HXC_RESOURCE_TIMECARDS_V

Source

View Text - Preformatted

SELECT hts.timecard_id, hts.timecard_ovn, hts.resource_id, hts.approval_status, SUBSTR ( hr_general.decode_lookup ( 'HXC_APPROVAL_STATUS', hts.approval_status ), 1, 80 ), hts.start_time, hts.stop_time, hts.recorded_hours, hts.submission_date, tbb.comment_text, hts.has_reasons, DECODE ( (SELECT 1 FROM DUAL WHERE EXISTS ( SELECT 1 FROM hxc_data_sets d WHERE hts.stop_time BETWEEN d.start_date AND d.end_date AND d.status IN ( 'OFF_LINE' , 'RESTORE_IN_PROGRESS' , 'BACKUP_IN_PROGRESS' ))), 1, 'OFF_LINE', 'OTHERS' ) AS data_set_status, DECODE ( (SELECT 1 FROM DUAL WHERE EXISTS ( SELECT 1 FROM hxc_data_sets WHERE status IN ( 'OFF_LINE' , 'RESTORE_IN_PROGRESS' , 'BACKUP_IN_PROGRESS') )), 1, 'OFFLINE_EXISTS', 'OFFLINE_NOTEXISTS' ) AS offline_exists,hts.absence_days,hts.absence_hours,hts.transferred_to FROM hxc_timecard_summary hts, hxc_time_building_blocks tbb WHERE hts.timecard_id = tbb.time_building_block_id(+) and hts.timecard_ovn = tbb.object_version_number(+)

View Text - HTML Formatted

SELECT HTS.TIMECARD_ID
, HTS.TIMECARD_OVN
, HTS.RESOURCE_ID
, HTS.APPROVAL_STATUS
, SUBSTR ( HR_GENERAL.DECODE_LOOKUP ( 'HXC_APPROVAL_STATUS'
, HTS.APPROVAL_STATUS )
, 1
, 80 )
, HTS.START_TIME
, HTS.STOP_TIME
, HTS.RECORDED_HOURS
, HTS.SUBMISSION_DATE
, TBB.COMMENT_TEXT
, HTS.HAS_REASONS
, DECODE ( (SELECT 1
FROM DUAL
WHERE EXISTS ( SELECT 1
FROM HXC_DATA_SETS D
WHERE HTS.STOP_TIME BETWEEN D.START_DATE
AND D.END_DATE
AND D.STATUS IN ( 'OFF_LINE'
, 'RESTORE_IN_PROGRESS'
, 'BACKUP_IN_PROGRESS' )))
, 1
, 'OFF_LINE'
, 'OTHERS' ) AS DATA_SET_STATUS
, DECODE ( (SELECT 1
FROM DUAL
WHERE EXISTS ( SELECT 1
FROM HXC_DATA_SETS
WHERE STATUS IN ( 'OFF_LINE'
, 'RESTORE_IN_PROGRESS'
, 'BACKUP_IN_PROGRESS') ))
, 1
, 'OFFLINE_EXISTS'
, 'OFFLINE_NOTEXISTS' ) AS OFFLINE_EXISTS
, HTS.ABSENCE_DAYS
, HTS.ABSENCE_HOURS
, HTS.TRANSFERRED_TO
FROM HXC_TIMECARD_SUMMARY HTS
, HXC_TIME_BUILDING_BLOCKS TBB
WHERE HTS.TIMECARD_ID = TBB.TIME_BUILDING_BLOCK_ID(+)
AND HTS.TIMECARD_OVN = TBB.OBJECT_VERSION_NUMBER(+)