FND_KF_STR_INSTANCES_VL

Details

• Schema: KFF

• Object owner: FND

• Object type: VIEW

Columns

Name
ROW_ID APPLICATION_ID KEY_FLEXFIELD_CODE STRUCTURE_INSTANCE_CODE STRUCTURE_INSTANCE_IDENTIFIER STRUCTURE_INSTANCE_ID STRUCTURE_INSTANCE_NUMBER STRUCTURE_ID ENABLED_FLAG DYNAMIC_COMBO_CREATION_FLAG SHA_ENABLED_FLAG 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_INSTANCE_CODE, B.STRUCTURE_INSTANCE_IDENTIFIER, B.STRUCTURE_INSTANCE_ID, B.STRUCTURE_INSTANCE_NUMBER, B.STRUCTURE_ID, B.ENABLED_FLAG, B.DYNAMIC_COMBO_CREATION_FLAG, B.SHA_ENABLED_FLAG, 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_STR_INSTANCES_B B, FND_KF_STR_INSTANCES_TL T WHERE B.APPLICATION_ID = T.APPLICATION_ID AND B.KEY_FLEXFIELD_CODE = T.KEY_FLEXFIELD_CODE AND B.STRUCTURE_INSTANCE_CODE = T.STRUCTURE_INSTANCE_CODE AND T.LANGUAGE = USERENV('LANG')