HRC_DL_BUS_OBJECT_ATTRS_V

Details

• Schema: FUSION

• Object owner: HRC

• Object type: VIEW

Columns

Name
BUS_OBJECT_ATTR_ID BUSINESS_OBJECT_ID VO_ATTRIBUTE_NAME COMMON_KEY ATTRIBUTE_LABEL ATTRIBUTE_DESCRIPTION LANGUAGE SOURCE_LANG MODULE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER ENTERPRISE_ID

Query

SQL_Statement

SELECT BOB.BUS_OBJECT_ATTR_ID, BOB.BUSINESS_OBJECT_ID, BOB.VO_ATTRIBUTE_NAME, BOB.COMMON_KEY, CATL.ATTRIBUTE_LABEL, CATL.ATTRIBUTE_DESCRIPTION, CATL.LANGUAGE, CATL.SOURCE_LANG, BOB.MODULE_ID, BOB.CREATED_BY, BOB.CREATION_DATE, BOB.LAST_UPDATED_BY, BOB.LAST_UPDATE_DATE, BOB.LAST_UPDATE_LOGIN, BOB.OBJECT_VERSION_NUMBER, BOB.ENTERPRISE_ID FROM HRC_DL_BUS_OBJECT_ATTRS_B BOB JOIN HRC_DL_BUS_COMM_ATTRS_B CAB ON CAB.COMMON_KEY = BOB.COMMON_KEY JOIN HRC_DL_BUS_COMM_ATTRS_TL CATL ON CATL.BUS_COMM_ATTR_ID = CAB.BUS_COMM_ATTR_ID UNION SELECT BOB.BUS_OBJECT_ATTR_ID, BOB.BUSINESS_OBJECT_ID, BOB.VO_ATTRIBUTE_NAME, BOB.COMMON_KEY, CASE WHEN ATTRIBUTE_LABEL IS NULL THEN REGEXP_REPLACE(REGEXP_REPLACE(BOB.VO_ATTRIBUTE_NAME, '([a-z])([A-Z])', '\1 \2'),' Id$| Id([0-9])',' ID\1') ELSE BOTL.ATTRIBUTE_LABEL END ATTRIBUTE_LABEL, BOTL.ATTRIBUTE_DESCRIPTION, BOTL.LANGUAGE, BOTL.SOURCE_LANG, BOB.MODULE_ID, BOB.CREATED_BY, BOB.CREATION_DATE, BOB.LAST_UPDATED_BY, BOB.LAST_UPDATE_DATE, BOB.LAST_UPDATE_LOGIN, BOB.OBJECT_VERSION_NUMBER, BOB.ENTERPRISE_ID FROM HRC_DL_BUS_OBJECT_ATTRS_B BOB JOIN HRC_DL_BUS_OBJECT_ATTRS_TL BOTL ON BOTL.BUS_OBJECT_ATTR_ID = BOB.BUS_OBJECT_ATTR_ID AND BOB.COMMON_KEY is NULL