[Home] [Help]
View: HXC_TIMECARD_PERIODS_DB_V
View Text
SELECT DISTINCT( TO_CHAR(START_TIME
, 'YYYY/MM/DD')) START_TIME
, TO_CHAR(STOP_TIME
, 'YYYY/MM/DD') STOP_TIME
, RESOURCE_ID
, RESOURCE_TYPE
FROM HXC_TIME_BUILDING_BLOCKS
WHERE SCOPE = 'TIMECARD'
Columns
Name |
START_TIME |
STOP_TIME |
RESOURCE_ID |
RESOURCE_TYPE |