Work Schedule Report - Getting Hours On Date
As per the screenshot attached.
We have a requirement to fetch the Hours On Date. Example. If we pass parameter date as 03-Dec-2018 then 35 hours 77777700-7 (Need to get the "7"..that we will work on it.)
If the parameter date is 08-Dec-2018 then, we need to get the value "12" From 262 hours 48 hrs x 5 plus 12 over 6 wks-12
We have tried all the tables but unable to find the table which stores these information.
We are trying to use the Package Function Call in SQL (PER_AVAILABILITY_DETAILS.GET_SCHEDULE_DETAILS) and trying to get the information. But still the query is not getting ended only and its Infinitely running.