/*?根據(jù)窗口名稱查找關(guān)鍵字彈性域用到的表，列等信息*/?--
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窗口的標(biāo)題
???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;
???
--根據(jù)上面FLEX_VALUE_SET_ID查彈性域的數(shù)據(jù)
select?*?
??from?fnd_flex_values_vl?t?
?where?t.flex_value_set_id?=?1005982;?--?FLEX_VALUE_SET_ID

--具體某一數(shù)據(jù)
select?*
??from?fnd_flex_values_vl?t
?where?t.flex_value_set_id?=?1005982
???and?t.flex_value?=?'720611';

轉(zhuǎn)載于:https://www.cnblogs.com/benio/archive/2010/12/31/1922903.html

總結(jié)

以上是生活随笔為你收集整理的根据窗口名称查找关键字弹性域用到的表，列等信息的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。