Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
BI Report Time card details - Calculated details by earned date — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BI Report Time card details - Calculated details by earned date

Question
2
Views
0
Comments

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!