BI Report Time card details - Calculated details by earned date
Summary:
Team we have a requirement to fetch all the details available in the timecard. (Calculated details by earned date) - Screenshot attached.
I am using the below query but its fetching extra rows. It would be really helpful if you can provide any sample query for reference.
SELECT To_char(htr.start_time, 'DD/MM/YYYY') TE_START_DATE,
To_char(htr.stop_time, 'DD/MM/YYYY') TE_STOP_DATE,
To_char(htr.start_time, 'HH:MI') TE_START_TIME,
To_char(htr.stop_time, 'HH:MI') TE_STOP_TIME,
htr.measure,
htra.attribute_category
FROM hwm_tm_rec htr,
0