FND Design Data [Home] [Help]

View: FND_FLEX_VSET_V

Product: FND - Application Object Library
Description:
Implementation/DBA Data: ViewAPPS.FND_FLEX_VSET_V
View Text

SELECT NULL
, V.PARENT_FLEX_VALUE_SET_ID
, NULL
, V.FLEX_VALUE_SET_NAME
, V.FLEX_VALUE_SET_ID
, V.DESCRIPTION
, V.FLEX_VALUE_SET_ID
, V.SECURITY_ENABLED_FLAG
, FV.FLEX_VALUE
, FVT.DESCRIPTION
, V.VALIDATION_TYPE
, T.SUMMARY_ALLOWED_FLAG
FROM FND_FLEX_VALUE_SETS V
, FND_FLEX_VALUE_SETS V2
, FND_FLEX_VALUES FV
, FND_FLEX_VALUES_TL FVT
, FND_FLEX_VALIDATION_TABLES T
WHERE V.PARENT_FLEX_VALUE_SET_ID IS NULL
AND V.PARENT_FLEX_VALUE_SET_ID = FV.FLEX_VALUE_SET_ID(+)
AND FV.FLEX_VALUE_ID = FVT.FLEX_VALUE_ID (+)
AND FVT.LANGUAGE (+) = USERENV('LANG')
AND NVL(FV.ENABLED_FLAG
, 'Y') = 'Y'
AND V.PARENT_FLEX_VALUE_SET_ID = V2.FLEX_VALUE_SET_ID(+)
AND V.FLEX_VALUE_SET_ID = T.FLEX_VALUE_SET_ID(+) UNION ALL SELECT V.FLEX_VALUE_SET_NAME
, V.FLEX_VALUE_SET_ID
, V.DESCRIPTION
, V2.FLEX_VALUE_SET_NAME
, V.PARENT_FLEX_VALUE_SET_ID
, V2.DESCRIPTION
, V.FLEX_VALUE_SET_ID
, V.SECURITY_ENABLED_FLAG
, FV.FLEX_VALUE
, FVT.DESCRIPTION
, V.VALIDATION_TYPE
, T.SUMMARY_ALLOWED_FLAG
FROM FND_FLEX_VALUE_SETS V
, FND_FLEX_VALUE_SETS V2
, FND_FLEX_VALUES FV
, FND_FLEX_VALUES_TL FVT
, FND_FLEX_VALIDATION_TABLES T
WHERE V.PARENT_FLEX_VALUE_SET_ID IS NOT NULL
AND V.PARENT_FLEX_VALUE_SET_ID = FV.FLEX_VALUE_SET_ID(+)
AND FV.FLEX_VALUE_ID = FVT.FLEX_VALUE_ID (+)
AND FVT.LANGUAGE (+) = USERENV('LANG')
AND NVL(FV.ENABLED_FLAG
, 'Y') = 'Y'
AND V.PARENT_FLEX_VALUE_SET_ID = V2.FLEX_VALUE_SET_ID(+)
AND V.FLEX_VALUE_SET_ID = T.FLEX_VALUE_SET_ID(+)

Columns

Name
DEP_VALUE_SET_NAME
DEP_VALUE_SET_ID
DEP_VALUE_SET_DESCRIPTION
PARENT_VALUE_SET_NAME
PARENT_FLEX_VALUE_SET_ID
PARENT_VALUE_SET_DESCRIPTION
FLEX_VALUE_SET_ID
SECURITY_ENABLED_FLAG
FLEX_VALUE
VALUE_DESCRIPTION
VALIDATION_TYPE
SUMMARY_ALLOWED_FLAG