Oracle ERP二次开发常用脚本（4）

(4).
/* 根据窗口名称查找关键字弹性域用到的表，列等信息*/--
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'[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/81023/viewspace-799848/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/81023/viewspace-799848/