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

➜ Back to Library
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 (9) 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
Download
Related Blitz Reports
HRMS - Employee Anniversaries and Birthdays Detail: Organization Hierarchy (10) HRMS - Employee Anniversaries and Birthdays Detail: Organization Hierarchy (4) HRMS - Employee Anniversaries and Birthdays Detail: Organization Hierarchy (2) HRMS - Employee Anniversaries and Birthdays Detail: Organization Hierarchy (3) HRMS - Employee Anniversaries and Birthdays Detail: Organization Hierarchy (7) Assignment (Employee) - Current, Organization Hierarchy - Historic (Structure), Person Information - Current HRMS - Employee Anniversaries and Birthdays Detail: Organization Hierarchy (8) HRMS - Employee Anniversaries and Birthdays Detail: Organization Hierarchy (11) HRMS - Employee Anniversaries and Birthdays Detail: Organization Hierarchy (5) HRMS - Employee Anniversaries and Birthdays Detail: Organization Hierarchy (6)
Blitz Report™

Blitz Report™ provides multiple benefits:

Blitz Report™