Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
How To Count Number Of Employees In Each Department and Include It in this query
Summary:
How To Count Number Of Employees In Each Department and Include It in this query:
SELECT distinct houft.name Department_Name_English,
ppnfv.full_name,
FF.ATTRIBUTE3 Department_Name_ARABIC,
FF.ATTRIBUTE1 Department_Catagory,
CLS.STATUS STATUS,
hoif.ATTRIBUTE_NUMBER1 Department_Code
FROM HR_ORGANIZATION_INFORMATION_F hoif,
per_person_names_f_v ppnfv,
hr_organization_units_f_tl houft,
HR_ALL_ORGANIZATION_UNITS_F FF,
HR_ORGANIZATION_UNITS_F_TL TT,
HR_ORG_UNIT_CLASSIFICATIONS_F CLS
WHERE trunc(sysdate) BETWEEN hoif.EFFECTIVE_START_DATE AND hoif.EFFECTIVE_END_DATE
AND trunc(sysdate) BETWEEN ppnfv.effective_Start_date AND ppnfv.effective_end_date
Tagged:
0