SQL to retrieve employee name,person number,department name and department DFF details

Summary:

SQL to retrieve employee name,person number,department name and department DFF details

Content (required):

Hi All,

Please share SQL to retrieve employee name,person number,department name and department DFF details like all attribute fields related to the department DFF along with the employee details.

Thank You,Balaji

Version (include the version you are using, if applicable):

21c

Code Snippet (add any code snippets that support your topic, if applicable):