1. Tables and Views for Common Features
  2. FND_DESCRIPTIVE_FLEXS_TL

FND_DESCRIPTIVE_FLEXS_TL

Details

  • Schema: EBS

  • Object owner: FND

  • Object type: VIEW

Columns

Name

APPLICATION_ID

DESCRIPTIVE_FLEXFIELD_NAME

LANGUAGE

SOURCE_LANG

TITLE

DESCRIPTION

FORM_CONTEXT_PROMPT

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT

B.APPLICATION_ID APPLICATION_ID,

B.DESCRIPTIVE_FLEXFIELD_CODE DESCRIPTIVE_FLEXFIELD_NAME,

B.LANGUAGE LANGUAGE,

B.SOURCE_LANG SOURCE_LANG,

B.NAME TITLE,

B.DESCRIPTION DESCRIPTION,

FDSTL.PROMPT FORM_CONTEXT_PROMPT,

B.CREATION_DATE CREATION_DATE,

B.CREATED_BY CREATED_BY,

B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

B.LAST_UPDATED_BY LAST_UPDATED_BY,

B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN

FROM FND_DF_FLEXFIELDS_TL B,

FND_DF_SEGMENTS_B FDS,

FND_DF_SEGMENTS_TL FDSTL

WHERE FDS.APPLICATION_ID = B.APPLICATION_ID

AND FDS.DESCRIPTIVE_FLEXFIELD_CODE = B.DESCRIPTIVE_FLEXFIELD_CODE

AND FDS.CONTEXT_CODE = 'Context Data Element'

AND FDS.SEGMENT_CODE = 'Context Segment'

AND FDS.SEQUENCE_NUMBER = 1

AND FDSTL.APPLICATION_ID = FDS.APPLICATION_ID

AND FDSTL.DESCRIPTIVE_FLEXFIELD_CODE = FDS.DESCRIPTIVE_FLEXFIELD_CODE

AND FDSTL.CONTEXT_CODE = FDS.CONTEXT_CODE

AND FDSTL.SEGMENT_CODE = FDS.SEGMENT_CODE

AND FDSTL.LANGUAGE = B.LANGUAGE