1. Tables and Views for Common Features
  2. FND_ID_FLEX_STRUCTURES_TL

FND_ID_FLEX_STRUCTURES_TL

Details

  • Schema: EBS

  • Object owner: FND

  • Object type: VIEW

Columns

Name

APPLICATION_ID

ID_FLEX_CODE

ID_FLEX_NUM

LANGUAGE

SOURCE_LANG

ID_FLEX_STRUCTURE_NAME

DESCRIPTION

SHORTHAND_PROMPT

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT

B.APPLICATION_ID APPLICATION_ID,

B.KEY_FLEXFIELD_CODE ID_FLEX_CODE,

S.STRUCTURE_INSTANCE_NUMBER ID_FLEX_NUM,

B.LANGUAGE LANGUAGE,

B.SOURCE_LANG SOURCE_LANG,

B.NAME ID_FLEX_STRUCTURE_NAME,

B.DESCRIPTION DESCRIPTION,

DECODE(B.KEY_FLEXFIELD_CODE,

NULL, RPAD(' ', 80),

'Shorthand Alias Prompt')

SHORTHAND_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_KF_STR_INSTANCES_TL B,

FND_KF_STR_INSTANCES_B S

WHERE S.APPLICATION_ID = B.APPLICATION_ID

AND S.KEY_FLEXFIELD_CODE = B.KEY_FLEXFIELD_CODE

AND S.STRUCTURE_INSTANCE_CODE = B.STRUCTURE_INSTANCE_CODE