We have a requirement to develop a portlet/report to show the Resource Shift timing and Worktype (Work-day or non-work day) details as the columns. I am unable to find the table name to get the data for the resource shift timings. I have checked in PRJ_RESOURCES, PRCALENDAR tables, but unable to get the required data.
Can anyone help me in getting the shift timings and work-type details from the database table?
Is this data is stored in any BLOB type, if so can you please help in providing the database table name and the workable snippet code to convert the BLOB type to text.