1. Tables and Views for Common Features
  2. FND_SETID_REFERENCE_GROUPS_VL

FND_SETID_REFERENCE_GROUPS_VL

Details

  • Schema: SETID

  • Object owner: FND

  • Object type: VIEW

Columns

Name

ROW_ID

REFERENCE_GROUP_NAME

DETERMINANT_TYPE

APPLICATION_ID

MODULE_ID

VISIBLE_GROUP_NAME

DESCRIPTION

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement

select B.ROWID ROW_ID,

B.REFERENCE_GROUP_NAME REFERENCE_GROUP_NAME,

B.DETERMINANT_TYPE DETERMINANT_TYPE,

B.APPLICATION_ID APPLICATION_ID,

B.MODULE_ID MODULE_ID,

T.VISIBLE_GROUP_NAME VISIBLE_GROUP_NAME,

T.DESCRIPTION DESCRIPTION,

B.CREATED_BY CREATED_BY,

B.CREATION_DATE CREATION_DATE,

B.LAST_UPDATED_BY LAST_UPDATED_BY,

B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN

from FND_SETID_REFERENCE_GROUPS_B B,

FND_SETID_REFERENCE_GROUPS_TL T

where T.REFERENCE_GROUP_NAME = B.REFERENCE_GROUP_NAME

and T.LANGUAGE = userenv('LANG')