We need to fetch all active records from current Organization Tree for department structure

Summary

We need to fetch all active records from current Organization Tree for department structure

Content

Hi Experts,

We need to fetch all active records from current Organization Tree for department structure of parent child relation ship Using BIP Report.

Below is the requirement.

OU ID	OU Name	Parent ID
Enterprise name	Enterprise name	Null
Division Name	Division Name	Enterprise name
Legal_entity_name	Legal_entity_name	Division Name
Business_Unit_id	Business_unit_name	Legal_entity_name
Department_id	Dept_name	Business_Unit_id
Department_id	Dept_name	Department_id

 

Regards,

Bala

Version

19B