根据窗口名称查找关键字弹性域用到的表，列等信息

/*  根据窗口名称查找关键字弹性域用到的表，列等信息 */   --
select  c.id_flex_name,
       a.id_flex_structure_name,
       b.form_left_prompt,
       c.application_table_name,
       b.application_column_name,
       b.flex_value_set_id
   from  fnd_id_flex_structures_vl a,
       fnd_id_flex_segments_vl   b,
       fnd_id_flexs              c
  where  a.id_flex_structure_name  =   ' 帐户别名 '   -- 用你自己要查的代替，就是Form窗口的标题
    and  a.application_id  =  b.application_id
    and  a.id_flex_code  =  b.id_flex_code
    and  a.id_flex_num  =  b.id_flex_num
    and  a.application_id  =  c.application_id
    and  a.id_flex_code  =  c.id_flex_code;
   
-- 根据上面FLEX_VALUE_SET_ID查弹性域的数据
select   *  
   from  fnd_flex_values_vl t 
  where  t.flex_value_set_id  =   1005982 ;  --  FLEX_VALUE_SET_ID

-- 具体某一数据
select   *
   from  fnd_flex_values_vl t
  where  t.flex_value_set_id  =   1005982
    and  t.flex_value  =   ' 720611 ' ;