Value Set 데이터 조회 Query

Oracle EBS의 Value Set 및 Value값을 조회하는 Query

 

/* value set에서 COA Account를 찾는다. */
SELECT *
  FROM FND_FLEX_VALUE_SETS
 WHERE 1=1
and flex_value_set_name like '%COA_ACCOUNT%'

 

/* value 에서 COA Account 값을 찾는다. */
SELECT ffv.flex_value_set_id
      ,ffv.flex_value_id
      ,ffv.flex_value
      ,ffvt.description
      ,ffv.enabled_flag
      ,ffv.summary_flag
      ,ffv.start_date_active
      ,ffv.end_date_active
      ,ffv.structured_hierarchy_level
      ,ffv.hierarchy_level
      ,ffv.compiled_value_attributes
FROM   fnd_flex_values    ffv
      ,fnd_flex_values_tl ffvt
WHERE  1 = 1
AND    flex_value_set_id = 1017574
AND    LANGUAGE = 'KO'
AND    ffv.flex_value_id = ffvt.flex_value_id
ORDER  BY ffv.flex_value;