VIEW: APPS.EGO_VALUE_SET_VALUES_V

Source

View Text - Preformatted

SELECT vs.FLEX_VALUE_SET_ID AS VALUE_SET_ID , vs.FLEX_VALUE_SET_NAME AS VALUE_SET_NAME , vs.FORMAT_TYPE AS FORMAT_TYPE, vs.VALIDATION_TYPE AS VALIDATION_TYPE, val.FLEX_VALUE_ID AS FLEX_VALUE_ID , val.FLEX_VALUE AS INTERNAL_NAME , val.FLEX_VALUE_MEANING AS DISPLAY_NAME , val.DESCRIPTION AS DESCRIPTION , val.ENABLED_FLAG AS ENABLED_CODE , l1.MEANING AS ENABLED_MEANING , NVL(do.DISP_SEQUENCE, val.FLEX_VALUE_ID) AS SEQUENCE, val.START_DATE_ACTIVE AS START_DATE , val.END_DATE_ACTIVE AS END_DATE FROM FND_FLEX_VALUE_SETS vs , FND_FLEX_VALUES_VL val, EGO_VS_VALUES_DISP_ORDER do, FND_LOOKUP_VALUES l1, EGO_VS_FORMAT_CODES_V l2 , EGO_VS_DISPLAY_CODES_V l3, EGO_VS_VALIDATION_CODES_V l4 WHERE vs.FLEX_VALUE_SET_ID = val.FLEX_VALUE_SET_ID AND vs.FORMAT_TYPE = l2.LOOKUP_CODE AND vs.LONGLIST_FLAG = l3.LOOKUP_CODE AND vs.VALIDATION_TYPE = l4.LOOKUP_CODE AND l1.LOOKUP_TYPE = 'YES_NO' AND l1.LOOKUP_CODE = val.ENABLED_FLAG AND l1.LANGUAGE = USERENV('LANG') AND l1.VIEW_APPLICATION_ID = 0 AND do.VALUE_SET_VALUE_ID(+) = val.FLEX_VALUE_ID AND do.VALUE_SET_ID (+) = val.FLEX_VALUE_SET_ID

View Text - HTML Formatted

SELECT VS.FLEX_VALUE_SET_ID AS VALUE_SET_ID
, VS.FLEX_VALUE_SET_NAME AS VALUE_SET_NAME
, VS.FORMAT_TYPE AS FORMAT_TYPE
, VS.VALIDATION_TYPE AS VALIDATION_TYPE
, VAL.FLEX_VALUE_ID AS FLEX_VALUE_ID
, VAL.FLEX_VALUE AS INTERNAL_NAME
, VAL.FLEX_VALUE_MEANING AS DISPLAY_NAME
, VAL.DESCRIPTION AS DESCRIPTION
, VAL.ENABLED_FLAG AS ENABLED_CODE
, L1.MEANING AS ENABLED_MEANING
, NVL(DO.DISP_SEQUENCE
, VAL.FLEX_VALUE_ID) AS SEQUENCE
, VAL.START_DATE_ACTIVE AS START_DATE
, VAL.END_DATE_ACTIVE AS END_DATE
FROM FND_FLEX_VALUE_SETS VS
, FND_FLEX_VALUES_VL VAL
, EGO_VS_VALUES_DISP_ORDER DO
, FND_LOOKUP_VALUES L1
, EGO_VS_FORMAT_CODES_V L2
, EGO_VS_DISPLAY_CODES_V L3
, EGO_VS_VALIDATION_CODES_V L4
WHERE VS.FLEX_VALUE_SET_ID = VAL.FLEX_VALUE_SET_ID
AND VS.FORMAT_TYPE = L2.LOOKUP_CODE
AND VS.LONGLIST_FLAG = L3.LOOKUP_CODE
AND VS.VALIDATION_TYPE = L4.LOOKUP_CODE
AND L1.LOOKUP_TYPE = 'YES_NO'
AND L1.LOOKUP_CODE = VAL.ENABLED_FLAG
AND L1.LANGUAGE = USERENV('LANG')
AND L1.VIEW_APPLICATION_ID = 0
AND DO.VALUE_SET_VALUE_ID(+) = VAL.FLEX_VALUE_ID
AND DO.VALUE_SET_ID (+) = VAL.FLEX_VALUE_SET_ID