VIEW: APPS.FND_FLEX_DESCR_SEG_VSET_V

Source

View Text - Preformatted

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, decode(V.PARENT_FLEX_VALUE_SET_ID, null, null, U.END_USER_COLUMN_NAME), U.DESCRIPTION, decode(V.PARENT_FLEX_VALUE_SET_ID, null, U.END_USER_COLUMN_NAME, U2.END_USER_COLUMN_NAME), V.FLEX_VALUE_SET_ID, V.SECURITY_ENABLED_FLAG, V.PARENT_FLEX_VALUE_SET_ID, V.VALIDATION_TYPE, FV.FLEX_VALUE, FVT.DESCRIPTION, T.SUMMARY_ALLOWED_FLAG FROM FND_DESCRIPTIVE_FLEXS_VL K, FND_APPLICATION_VL A, FND_DESCR_FLEX_CONTEXTS_VL X, FND_DESCR_FLEX_COL_USAGE_VL U, FND_FLEX_VALUE_SETS V, FND_FLEX_VALUES FV, FND_FLEX_VALUES_TL FVT, FND_DESCR_FLEX_COLUMN_USAGES U2, 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.PARENT_FLEX_VALUE_SET_ID = U2.FLEX_VALUE_SET_ID(+) AND K.APPLICATION_ID = nvl(U2.APPLICATION_ID, K.APPLICATION_ID) AND K.DESCRIPTIVE_FLEXFIELD_NAME = nvl(U2.DESCRIPTIVE_FLEXFIELD_NAME, K.DESCRIPTIVE_FLEXFIELD_NAME) AND X.DESCRIPTIVE_FLEX_CONTEXT_CODE = nvl(U2.DESCRIPTIVE_FLEX_CONTEXT_CODE, X.DESCRIPTIVE_FLEX_CONTEXT_CODE) AND nvl(U2.ENABLED_FLAG, 'Y') = 'Y' AND nvl(U2.COLUMN_SEQ_NUM, 0) = (select nvl(max(u3.column_seq_num), 0) from fnd_descr_flex_column_usages u3 where u3.application_id = k.application_id and u3.descriptive_flexfield_name = k.descriptive_flexfield_name and u3.descriptive_flex_context_code = x.descriptive_flex_context_code and u3.flex_value_set_id = v.parent_flex_value_set_id and u3.column_seq_num < U.COLUMN_SEQ_NUM and u3.enabled_flag = 'Y') 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.FLEX_VALUE_SET_ID = T.FLEX_VALUE_SET_ID(+)

View Text - HTML Formatted

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
, DECODE(V.PARENT_FLEX_VALUE_SET_ID
, NULL
, NULL
, U.END_USER_COLUMN_NAME)
, U.DESCRIPTION
, DECODE(V.PARENT_FLEX_VALUE_SET_ID
, NULL
, U.END_USER_COLUMN_NAME
, U2.END_USER_COLUMN_NAME)
, V.FLEX_VALUE_SET_ID
, V.SECURITY_ENABLED_FLAG
, V.PARENT_FLEX_VALUE_SET_ID
, V.VALIDATION_TYPE
, FV.FLEX_VALUE
, FVT.DESCRIPTION
, T.SUMMARY_ALLOWED_FLAG
FROM FND_DESCRIPTIVE_FLEXS_VL K
, FND_APPLICATION_VL A
, FND_DESCR_FLEX_CONTEXTS_VL X
, FND_DESCR_FLEX_COL_USAGE_VL U
, FND_FLEX_VALUE_SETS V
, FND_FLEX_VALUES FV
, FND_FLEX_VALUES_TL FVT
, FND_DESCR_FLEX_COLUMN_USAGES U2
, 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.PARENT_FLEX_VALUE_SET_ID = U2.FLEX_VALUE_SET_ID(+)
AND K.APPLICATION_ID = NVL(U2.APPLICATION_ID
, K.APPLICATION_ID)
AND K.DESCRIPTIVE_FLEXFIELD_NAME = NVL(U2.DESCRIPTIVE_FLEXFIELD_NAME
, K.DESCRIPTIVE_FLEXFIELD_NAME)
AND X.DESCRIPTIVE_FLEX_CONTEXT_CODE = NVL(U2.DESCRIPTIVE_FLEX_CONTEXT_CODE
, X.DESCRIPTIVE_FLEX_CONTEXT_CODE)
AND NVL(U2.ENABLED_FLAG
, 'Y') = 'Y'
AND NVL(U2.COLUMN_SEQ_NUM
, 0) = (SELECT NVL(MAX(U3.COLUMN_SEQ_NUM)
, 0)
FROM FND_DESCR_FLEX_COLUMN_USAGES U3
WHERE U3.APPLICATION_ID = K.APPLICATION_ID
AND U3.DESCRIPTIVE_FLEXFIELD_NAME = K.DESCRIPTIVE_FLEXFIELD_NAME
AND U3.DESCRIPTIVE_FLEX_CONTEXT_CODE = X.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND U3.FLEX_VALUE_SET_ID = V.PARENT_FLEX_VALUE_SET_ID
AND U3.COLUMN_SEQ_NUM < U.COLUMN_SEQ_NUM
AND U3.ENABLED_FLAG = 'Y')
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.FLEX_VALUE_SET_ID = T.FLEX_VALUE_SET_ID(+)