VIEW: APPS.JTM_FND_FLEX_VALUE_SETS_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID, A.FLEX_VALUE_SET_ID, A.FLEX_VALUE_SET_NAME, A.LAST_UPDATE_DATE, A.LAST_UPDATED_BY, A.CREATION_DATE, A.CREATED_BY, A.LAST_UPDATE_LOGIN, A.VALIDATION_TYPE, A.PROTECTED_FLAG, A.SECURITY_ENABLED_FLAG, A.LONGLIST_FLAG, A.FORMAT_TYPE, A.MAXIMUM_SIZE, A.ALPHANUMERIC_ALLOWED_FLAG, A.UPPERCASE_ONLY_FLAG, A.NUMERIC_MODE_ENABLED_FLAG, A.DESCRIPTION, A.DEPENDANT_DEFAULT_VALUE, A.DEPENDANT_DEFAULT_MEANING, A.PARENT_FLEX_VALUE_SET_ID, A.MINIMUM_VALUE, A.MAXIMUM_VALUE, A.NUMBER_PRECISION FROM fnd_flex_value_sets A, JTM_FND_FLEX_VALUE_SETS_ACC ACC WHERE A.FLEX_VALUE_SET_ID = ACC.FLEX_VALUE_SET_ID AND A.FLEX_VALUE_SET_ID IN (SELECT FLEX_VALUE_SET_ID FROM FND_DESCR_FLEX_COLUMN_USAGES BAS, JTM_FND_DESCR_FLEXS_ACC ACC WHERE BAS.APPLICATION_ID = ACC.BASE_APPLICATION_ID AND BAS.DESCRIPTIVE_FLEXFIELD_NAME = ACC.DESCRIPTIVE_FLEXFIELD_NAME AND ACC.APPLICATION_ID = 868 )

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, A.FLEX_VALUE_SET_ID
, A.FLEX_VALUE_SET_NAME
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.VALIDATION_TYPE
, A.PROTECTED_FLAG
, A.SECURITY_ENABLED_FLAG
, A.LONGLIST_FLAG
, A.FORMAT_TYPE
, A.MAXIMUM_SIZE
, A.ALPHANUMERIC_ALLOWED_FLAG
, A.UPPERCASE_ONLY_FLAG
, A.NUMERIC_MODE_ENABLED_FLAG
, A.DESCRIPTION
, A.DEPENDANT_DEFAULT_VALUE
, A.DEPENDANT_DEFAULT_MEANING
, A.PARENT_FLEX_VALUE_SET_ID
, A.MINIMUM_VALUE
, A.MAXIMUM_VALUE
, A.NUMBER_PRECISION
FROM FND_FLEX_VALUE_SETS A
, JTM_FND_FLEX_VALUE_SETS_ACC ACC
WHERE A.FLEX_VALUE_SET_ID = ACC.FLEX_VALUE_SET_ID
AND A.FLEX_VALUE_SET_ID IN (SELECT FLEX_VALUE_SET_ID
FROM FND_DESCR_FLEX_COLUMN_USAGES BAS
, JTM_FND_DESCR_FLEXS_ACC ACC
WHERE BAS.APPLICATION_ID = ACC.BASE_APPLICATION_ID
AND BAS.DESCRIPTIVE_FLEXFIELD_NAME = ACC.DESCRIPTIVE_FLEXFIELD_NAME
AND ACC.APPLICATION_ID = 868 )