Product: | FND - Application Object Library |
---|---|
Description: | View of FND_VALUE_ATTRIBUTE_TYPES and FND_VAL_ATTRIBUTE_TYPES_TL |
Implementation/DBA Data: | APPS.FND_VAL_ATTRIBUTE_TYPES_VL |
SELECT /* $HEADER$ */ B.ROWID ROW_ID
, B.APPLICATION_ID
, B.ID_FLEX_CODE
, B.SEGMENT_ATTRIBUTE_TYPE
, B.VALUE_ATTRIBUTE_TYPE
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, 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
, T.PROMPT
, T.DESCRIPTION
FROM FND_VAL_ATTRIBUTE_TYPES_TL T
, FND_VALUE_ATTRIBUTE_TYPES B
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')