Product: | BIL - Sales Intelligence |
---|---|
Description: | Sales representative skills view |
Implementation/DBA Data: | APPS.BIL_DIMV_SKILLS |
SELECT HCP.PERSON_ID
, HCP. BUSINESS_GROUP_NAME
, HCP.PERSON_NAME
, HCP.COMPETENCE_NAME
, HCP.DATE_FROM
, HCP.DATE_TO
, HCP.PROFICIENCY_RATING_SOURCE
, HCP.CERTIFICATION_METHOD
, HCP.CERTIFICATION_DATE
, HCP.NEXT_REVIEW_DATE
, HCP.PROFICIENCY_LEVEL
, HCP.BUSINESS_GROUP_ID
, HCP.COMPETENCE_ID
FROM HRFV_COMPETENCE_PROFILES HCP
, HRFV_REQUIRED_COMPETENCES HRC
, BIL_DIMV_SALESFORCE BDS
WHERE HCP.PERSON_ID = BDS.EMPLOYEE_PERSON_FK
AND HCP.COMPETENCE_ID = HRC.COMPETENCE_ID
AND HRC.CORE_COMPETENCE_FLAG = 'Y'
AND NVL(HRC.DATE_FROM
, SYSDATE) <= SYSDATE
AND NVL(HRC.DATE_TO
, SYSDATE) >= SYSDATE UNION ALL (SELECT TO_NUMBER(FL.LOOKUP_CODE) PERSON_ID
, SUBSTR(FL.MEANING
, 1
, 60) BUSINESS_GROUP_NAME
, FL.MEANING PERSON_NAME
, FL.MEANING COMPETENCE_NAME
, FL.START_DATE_ACTIVE DATE_FROM
, FL.END_DATE_ACTIVE DATE_TO
, FL.DESCRIPTION PROFICIENCY_RATING_SOURCE
, FL.DESCRIPTION CERTIFICATION_METHOD
, FL.END_DATE_ACTIVE CERTIFICATION_DATE
, FL.END_DATE_ACTIVE NEXT_REVIEW_DATE
, FL.MEANING PROFICIENCY_LEVEL
, TO_NUMBER(FL.LOOKUP_CODE) BUSINESS_GROUP_ID
, TO_NUMBER(FL.LOOKUP_CODE) COMPETENCE_ID
FROM FND_LOOKUPS FL
WHERE FL.LOOKUP_TYPE = 'BIL_VALUE_TYPE'
AND FL.LOOKUP_CODE = '-999' ) WITH READ ONLY