PER_EXT_BUS_OBJECTS_VL

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name

EXT_BUS_OBJECT_ID BASE_BUS_OBJECT_NAME BUS_OBJECT_NAME DESCRIPTION MODULE_ID ENTERPRISE_ID LEGISLATION_CODE ACTIVE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 LEGISLATIVE_DATA_GROUP_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER SGUID SEED_DATA_SOURCE

Query

SQL_Statement

SELECT objects.EXT_BUS_OBJECT_ID EXT_BUS_OBJECT_ID, objects.BASE_BUS_OBJECT_NAME BASE_BUS_OBJECT_NAME, objects_tl.BUS_OBJECT_NAME BUS_OBJECT_NAME, objects_tl.DESCRIPTION DESCRIPTION , objects.MODULE_ID MODULE_ID, objects.ENTERPRISE_ID ENTERPRISE_ID, objects.LEGISLATION_CODE LEGISLATION_CODE, objects.ACTIVE ACTIVE, objects.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, objects.ATTRIBUTE1 ATTRIBUTE1, objects.ATTRIBUTE2 ATTRIBUTE2, objects.ATTRIBUTE3 ATTRIBUTE3, objects.ATTRIBUTE4 ATTRIBUTE4, objects.ATTRIBUTE5 ATTRIBUTE5, objects.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1, objects.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2, objects.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3, objects.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4, objects.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5, objects.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1, objects.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2, objects.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3, objects.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4, objects.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5, objects.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID, objects.CREATED_BY CREATED_BY, objects.CREATION_DATE CREATION_DATE, objects.LAST_UPDATED_BY LAST_UPDATED_BY, objects.LAST_UPDATE_DATE LAST_UPDATE_DATE, objects.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, objects.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, objects.SGUID SGUID, objects.SEED_DATA_SOURCE SEED_DATA_SOURCE FROM PER_EXT_BUS_OBJECTS_TL objects_tl, PER_EXT_BUS_OBJECTS_B objects WHERE objects.EXT_BUS_OBJECT_ID = objects_tl.EXT_BUS_OBJECT_ID AND objects_tl.LANGUAGE = USERENV('LANG')