Friday, April 18, 2008

Independent Value set Details

This query gives details of independent FND Value sets i.e. Values are static and these are not derived from any application table

SELECT ffvs.flex_value_set_id
, ffvs.flex_value_set_name
, ffvs.description set_description
, ffvs.validation_type /* This is a lookup code for type 'SEG_VAL_TYPES'
, ffv.flex_value_id
, ffv.flex_value
, ffvt.flex_value_meaning
, ffvt.description value_description
FROM fnd_flex_value_sets ffvs
, fnd_flex_values ffv
, fnd_flex_values_tl ffvt
WHERE ffvs.flex_value_set_name = 'BIS_YES_NO'
AND ffvs.flex_value_set_id = ffv.flex_value_set_id
AND ffv.flex_value_id = ffvt.flex_value_id
AND ffvt.language = USERENV('LANG')

No comments:

Post a Comment