Monday, May 6, 2013

how to find values set values

select * from fnd_flex_value_sets where flex_value_set_name='p_conv_opt'--flex_value_set_id=1015234

 select flex_value          ,
  flex_value_meaning        ,
  description               ,
  enabled_flag              ,
  start_date_active         ,
  end_date_active           ,
  summary_flag              ,
  hierarchy_level           ,
  flex_value_set_id         ,
  parent_flex_value_low     ,
  parent_flex_value_high    ,
  flex_value_id             ,
  last_update_date          ,
  last_updated_by           ,
  structured_hierarchy_level,
  compiled_value_attributes ,
  value_category            ,
  attribute1                ,
  attribute2                ,
  attribute3                ,
  attribute4                ,
  attribute5                ,
  attribute6                ,
  attribute7                ,
  attribute8                ,
  attribute9                ,
  attribute10               ,
  created_by                ,
  creation_date             ,
  last_update_login         ,
  attribute11               ,
  attribute12               ,
  attribute13               ,
  attribute14               ,
  attribute15               ,
  attribute16               ,
  attribute17               ,
  attribute18               ,
  attribute19               ,
  attribute20               ,
  attribute21               ,
  attribute22               ,
  attribute23               ,
  attribute24               ,
  attribute25               ,
  attribute26               ,
  attribute27               ,
  attribute28               ,
  attribute29               ,
  attribute30               ,
  attribute31               ,
  attribute32               ,
  attribute33               ,
  attribute34               ,
  attribute35               ,
  attribute36               ,
  attribute37               ,
  attribute38               ,
  attribute39               ,
  attribute40               ,
  attribute41               ,
  attribute42               ,
  attribute43               ,
  attribute44               ,
  attribute45               ,
  attribute46               ,
  attribute47               ,
  attribute48               ,
  attribute49               ,
  attribute50               ,
  attribute_sort_order      ,
  row_id
   from fnd_flex_values_vl
  where ((''                   is null)
or (structured_hierarchy_level in
  (select hierarchy_id
     from fnd_flex_hierarchies_vl h
    where h.flex_value_set_id = 1015234
  and h.hierarchy_name like ''
  )))
and (flex_value_set_id=1015234)
rder by flex_value

No comments:

Post a Comment