1. Tables and Views for HCM
  2. HRT_CONTENT_TP_VALUESETS_VL

HRT_CONTENT_TP_VALUESETS_VL

Details

  • Schema: FUSION

  • Object owner: HRT

  • Object type: VIEW

Columns

Name

CONTENT_VALUE_SET_ID

CONTENT_TYPE_ID

CURATION_ENABLED_FLAG

STATUS

BUSINESS_GROUP_ID

VALUE_SET_NAME

VALUE_SET_DESCRIPTION

PARENT_CONTENT_VALUE_SET_ID

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

MODULE_ID

SEED_DATA_SOURCE

CONTENT_VALUE_SET_CODE

Query

SQL_Statement

SELECT

CTV.CONTENT_VALUE_SET_ID CONTENT_VALUE_SET_ID,

CTV.CONTENT_TYPE_ID CONTENT_TYPE_ID,

CTV.CURATION_ENABLED_FLAG CURATION_ENABLED_FLAG,

CTV.STATUS STATUS,

CTV.BUSINESS_GROUP_ID BUSINESS_GROUP_ID,

CTVTL.VALUE_SET_NAME VALUE_SET_NAME,

CTVTL.VALUE_SET_DESCRIPTION VALUE_SET_DESCRIPTION,

CTV.PARENT_CONTENT_VALUE_SET_ID PARENT_CONTENT_VALUE_SET_ID,

CTV.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

CTV.CREATED_BY CREATED_BY,

CTV.CREATION_DATE CREATION_DATE,

CTV.LAST_UPDATE_DATE LAST_UPDATE_DATE,

CTV.LAST_UPDATED_BY LAST_UPDATED_BY,

CTV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

CTV.MODULE_ID MODULE_ID,

CTV.SEED_DATA_SOURCE SEED_DATA_SOURCE,

CTV.CONTENT_VALUE_SET_CODE

FROM

HRT_CONTENT_TP_VALUESETS_B CTV,

HRT_CONTENT_TP_VALUESETS_TL CTVTL

WHERE

CTV.CONTENT_VALUE_SET_ID = CTVTL.CONTENT_VALUE_SET_ID AND CTV.BUSINESS_GROUP_ID = CTVTL.BUSINESS_GROUP_ID AND CTVTL.LANGUAGE = USERENV('LANG')