Payroll and OTL - EBS (MOSC)

MOSC Banner

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

edited Jun 27, 2012 7:28AM in Payroll and OTL - EBS (MOSC) 6 commentsAnswered
 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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center