VIEW: APPS.FND_FLEX_VSET_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)