FND_VAL_ATTRIBUTE_TYPES_VL

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 PROMPT DESCRIPTION

Query

SQL_Statement

SELECT B.ROW_ID ROW_ID, B.APPLICATION_ID, B.ID_FLEX_CODE, B.SEGMENT_ATTRIBUTE_TYPE, B.VALUE_ATTRIBUTE_TYPE, B.REQUIRED_FLAG, B.APPLICATION_COLUMN_NAME, B.DEFAULT_VALUE, B.LOOKUP_TYPE, B.DERIVATION_RULE_CODE, B.DERIVATION_RULE_VALUE1, B.DERIVATION_RULE_VALUE2, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, T.PROMPT, T.DESCRIPTION FROM FND_VALUE_ATTRIBUTE_TYPES B, FND_VAL_ATTRIBUTE_TYPES_TL T WHERE B.APPLICATION_ID = T.APPLICATION_ID AND B.ID_FLEX_CODE = T.ID_FLEX_CODE AND B.SEGMENT_ATTRIBUTE_TYPE = T.SEGMENT_ATTRIBUTE_TYPE AND B.VALUE_ATTRIBUTE_TYPE = T.VALUE_ATTRIBUTE_TYPE AND T.LANGUAGE = USERENV('LANG')