Get the column name or table name from prompt of DFF
SELECT
T.FORM_LEFT_PROMPT,T.FORM_ABOVE_PROMPT,
B.DESCRIPTIVE_FLEX_CONTEXT_CODE,
B.APPLICATION_COLUMN_NAME
FROM APPS.FND_DESCR_FLEX_COL_USAGE_TL T,
APPS.FND_DESCR_FLEX_COLUMN_USAGES B
WHERE B.APPLICATION_ID = T.APPLICATION_ID
AND B.DESCRIPTIVE_FLEXFIELD_NAME = T.DESCRIPTIVE_FLEXFIELD_NAME
AND B.DESCRIPTIVE_FLEX_CONTEXT_CODE = T.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND B.APPLICATION_COLUMN_NAME = T.APPLICATION_COLUMN_NAME
AND T.LANGUAGE = 'US'
AND B.APPLICATION_COLUMN_NAME = 'ATTRIBUTE5'
AND (UPPER(T.FORM_LEFT_PROMPT) LIKE '%APPROVAL%STATUS%' OR
T.FORM_ABOVE_PROMPT LIKE '%APPROVAL%STATUS%')
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/206955/viewspace-767099/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
Oracle date format
下一篇：
启动 OBIEE Admintools
请登录后发表评论
登录
全部评论
