根據窗口名稱查找關鍵字彈性域用到的表，列等信息

/*?根據窗口名稱查找關鍵字彈性域用到的表，列等信息*/?--
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';