FND_VALUE_ATTRIBUTE_TYPES

Details

• Schema: EBS

• Object owner: FND

• Object type: VIEW

Columns

Name
ROW_ID APPLICATION_ID ID_FLEX_CODE SEGMENT_ATTRIBUTE_TYPE VALUE_ATTRIBUTE_TYPE REQUIRED_FLAG APPLICATION_COLUMN_NAME DEFAULT_VALUE LOOKUP_TYPE DERIVATION_RULE_CODE DERIVATION_RULE_VALUE1 DERIVATION_RULE_VALUE2 CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.APPLICATION_ID APPLICATION_ID, B.KEY_FLEXFIELD_CODE ID_FLEX_CODE, B.SEGMENT_LABEL_CODE SEGMENT_ATTRIBUTE_TYPE, B.VALUE_ATTRIBUTE_CODE VALUE_ATTRIBUTE_TYPE, B.REQUIRED_FLAG REQUIRED_FLAG, B.COMBO_TABLE_COLUMN_NAME APPLICATION_COLUMN_NAME, B.DEFAULT_VALUE DEFAULT_VALUE, B.LOOKUP_TYPE LOOKUP_TYPE, DECODE(B.KEY_FLEXFIELD_CODE, NULL, RPAD(' ', 30), 'G12') DERIVATION_RULE_CODE, DECODE(B.KEY_FLEXFIELD_CODE, NULL, RPAD(' ', 30), 'N') DERIVATION_RULE_VALUE1, DECODE(B.KEY_FLEXFIELD_CODE, NULL, RPAD(' ', 30), 'Y') DERIVATION_RULE_VALUE2, 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_VALUE_ATTRS_B B