View: FND_FLEX_CONC_PARAM_VSET_V

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.FND_FLEX_CONC_PARAM_VSET_V

View Text

SELECT A.APPLICATION_ID
, A.APPLICATION_NAME
, P.USER_CONCURRENT_PROGRAM_NAME
, P.DESCRIPTION
, 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_APPLICATION_VL A
, FND_CONCURRENT_PROGRAMS_VL P
, 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 A.APPLICATION_ID = P.APPLICATION_ID
AND P.SRS_FLAG IN ('Y'
, 'Q')
AND U.APPLICATION_ID = A.APPLICATION_ID
AND U.DESCRIPTIVE_FLEXFIELD_NAME = '$SRS$.'||P.CONCURRENT_PROGRAM_NAME
AND U.FLEX_VALUE_SET_ID = V.FLEX_VALUE_SET_ID
AND U.ENABLED_FLAG = 'Y'
AND V.PARENT_FLEX_VALUE_SET_ID = U2.FLEX_VALUE_SET_ID(+)
AND NVL(U2.APPLICATION_ID
, A.APPLICATION_ID) = A.APPLICATION_ID
AND NVL(U2.DESCRIPTIVE_FLEXFIELD_NAME
, '$SRS$.'||P.CONCURRENT_PROGRAM_NAME) = '$SRS$.'||P.CONCURRENT_PROGRAM_NAME
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 = A.APPLICATION_ID
AND U3.DESCRIPTIVE_FLEXFIELD_NAME = '$SRS$.'||P.CONCURRENT_PROGRAM_NAME
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(+)

Columns