HRC_SEM_WORK_EXP_AUTO_SUG_VL

Details

• Schema: FUSION

• Object owner: HRC

• Object type: VIEW

Columns

Name
LOV CREATION_DATE LAST_UPDATE_DATE OBJECT_VERSION_NUMBER

Query

SQL_Statement
select wok.JOB_TITLE as LOV, CREATION_DATE, LAST_UPDATE_DATE , OBJECT_VERSION_NUMBER from HRC_SEM_WORK_EXPERIENCES wok where wok.JOB_TITLE is not null union select wok.EMPLOYER_NAME as LOV, CREATION_DATE, LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER from HRC_SEM_WORK_EXPERIENCES wok where wok.EMPLOYER_NAME is not null