VIEW: APPS.PER_COMPETENCE_ELEMENTS_V8

Source

View Text - Preformatted

SELECT TO_NUMBER(NULL) ,NULL ,COMP_V2.COMPETENCE_ID ,CPL_V2.NAME ,COMP_V2.DATE_FROM ,COMP_V2.DATE_TO ,TO_NUMBER(NULL) ,'N' ,CEL_V2.COMPETENCE_ELEMENT_ID ,CEL_V2.BUSINESS_GROUP_ID ,TO_NUMBER(NULL) ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL , NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,TO_DATE(NULL) ,TO_NUMBER(NULL) ,TO_NUMBER(NULL) ,TO_NUMBER(NULL) ,TO_DATE(NULL) ,TO_NUMBER(NULL) ,CEL_V2.QUALIFICATION_TYPE_ID ,CEL_V2.UNIT_STANDARD_TYPE ,NULL ,to_date(null) ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL FROM PER_COMPETENCE_ELEMENTS CEL_V2 ,PER_COMPETENCES COMP_V2 ,PER_COMPETENCES_TL CPL_V2 WHERE CEL_V2.TYPE = 'QUALIFICATION' AND CEL_V2.COMPETENCE_ID = COMP_V2.COMPETENCE_ID AND CPL_V2.COMPETENCE_ID = COMP_V2.COMPETENCE_ID AND CPL_V2.LANGUAGE = userenv('LANG') AND (CEL_V2.BUSINESS_GROUP_ID = COMP_V2.BUSINESS_GROUP_ID OR CEL_V2.BUSINESS_GROUP_ID IS NULL)

View Text - HTML Formatted

SELECT TO_NUMBER(NULL)
, NULL
, COMP_V2.COMPETENCE_ID
, CPL_V2.NAME
, COMP_V2.DATE_FROM
, COMP_V2.DATE_TO
, TO_NUMBER(NULL)
, 'N'
, CEL_V2.COMPETENCE_ELEMENT_ID
, CEL_V2.BUSINESS_GROUP_ID
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, CEL_V2.QUALIFICATION_TYPE_ID
, CEL_V2.UNIT_STANDARD_TYPE
, NULL
, TO_DATE(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM PER_COMPETENCE_ELEMENTS CEL_V2
, PER_COMPETENCES COMP_V2
, PER_COMPETENCES_TL CPL_V2
WHERE CEL_V2.TYPE = 'QUALIFICATION'
AND CEL_V2.COMPETENCE_ID = COMP_V2.COMPETENCE_ID
AND CPL_V2.COMPETENCE_ID = COMP_V2.COMPETENCE_ID
AND CPL_V2.LANGUAGE = USERENV('LANG')
AND (CEL_V2.BUSINESS_GROUP_ID = COMP_V2.BUSINESS_GROUP_ID OR CEL_V2.BUSINESS_GROUP_ID IS NULL)