FND_SUGGEST_GROUPS

詳細

スキーマ: SEARCH
オブジェクト所有者: FND
オブジェクト・タイプ: VIEW

列

名前
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

名前

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

問合せ

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')

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')