Announcements for Payroll and OTL can now be found in the Announcements - Payroll and OTL - EBS (MOSC) subcategory. Follow to be sure you don't miss a thing!
OTL: Project and Grants added to OTL
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