View: FND_FLEX_CP_PARAM_VSET_V

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

View Text

SELECT A.APPLICATION_ID
, A.APPLICATION_NAME
, P.USER_CONCURRENT_PROGRAM_NAME
, P.CONCURRENT_PROGRAM_NAME
, P.DESCRIPTION
, 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_APPLICATION_VL A
, FND_CONCURRENT_PROGRAMS_VL P
, FND_DESCR_FLEX_COLUMN_USAGES U
, FND_FLEX_VALUE_SETS V
, 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.FLEX_VALUE_SET_ID = T.FLEX_VALUE_SET_ID(+)