FND_KF_STRUCTURES_VL

Details

• Schema: KFF

• Object owner: FND

• Object type: VIEW

Columns

Name
ROW_ID APPLICATION_ID KEY_FLEXFIELD_CODE STRUCTURE_CODE STRUCTURE_ID ENABLED_FLAG DELIMITER 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.KEY_FLEXFIELD_CODE, B.STRUCTURE_CODE, B.STRUCTURE_ID, B.ENABLED_FLAG, B.DELIMITER, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, T.NAME, T.DESCRIPTION FROM FND_KF_STRUCTURES_B B, FND_KF_STRUCTURES_TL T WHERE B.APPLICATION_ID = T.APPLICATION_ID AND B.KEY_FLEXFIELD_CODE = T.KEY_FLEXFIELD_CODE AND B.STRUCTURE_CODE = T.STRUCTURE_CODE AND T.LANGUAGE = USERENV('LANG')