Project Planning Resource Breakdown Structures query

Summary:

Need SQL query to retrieve Project Planning Resource Breakdown Structures (screenshot below)

Content (please ensure you mask any confidential information):

I am using the PJO_PLANNING_ELEMENTS table as the basis to join the project RBS to resources tables (pjf_rbs_elements, pjf_rbs_element_names_tl) however, it does not display all values and some resources are not listed. Does anyone have a query for Project PRBS