FND_EF_UI_PAGES

Details

Schema: DFF
Object owner: FND
Object type: VIEW

Columns

Name
ROW_ID PAGE_ID APPLICATION_ID DESCRIPTIVE_FLEXFIELD_CODE FLEXFIELD_USAGE_CODE CATEGORY_CODE PAGE_CODE PROTECTED_FLAG SEQUENCE_NUMBER MDS_DOCUMENT_NAME CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN NAME DESCRIPTION INSTRUCTION_HELP_TEXT

Name

ROW_ID

PAGE_ID

APPLICATION_ID

DESCRIPTIVE_FLEXFIELD_CODE

FLEXFIELD_USAGE_CODE

CATEGORY_CODE

PAGE_CODE

PROTECTED_FLAG

SEQUENCE_NUMBER

MDS_DOCUMENT_NAME

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

NAME

DESCRIPTION

INSTRUCTION_HELP_TEXT

Query

SQL_Statement
SELECT B.ROWID ROW_ID, B.PAGE_ID, B.APPLICATION_ID, B.DESCRIPTIVE_FLEXFIELD_CODE, B.FLEXFIELD_USAGE_CODE, B.CATEGORY_CODE, B.PAGE_CODE, B.PROTECTED_FLAG, B.SEQUENCE_NUMBER, B.MDS_DOCUMENT_NAME, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, T.NAME, T.DESCRIPTION, T.INSTRUCTION_HELP_TEXT FROM FND_EF_UI_PAGES_B B, FND_EF_UI_PAGES_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 B.CATEGORY_CODE = T.CATEGORY_CODE AND B.PAGE_CODE = T.PAGE_CODE AND T.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.ROWID ROW_ID,

B.PAGE_ID,

B.APPLICATION_ID,

B.DESCRIPTIVE_FLEXFIELD_CODE,

B.FLEXFIELD_USAGE_CODE,

B.CATEGORY_CODE,

B.PAGE_CODE,

B.PROTECTED_FLAG,

B.SEQUENCE_NUMBER,

B.MDS_DOCUMENT_NAME,

B.CREATION_DATE,

B.CREATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_LOGIN,

T.NAME,

T.DESCRIPTION,

T.INSTRUCTION_HELP_TEXT

FROM FND_EF_UI_PAGES_B B,

FND_EF_UI_PAGES_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 B.CATEGORY_CODE = T.CATEGORY_CODE

AND B.PAGE_CODE = T.PAGE_CODE

AND T.LANGUAGE = USERENV('LANG')