VIEW: APPS.CSM_FLEX_VALUES_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID, VAL.FLEX_VALUE_SET_ID, VAL.FLEX_VALUE_ID, VAL.FLEX_VALUE, VAL.PARENT_FLEX_VALUE_LOW, VAL.PARENT_FLEX_VALUE_HIGH, VAL.ENABLED_FLAG, VAL.SUMMARY_FLAG, VAL.START_DATE_ACTIVE, VAL.END_DATE_ACTIVE, VAL.STRUCTURED_HIERARCHY_LEVEL, VAL.HIERARCHY_LEVEL, VAL.COMPILED_VALUE_ATTRIBUTES, VAL.VALUE_CATEGORY, TL.DESCRIPTION FROM FND_FLEX_VALUES VAL, FND_FLEX_VALUES_TL TL, CSM_FLEX_VALUES_ACC ACC WHERE VAL.FLEX_VALUE_ID = ACC.FLEX_VALUE_ID AND VAL.FLEX_VALUE_ID = TL.FLEX_VALUE_ID AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, VAL.FLEX_VALUE_SET_ID
, VAL.FLEX_VALUE_ID
, VAL.FLEX_VALUE
, VAL.PARENT_FLEX_VALUE_LOW
, VAL.PARENT_FLEX_VALUE_HIGH
, VAL.ENABLED_FLAG
, VAL.SUMMARY_FLAG
, VAL.START_DATE_ACTIVE
, VAL.END_DATE_ACTIVE
, VAL.STRUCTURED_HIERARCHY_LEVEL
, VAL.HIERARCHY_LEVEL
, VAL.COMPILED_VALUE_ATTRIBUTES
, VAL.VALUE_CATEGORY
, TL.DESCRIPTION
FROM FND_FLEX_VALUES VAL
, FND_FLEX_VALUES_TL TL
, CSM_FLEX_VALUES_ACC ACC
WHERE VAL.FLEX_VALUE_ID = ACC.FLEX_VALUE_ID
AND VAL.FLEX_VALUE_ID = TL.FLEX_VALUE_ID
AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE