SQL to get Skills and Qualification details for Employees

Summary:

SQL to get Skills and Qualification details for Employees

Content (required):

SELECT

 HPIM.CREATED_BY

,HPIM.CREATION_DATE

,HPIM.LAST_UPDATED_BY

,HPIM.LAST_UPDATE_DATE

,(SELECT DISTINCT PAPF.PERSON_NUMBER FROM PER_ALL_PEOPLE_F PAPF

  WHERE PAPF.PERSON_ID = HPV.PERSON_ID)

,HPV.PERSON_ID

,HPV.OWNER_PERSON_ID

,HPV.PROFILE_ID

,HPV.DESCRIPTION

,HPV.PROFILE_TYPE_ID

,HPV.PROFILE_CODE

,HPV.PROFILE_STATUS_CODE

,HPV.PROFILE_USAGE_CODE

,HPIM.PROFILE_ITEM_ID

,HPIM.PARENT_PROFILE_ITEM_ID

,HPIM.CONTENT_TYPE_ID

,HPIM.CONTENT_ITEM_ID

,HPIM.DATE_FROM

,HPIM.DATE_TO

,HPIM.ITEM_TEXT240_1 as "Degree"