HRT_CONTENT_PROPS_V

Details

• Schema: FUSION

• Object owner: HRT

• Object type: VIEW

Columns

Name
CONTENT_TYPE_PROP_ID BUSINESS_GROUP_ID CONTENT_TYPE_ID FIELD_NAME ATTRIBUTE_LABEL DEFAULT_FIELD_LABEL USED_IN_CODE DEFAULT_VALUE REQUIRED_FLAG DISPLAY_CODE COLUMN_NAME VIEW_ATTRB_NAME MODULE_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT CP.CONTENT_TYPE_PROP_ID, CP.BUSINESS_GROUP_ID, CP.CONTENT_TYPE_ID, CP.FIELD_NAME, CP.ATTRIBUTE_LABEL, FVL.DEFAULT_FIELD_LABEL, FVL.USED_IN_CODE, CP.DEFAULT_VALUE, CP.REQUIRED_FLAG, CP.DISPLAY_CODE, CP.COLUMN_NAME, CP.VIEW_ATTRB_NAME, CP.MODULE_ID, CP.OBJECT_VERSION_NUMBER, CP.CREATED_BY, CP.CREATION_DATE, CP.LAST_UPDATE_DATE, CP.LAST_UPDATED_BY, CP.LAST_UPDATE_LOGIN FROM HRT_CONTENT_PROPS_VL CP, HRT_FIELDNAMES_VL FVL WHERE CP.FIELD_NAME = FVL.FIELD_NAME