[Home] [Help]
View: HXC_RESOURCE_TIMECARDS_V
View Text
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
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(+)
Columns
Name |
TIMECARD_ID |
TIMECARD_OVN |
RESOURCE_ID |
STATUS_CODE |
STATUS_NAME |
PERIOD_STARTS |
PERIOD_ENDS |
HOURS_WORKED |
SUBMISSION_DATE |
TIMECARD_COMMENT |
REASON_INFO |
DATA_SET_STATUS |
OFFLINE_EXISTS |