SELECT
A.APPLICATION_ID
, A.APPLICATION_NAME
, K.TITLE
, K.DESCRIPTIVE_FLEXFIELD_NAME
, K.DESCRIPTION
, X.DESCRIPTIVE_FLEX_CONTEXT_CODE
, X.DESCRIPTIVE_FLEX_CONTEXT_NAME
, U.END_USER_COLUMN_NAME
, V.FLEX_VALUE_SET_ID
, V.PARENT_FLEX_VALUE_SET_ID
, V.SECURITY_ENABLED_FLAG
, V.VALIDATION_TYPE
, T.SUMMARY_ALLOWED_FLAG
FROM
FND_DESCRIPTIVE_FLEXS_VL K
, FND_APPLICATION_VL A
, FND_DESCR_FLEX_CONTEXTS_VL X
, FND_DESCR_FLEX_COLUMN_USAGES U
, FND_FLEX_VALUE_SETS V
, FND_FLEX_VALIDATION_TABLES T
WHERE K.APPLICATION_ID = A.APPLICATION_ID
AND K.PROTECTED_FLAG = 'N'
AND K.APPLICATION_ID = X.APPLICATION_ID
AND K.DESCRIPTIVE_FLEXFIELD_NAME = X.DESCRIPTIVE_FLEXFIELD_NAME
AND K.APPLICATION_ID = U.APPLICATION_ID
AND K.DESCRIPTIVE_FLEXFIELD_NAME = U.DESCRIPTIVE_FLEXFIELD_NAME
AND X.DESCRIPTIVE_FLEX_CONTEXT_CODE = U.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND X.ENABLED_FLAG = 'Y'
AND U.ENABLED_FLAG = 'Y'
AND U.FLEX_VALUE_SET_ID = V.FLEX_VALUE_SET_ID
AND V.FLEX_VALUE_SET_ID = T.FLEX_VALUE_SET_ID(+)