View: EGO_VALUE_SET_VALUES_V

Product:	EGO - Advanced Product Catalog
Description:	This view contains the value set values supported in EGO Application
Implementation/DBA Data:	APPS.EGO_VALUE_SET_VALUES_V

View Text

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

Columns