(5)
/*根据描述性弹性域的标题查找描述性弹性域表和列*/--
SELECT FND_DFV.TITLE,
FND_DFV.DESCRIPTIVE_FLEXFIELD_NAME ,
FND_DFV.APPLICATION_TABLE_NAME ,
FND_DFU.APPLICATION_COLUMN_NAME,
FND_DFU.FORM_LEFT_PROMPT,
FND_DFU.FORM_ABOVE_PROMPT[@more@]
/*根据描述性弹性域的标题查找描述性弹性域表和列*/--
SELECT FND_DFV.TITLE,
FND_DFV.DESCRIPTIVE_FLEXFIELD_NAME ,
FND_DFV.APPLICATION_TABLE_NAME ,
FND_DFU.APPLICATION_COLUMN_NAME,
FND_DFU.FORM_LEFT_PROMPT,
FND_DFU.FORM_ABOVE_PROMPT[@more@]
FROM FND_DESCRIPTIVE_FLEXS_VL FND_DFV,
FND_DESCR_FLEX_COL_USAGE_VL FND_DFU
WHERE FND_DFV.TITLE='物料' --如:物料
AND FND_DFU.DESCRIPTIVE_FLEXFIELD_NAME=FND_DFV.DESCRIPTIVE_FLEXFIELD_NAME
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/81023/viewspace-799849/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/81023/viewspace-799849/