HRMS - Employee Anniversaries and Birthdays Detail: Organization Hierarchy (4)

Description
Categories: Discoverer
Imported Discoverer folders:
Assignment (Employee) - Current (HRFG_EMPLOYEE_ASSIGNMENTS)
Organization Hierarchy - Historic (Structure) (HRIBG_ORG_HRCHY)
Person Information - Current (HRFG_PERSONAL_DETAILS)
Object IDs: 101234.101281.101296
Run HRMS - Employee Anniversaries and Birthdays Detail: Organization Hierarchy (4) and other Oracle EBS reports with Blitz Report™ on our demo environment
select
hea.job_name,
hea.original_date_of_hire,
hea.supervisor_name,
hoh.hierarchy_name,
hoh.hierarchy_version,
hoh.hierarchy_version_date_from,
hoh.hierarchy_version_date_to,
hoh.hrchy_primary_flag,
hoh.organization_name,
hpd.date_of_birth,
hpd.email_address,
hpd.employee_number,
hpd.hire_date,
hpd.person_name
from
hrfg_employee_assignments hea,
hribg_org_hrchy hoh,
hrfg_personal_details hpd
where
2=2 and
hoh.sub_organization_id=hea.organization_id and
hpd.person_id=hea.person_id
Parameter Name SQL text Validation
Hierarchy Version Date From From
hoh.hierarchy_version_date_from>=:hierarchy_version_date_fr_from
Date
Hierarchy Version Date From To
hoh.hierarchy_version_date_from<=:hierarchy_version_date_fr_to
Date
Hierarchy Version Date To From
hoh.hierarchy_version_date_to>=:hierarchy_version_date_to_from
Date
Hierarchy Version Date To To
hoh.hierarchy_version_date_to<=:hierarchy_version_date_to_to
Date
Blitz Report™