VIEW: APPS.EGO_VALUE_SETS_V

Source

View Text - Preformatted

SELECT fl_val.FLEX_VALUE_SET_ID AS VALUE_SET_ID , fl_val.FLEX_VALUE_SET_NAME AS VALUE_SET_NAME , fl_val.FORMAT_TYPE AS FORMAT_CODE , l1.MEANING AS FORMAT_MEANING , fl_val.MAXIMUM_SIZE AS MAXIMUM_SIZE , fl_val.DESCRIPTION AS DESCRIPTION , fl_val.LONGLIST_FLAG AS LONGLIST_FLAG , l2.MEANING AS LONGLIST_FLAG_MEANING , DECODE(l3.LOOKUP_CODE, 'X', 'I', l3.LOOKUP_CODE) AS VALIDATION_CODE , l3.MEANING AS VALIDATION_MEANING , fl_val.MINIMUM_VALUE AS MINIMUM_VALUE , fl_val.MAXIMUM_VALUE AS MAXIMUM_VALUE , fl_val.VALIDATION_TYPE AS VALIDATION_CODE_ADMIN , ext.PARENT_VALUE_SET_ID AS PARENT_VALUE_SET_ID FROM FND_FLEX_VALUE_SETS fl_val , EGO_VS_FORMAT_CODES_V l1 , EGO_VS_DISPLAY_CODES_V l2 , EGO_VS_VALIDATION_CODES_V l3, EGO_VALUE_SET_EXT ext WHERE l1.LOOKUP_CODE = fl_val.FORMAT_TYPE AND l2.LOOKUP_CODE = fl_val.LONGLIST_FLAG AND l3.LOOKUP_CODE = fl_val.VALIDATION_TYPE AND fl_val.FLEX_VALUE_SET_ID = ext.VALUE_SET_ID(+)

View Text - HTML Formatted

SELECT FL_VAL.FLEX_VALUE_SET_ID AS VALUE_SET_ID
, FL_VAL.FLEX_VALUE_SET_NAME AS VALUE_SET_NAME
, FL_VAL.FORMAT_TYPE AS FORMAT_CODE
, L1.MEANING AS FORMAT_MEANING
, FL_VAL.MAXIMUM_SIZE AS MAXIMUM_SIZE
, FL_VAL.DESCRIPTION AS DESCRIPTION
, FL_VAL.LONGLIST_FLAG AS LONGLIST_FLAG
, L2.MEANING AS LONGLIST_FLAG_MEANING
, DECODE(L3.LOOKUP_CODE
, 'X'
, 'I'
, L3.LOOKUP_CODE) AS VALIDATION_CODE
, L3.MEANING AS VALIDATION_MEANING
, FL_VAL.MINIMUM_VALUE AS MINIMUM_VALUE
, FL_VAL.MAXIMUM_VALUE AS MAXIMUM_VALUE
, FL_VAL.VALIDATION_TYPE AS VALIDATION_CODE_ADMIN
, EXT.PARENT_VALUE_SET_ID AS PARENT_VALUE_SET_ID
FROM FND_FLEX_VALUE_SETS FL_VAL
, EGO_VS_FORMAT_CODES_V L1
, EGO_VS_DISPLAY_CODES_V L2
, EGO_VS_VALIDATION_CODES_V L3
, EGO_VALUE_SET_EXT EXT
WHERE L1.LOOKUP_CODE = FL_VAL.FORMAT_TYPE
AND L2.LOOKUP_CODE = FL_VAL.LONGLIST_FLAG
AND L3.LOOKUP_CODE = FL_VAL.VALIDATION_TYPE
AND FL_VAL.FLEX_VALUE_SET_ID = EXT.VALUE_SET_ID(+)