Product: | EGO - Advanced Product Catalog |
---|---|
Description: | This view contains the value sets supported in EGO Application |
Implementation/DBA Data: | APPS.EGO_VALUE_SETS_V |
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(+)