Organization Structure on HCM Extract

Summary

Organization Structure on HCM Extract

Content

Hi Expert,

I am trying to extract Organizational Structure in Oracle Fusion HCM,My requirements are such that I need to Extract 

Organization_ID,Organization_Name,Node_Level,Parent_Organization_ID,Parent_Organization_Name,how ever the seems to be no DBI for parent organization id this makes it impossible to extract a parent child data  in this regard.

I have attached an SQL code that I created for BIP with the exact data that I need for your better understanding.

 

Kindly assist on how to achieve this in HCM Extract.