FND_KF_VALUE_ATTRS_VL

Details

• Schema: KFF

• Object owner: FND

• Object type: VIEW

Columns

Name
ROW_ID APPLICATION_ID KEY_FLEXFIELD_CODE SEGMENT_LABEL_CODE VALUE_ATTRIBUTE_CODE VALUE_TABLE_COLUMN_NAME COMBO_TABLE_COLUMN_NAME LOOKUP_TYPE REQUIRED_FLAG DEFAULT_VALUE 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.SEGMENT_LABEL_CODE, B.VALUE_ATTRIBUTE_CODE, B.VALUE_TABLE_COLUMN_NAME, B.COMBO_TABLE_COLUMN_NAME, B.LOOKUP_TYPE, B.REQUIRED_FLAG, B.DEFAULT_VALUE, 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_VALUE_ATTRS_B B, FND_KF_VALUE_ATTRS_TL T WHERE B.APPLICATION_ID = T.APPLICATION_ID AND B.KEY_FLEXFIELD_CODE = T.KEY_FLEXFIELD_CODE AND B.SEGMENT_LABEL_CODE = T.SEGMENT_LABEL_CODE AND B.VALUE_ATTRIBUTE_CODE = T.VALUE_ATTRIBUTE_CODE AND T.LANGUAGE = USERENV('LANG')