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

Hi Guys query is returning DATA_DS, please help me where i went wrong int he query.

Received Response
17
Views
1
Comments

Summary:

My Query:

select per.person_number,
per_name.FULL_NAME
PER_ABSENCE_ENTRY_ID ,
abs.absence_type_id,
apae.APPROVAL_STATUS_CD,abs.name absence_type,to_char(apae.start_date,'DD-MON-YYYY') start_date,to_char(apae.end_date,'DD-MON-YYYY') end_date,duration,
haouf.name department,
haotl.name LE,
pplf.LEGISLATION_CODE
--PLDG.name LDG

from
ANC_PER_ABS_ENTRIES apae,PER_PERIODS_OF_SERVICE pps,PER_ALL_PEOPLE_F per,
PER_ALL_ASSIGNMENTS_M paam,
ANC_ABSENCE_TYPES_VL abs,
HR_ALL_ORGANIZATION_UNITS_F_VL HAOUF,
HR_ORGANIZATION_UNITS_F_TL haotl,
per_person_names_f per_name,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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