View: HXC_RESOURCE_TIMECARDS_V

Product:	HXC - Time and Labor Engine
Description:
Implementation/DBA Data:	APPS.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