1. Tables and Views for Common Features
  2. FND_SUGGEST_GROUPS_VL

FND_SUGGEST_GROUPS_VL

Details

  • Schema: SEARCH

  • Object owner: FND

  • Object type: VIEW

Columns

Name

ROW_ID

SUGGEST_GROUP_ID

SUGGEST_GROUP_CODE

PILLAR

MODULE_ID

GROUP_CREATION_EXPRESSION

GROUP_ENABLED_FLAG

HEADING_ENA

HEADING_ICON_URL

CONTEXT_CODE

OBJECT_TYPE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

DISPLAY_NAME

DESCRIPTION

GROUP_HEADING

Query

SQL_Statement

select

B.ROWID ROW_ID,

B.SUGGEST_GROUP_ID,

B.SUGGEST_GROUP_CODE,

B.PILLAR,

B.MODULE_ID,

B.GROUP_CREATION_EXPRESSION,

B.GROUP_ENABLED_FLAG,

B.HEADING_ENA,

B.HEADING_ICON_URL,

B.CONTEXT_CODE,

B.OBJECT_TYPE,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN,

T.DISPLAY_NAME,

T.DESCRIPTION,

T.GROUP_HEADING

FROM

FND_SUGGEST_GROUPS_TL T,

FND_SUGGEST_GROUPS_B B

WHERE

B.SUGGEST_GROUP_ID = T.SUGGEST_GROUP_ID AND T.LANGUAGE = USERENV('LANG')