FND_SYNONYMS

Details

Schema: SEARCH
Object owner: FND
Object type: VIEW

Columns

Name
ROW_ID SYNONYM_ID SYNONYM_CODE SYNONYM_TYPE CONTEXT_CODE OBJECT_TYPE ALL_COMBINATIONS_FLAG ENABLED_FLAG MODULE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN PRIMARY_SYNONYM SYNONYM_1 SYNONYM_2 SYNONYM_3 SYNONYM_4 SYNONYM_5 SYNONYM_6 SYNONYM_7 SYNONYM_8 SYNONYM_9 SYNONYM_10

Name

ROW_ID

SYNONYM_ID

SYNONYM_CODE

SYNONYM_TYPE

CONTEXT_CODE

OBJECT_TYPE

ALL_COMBINATIONS_FLAG

ENABLED_FLAG

MODULE_ID

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

PRIMARY_SYNONYM

SYNONYM_1

SYNONYM_2

SYNONYM_3

SYNONYM_4

SYNONYM_5

SYNONYM_6

SYNONYM_7

SYNONYM_8

SYNONYM_9

SYNONYM_10

Query

SQL_Statement
select B.ROWID ROW_ID, B.SYNONYM_ID, B.SYNONYM_CODE, B.SYNONYM_TYPE, B.CONTEXT_CODE, B.OBJECT_TYPE, B.ALL_COMBINATIONS_FLAG, B.ENABLED_FLAG, B.MODULE_ID, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, T.PRIMARY_SYNONYM, T.SYNONYM_1, T.SYNONYM_2, T.SYNONYM_3, T.SYNONYM_4, T.SYNONYM_5, T.SYNONYM_6, T.SYNONYM_7, T.SYNONYM_8, T.SYNONYM_9, T.SYNONYM_10 FROM FND_SYNONYMS_B B, FND_SYNONYMS_TL T WHERE B.SYNONYM_ID = T.SYNONYM_ID AND T.LANGUAGE = USERENV('LANG')

SQL_Statement

select

B.ROWID ROW_ID,

B.SYNONYM_ID,

B.SYNONYM_CODE,

B.SYNONYM_TYPE,

B.CONTEXT_CODE,

B.OBJECT_TYPE,

B.ALL_COMBINATIONS_FLAG,

B.ENABLED_FLAG,

B.MODULE_ID,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN,

T.PRIMARY_SYNONYM,

T.SYNONYM_1,

T.SYNONYM_2,

T.SYNONYM_3,

T.SYNONYM_4,

T.SYNONYM_5,

T.SYNONYM_6,

T.SYNONYM_7,

T.SYNONYM_8,

T.SYNONYM_9,

T.SYNONYM_10

FROM

FND_SYNONYMS_B B,

FND_SYNONYMS_TL T

WHERE

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