VIEW: APPS.HXC_TIMECARD_PERIODS_DB_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'