Need to know approval date file & table name of absence records attached my sql, if anyone please mo — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need to know approval date file & table name of absence records attached my sql, if anyone please mo

Summary:

we use oracle fusion cloud. OBI report and analytic

Need to know approval date file & table name of absence records

attached my sql, if anyone please modify and give me the approval date of absence

, I alredy taking the dates below, but approved dates are different for some cases


Content (required):


select per.person_number,


PNAME.DISPLAY_NAME,


abs.absence_type_id "Absence Type Id",


   abs.name absence_type,


   to_char(apae.start_date,'DD-MON-YYYY','NLS_DATE_LANGUAGE = AMERICAN') start_date,


   to_char(apae.end_date,'DD-MON-YYYY','NLS_DATE_LANGUAGE = AMERICAN') end_date,


   duration "Absence Duration"


, apae.ABSENCE_STATUS_CD

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!