HRT_AI_CONTENT_ITEMS_VL

Details

• Schema: FUSION

• Object owner: HRT

• Object type: VIEW

Columns

Name
CONTENT_ITEM_ID CONTENT_TYPE_ID BUSINESS_GROUP_ID CONTENT_ITEM_CODE NAME ITEM_DESCRIPTION DATE_FROM DATE_TO RATING_MODEL_ID SOURCE CURATION_STATUS_CODE ITEM_DESCRLONG OBJECT_VERSION_NUMBER MODULE_ID CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CONTENT_VALUE_SET_ID

Query

SQL_Statement

SELECT CI.CONTENT_ITEM_ID, CI.CONTENT_TYPE_ID, CI.BUSINESS_GROUP_ID, CI.CONTENT_ITEM_CODE, CTL.NAME, CTL.ITEM_DESCRIPTION, CI.DATE_FROM, CI.DATE_TO, CI.RATING_MODEL_ID, CI.CONTENT_SUPPLIER_CODE AS SOURCE, CI.ITEM_TEXT_1 AS CURATION_STATUS_CODE, CTL.ITEM_DESCRLONG, CI.OBJECT_VERSION_NUMBER, CI.MODULE_ID, CI.CREATED_BY, CI.CREATION_DATE, CI.LAST_UPDATE_DATE, CI.LAST_UPDATED_BY, CI.LAST_UPDATE_LOGIN, CI.CONTENT_VALUE_SET_ID FROM HRT_CONTENT_ITEMS_B CI, HRT_CONTENT_ITEMS_TL CTL WHERE CI.CONTENT_ITEM_ID = CTL.CONTENT_ITEM_ID AND CI.BUSINESS_GROUP_ID = CTL.BUSINESS_GROUP_ID AND CTL.LANGUAGE = USERENV('LANG')