VIEW: HRI.HRI_MB_CMPTNC_RQRMNT_CT#

Source

View Text - Preformatted

select ROW_INDICATOR ROW_INDICATOR, CORE_CMPTNC_INDICATOR CORE_CMPTNC_INDICATOR, ESSNTL_CMPTNC_INDICATOR ESSNTL_CMPTNC_INDICATOR, ORGANIZATION_RQRMNT_INDICATOR ORGANIZATION_RQRMNT_INDICATOR, JOB_RQRMNT_INDICATOR JOB_RQRMNT_INDICATOR, GRADE_RQRMNT_INDICATOR GRADE_RQRMNT_INDICATOR, POSITION_RQRMNT_INDICATOR POSITION_RQRMNT_INDICATOR, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ORGANIZATION_ID ORGANIZATION_ID, JOB_ID JOB_ID, GRADE_ID GRADE_ID, POSITION_ID POSITION_ID, ENTERPRISE_ID ENTERPRISE_ID, COMPETENCE_ID COMPETENCE_ID, COMPETENCE_ELEMENT_ID COMPETENCE_ELEMENT_ID, LOW_LEVEL_ID LOW_LEVEL_ID, HIGH_LEVEL_ID HIGH_LEVEL_ID, ESSNTL_CMPTNC_FLAG_CODE ESSNTL_CMPTNC_FLAG_CODE, LAST_CHANGE_DATE LAST_CHANGE_DATE from "HRI"."HRI_MB_CMPTNC_RQRMNT_CT"

View Text - HTML Formatted

SELECT ROW_INDICATOR ROW_INDICATOR
, CORE_CMPTNC_INDICATOR CORE_CMPTNC_INDICATOR
, ESSNTL_CMPTNC_INDICATOR ESSNTL_CMPTNC_INDICATOR
, ORGANIZATION_RQRMNT_INDICATOR ORGANIZATION_RQRMNT_INDICATOR
, JOB_RQRMNT_INDICATOR JOB_RQRMNT_INDICATOR
, GRADE_RQRMNT_INDICATOR GRADE_RQRMNT_INDICATOR
, POSITION_RQRMNT_INDICATOR POSITION_RQRMNT_INDICATOR
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ORGANIZATION_ID ORGANIZATION_ID
, JOB_ID JOB_ID
, GRADE_ID GRADE_ID
, POSITION_ID POSITION_ID
, ENTERPRISE_ID ENTERPRISE_ID
, COMPETENCE_ID COMPETENCE_ID
, COMPETENCE_ELEMENT_ID COMPETENCE_ELEMENT_ID
, LOW_LEVEL_ID LOW_LEVEL_ID
, HIGH_LEVEL_ID HIGH_LEVEL_ID
, ESSNTL_CMPTNC_FLAG_CODE ESSNTL_CMPTNC_FLAG_CODE
, LAST_CHANGE_DATE LAST_CHANGE_DATE
FROM "HRI"."HRI_MB_CMPTNC_RQRMNT_CT"