Need report of SVC_SERVICE_REQUESTS table details with SR employee, his dept, reporting dept, team,

Summary:

Need report of SVC_SERVICE_REQUESTS table details with SR employee, his dept, reporting dept, team, unit,section, trying with following query, but i am getting primary contact department details. Please help me on this:

SELECT       

         ssr.SR_NUMBER,

           

          (SELECT PDS.NAME

          FROM PER_ORG_TREE_NODE_CF CF,

          HR_ALL_ORGANIZATION_UNITS PDS

          WHERE PDS.ORGANIZATION_ID = CF.DEP31_PK1_VALUE

          -- AND TREE_CODE like 'CCS_HR_STRUCTURE_HIERARCHY'

          AND DEP25_PK1_VALUE = TREE.PK1_START_VALUE

          and rownum=1

          ) LEVEL_1,

           

          (SELECT PDS.NAME

          FROM PER_ORG_TREE_NODE_CF CF,

          HR_ALL_ORGANIZATION_UNITS PDS

          WHERE PDS.ORGANIZATION_ID = CF.DEP30_PK1_VALUE