HRC_DL_UI_BUS_OBJECTS_V

Details

• Schema: FUSION

• Object owner: HRC

• Object type: VIEW

Columns

Name

BUSINESS_OBJECT_ID BUS_OBJ_FILE_DISCRIMINATOR BUS_OBJ_TOP_DISCRIMINATOR BUS_OBJ_SERVICE_VERSION PARENT_BUSINESS_OBJECT_ID UI_BUSINESS_OBJECT_ID PROCESSING_ORDER WS_CONNECTION_QNAME UI_BUSINESS_OBJECT_GUID UI_NAME UI_DESCRIPTION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER ENTERPRISE_ID PRODUCT_AREA EA_PROFILE_OPTION_NAME EA_PROFILE_OPTION_TYPE EA_PROFILE_OPTION_HASH_STRING

Query

SQL_Statement

SELECT OBJ.BUSINESS_OBJECT_ID, OBJ.BUS_OBJ_FILE_DISCRIMINATOR, OBJ.BUS_OBJ_TOP_DISCRIMINATOR, OBJ.BUS_OBJ_SERVICE_VERSION, OBJ.PARENT_BUSINESS_OBJECT_ID, OBJ.UI_BUSINESS_OBJECT_ID, OBJ.PROCESSING_ORDER, OBJ.WS_CONNECTION_QNAME, VL.UI_BUSINESS_OBJECT_GUID, VL.UI_NAME, VL.UI_DESCRIPTION, VL.CREATED_BY, VL.CREATION_DATE, VL.LAST_UPDATED_BY, VL.LAST_UPDATE_DATE, VL.LAST_UPDATE_LOGIN, VL.OBJECT_VERSION_NUMBER, VL.ENTERPRISE_ID, OBJ.PRODUCT_AREA, OBJ.EA_PROFILE_OPTION_NAME, OBJ.EA_PROFILE_OPTION_TYPE, OBJ.EA_PROFILE_OPTION_HASH_STRING FROM HRC_DL_BUSINESS_OBJECTS OBJ, HRC_DL_UI_BUS_OBJECTS_VL VL WHERE OBJ.UI_BUSINESS_OBJECT_ID = VL.UI_BUSINESS_OBJECT_ID(+)