[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 |