HRT_PROFILE_EXTRA_INFO_VL

Details

• Schema: FUSION

• Object owner: HRT

• Object type: VIEW

Columns

Name
PROFILE_EXTRA_INFO_ID BUSINESS_GROUP_ID PROFILE_ID DESCRIPTION RESPONSIBILITIES QUALIFICATIONS COMMENTS JOB_LEVEL_CODE RISK_CODE CRITICALITY_REASON SUCCESSION_PLAN_REQUIRED OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT PREI.PROFILE_EXTRA_INFO_ID PROFILE_EXTRA_INFO_ID, PREI.BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PREI.PROFILE_ID PROFILE_ID, PREIT.DESCRIPTION DESCRIPTION, PREIT.RESPONSIBILITIES RESPONSIBILITIES, PREIT.QUALIFICATIONS QUALIFICATIONS, PREIT.COMMENTS COMMENTS, PREI.JOB_LEVEL_CODE JOB_LEVEL_CODE, PREI.RISK_CODE RISK_CODE, PREI.CRITICALITY_REASON CRITICALITY_REASON, PREI.SUCCESSION_PLAN_REQUIRED SUCCESSION_PLAN_REQUIRED, PREI.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PREI.CREATED_BY CREATED_BY, PREI.CREATION_DATE CREATION_DATE, PREI.LAST_UPDATED_BY LAST_UPDATED_BY, PREI.LAST_UPDATE_DATE LAST_UPDATE_DATE, PREI.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM HRT_PROFILE_EXTRA_INFO_B PREI, HRT_PROFILE_EXTRA_INFO_TL PREIT WHERE PREI.PROFILE_EXTRA_INFO_ID = PREIT.PROFILE_EXTRA_INFO_ID AND PREIT.LANGUAGE = USERENV('LANG')