FND_DF_FLEX_USAGES

Details

Schema: DFF
Object owner: FND
Object type: VIEW

Columns

Name
ROW_ID APPLICATION_ID DESCRIPTIVE_FLEXFIELD_CODE FLEXFIELD_USAGE_CODE MODULE_ID USAGE_TYPE ADFUI_PACKAGE_NAME CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN NAME DESCRIPTION

Name

ROW_ID

APPLICATION_ID

DESCRIPTIVE_FLEXFIELD_CODE

FLEXFIELD_USAGE_CODE

MODULE_ID

USAGE_TYPE

ADFUI_PACKAGE_NAME

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

NAME

DESCRIPTION

Query

SQL_Statement
SELECT B.ROWID ROW_ID, B.APPLICATION_ID, B.DESCRIPTIVE_FLEXFIELD_CODE, B.FLEXFIELD_USAGE_CODE, B.MODULE_ID, B.USAGE_TYPE, B.ADFUI_PACKAGE_NAME, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, T.NAME, T.DESCRIPTION FROM FND_DF_FLEX_USAGES_B B, FND_DF_FLEX_USAGES_TL T WHERE B.APPLICATION_ID = T.APPLICATION_ID AND B.DESCRIPTIVE_FLEXFIELD_CODE = T.DESCRIPTIVE_FLEXFIELD_CODE AND B.FLEXFIELD_USAGE_CODE = T.FLEXFIELD_USAGE_CODE AND T.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.ROWID ROW_ID,

B.APPLICATION_ID,

B.DESCRIPTIVE_FLEXFIELD_CODE,

B.FLEXFIELD_USAGE_CODE,

B.MODULE_ID,

B.USAGE_TYPE,

B.ADFUI_PACKAGE_NAME,

B.CREATION_DATE,

B.CREATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_LOGIN,

T.NAME,

T.DESCRIPTION

FROM

FND_DF_FLEX_USAGES_B B,

FND_DF_FLEX_USAGES_TL T

WHERE

B.APPLICATION_ID = T.APPLICATION_ID AND B.DESCRIPTIVE_FLEXFIELD_CODE = T.DESCRIPTIVE_FLEXFIELD_CODE AND B.FLEXFIELD_USAGE_CODE = T.FLEXFIELD_USAGE_CODE AND T.LANGUAGE = USERENV('LANG')