requirement to add process and grants data to an existing OTL SQL
Hello Guru's
I have a requirement to add process and grants data to an existing OTL query. The query doesn't return any value, however I know that it should.. Does anyone have an example I can leverage? Here is what I've done so far
SELECT htg.tk_group_name group_name,
papf.full_name full_name,
htb.start_time,
htb.stop_time,
initcap(TO_CHAR(htb.start_time,'DAY')) DAYY,
tbb_det.approval_status approval_status,
element_name Hours_Type,
SUM(tbb_det.measure) monday_tot_hrs,
0 tuesday_tot_hrs,
0 wednesday_tot_hrs,
0 thursday_tot_hrs,
0 Friday_tot_hrs,
0 Saturday_tot_hrs,
0