PER_EXT_TYPE_GRP_VL

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name
EXT_TYPE_GRP_ID EXT_TYPE_GRP_CODE ALLOW_USER_CREATION MODULE_ID LEGISLATION_CODE ENTERPRISE_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN EXT_TYPE_GRP_NAME DESCRIPTION

Query

SQL_Statement

SELECT PER_EXT_TYPE_GRP_B.EXT_TYPE_GRP_ID EXT_TYPE_GRP_ID, PER_EXT_TYPE_GRP_B.EXT_TYPE_GRP_CODE EXT_TYPE_GRP_CODE, PER_EXT_TYPE_GRP_B.ALLOW_USER_CREATION ALLOW_USER_CREATION, PER_EXT_TYPE_GRP_B.MODULE_ID MODULE_ID, PER_EXT_TYPE_GRP_B.LEGISLATION_CODE LEGISLATION_CODE, PER_EXT_TYPE_GRP_B.ENTERPRISE_ID ENTERPRISE_ID, PER_EXT_TYPE_GRP_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PER_EXT_TYPE_GRP_B.CREATED_BY CREATED_BY, PER_EXT_TYPE_GRP_B.CREATION_DATE CREATION_DATE, PER_EXT_TYPE_GRP_B.LAST_UPDATED_BY LAST_UPDATED_BY, PER_EXT_TYPE_GRP_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, PER_EXT_TYPE_GRP_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PER_EXT_TYPE_GRP_TL.EXT_TYPE_GRP_NAME EXT_TYPE_GRP_NAME, PER_EXT_TYPE_GRP_TL.DESCRIPTION DESCRIPTION FROM PER_EXT_TYPE_GRP_B, PER_EXT_TYPE_GRP_TL WHERE PER_EXT_TYPE_GRP_B.EXT_TYPE_GRP_ID = PER_EXT_TYPE_GRP_TL.EXT_TYPE_GRP_ID AND PER_EXT_TYPE_GRP_TL.LANGUAGE = USERENV('LANG')