FF_DBI_GROUPS_VL

Details

• Schema: FUSION

• Object owner: FF

• Object type: VIEW

Columns

Name
DBI_GROUP_ID BASE_GROUP_NAME CONTEXT_ID ATTRIBUTE_TYPE LEGISLATIVE_DATA_GROUP_ID LEGISLATION_CODE ENTERPRISE_ID OBJECT_VERSION_NUMBER LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE MODULE_ID GROUP_NAME SOURCE_LANG

Query

SQL_Statement

SELECT FF_DBI_GROUPS.DBI_GROUP_ID DBI_GROUP_ID, FF_DBI_GROUPS.BASE_GROUP_NAME base_GROUP_NAME, FF_DBI_GROUPS.CONTEXT_ID CONTEXT_ID, FF_DBI_GROUPS.ATTRIBUTE_TYPE ATTRIBUTE_TYPE, FF_DBI_GROUPS.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID, FF_DBI_GROUPS.LEGISLATION_CODE LEGISLATION_CODE, FF_DBI_GROUPS.ENTERPRISE_ID ENTERPRISE_ID, FF_DBI_GROUPS.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, FF_DBI_GROUPS.LAST_UPDATED_BY LAST_UPDATED_BY, FF_DBI_GROUPS.LAST_UPDATE_DATE LAST_UPDATE_DATE, FF_DBI_GROUPS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, FF_DBI_GROUPS.CREATED_BY CREATED_BY, FF_DBI_GROUPS.CREATION_DATE CREATION_DATE, FF_DBI_GROUPS.MODULE_ID MODULE_ID, FF_DBI_GROUPS_TL.GROUP_NAME GROUP_NAME, FF_DBI_GROUPS_TL.SOURCE_LANG SOURCE_LANG FROM FF_DBI_GROUPS , FF_DBI_GROUPS_TL WHERE FF_DBI_GROUPS.DBI_GROUP_ID = FF_DBI_GROUPS_TL.DBI_GROUP_ID and FF_DBI_GROUPS_TL.LANGUAGE = USERENV('LANG')