VIEW: APPS.BIL_DIMV_SKILLS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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