HRT_CONTENT_ITEM_RD_VL

Details

• Schema: FUSION

• Object owner: HRT

• Object type: VIEW

Columns

Name
CONTENT_RATING_DESC_ID CONTENT_TYPE_ID CONTENT_ITEM_ID BUSINESS_GROUP_ID REVIEW_RATING_DESCR RATING_LEVEL_ID OBJECT_VERSION_NUMBER MODULE_ID CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT RD.CONTENT_RATING_DESC_ID, RD.CONTENT_TYPE_ID, RD.CONTENT_ITEM_ID, RD.BUSINESS_GROUP_ID, RDTL.REVIEW_RATING_DESCR, RD.RATING_LEVEL_ID, RD.OBJECT_VERSION_NUMBER, RD.MODULE_ID, RD.CREATED_BY, RD.CREATION_DATE, RD.LAST_UPDATE_DATE, RD.LAST_UPDATED_BY, RD.LAST_UPDATE_LOGIN FROM HRT_CONTENT_ITEM_RDESC_B RD, HRT_CONTENT_ITEM_RDSC_TL RDTL WHERE RD.CONTENT_RATING_DESC_ID = RDTL.CONTENT_RATING_DESC_ID AND RDTL.LANGUAGE = USERENV('LANG')