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博客 ” ，链接：http://blog.itpub.net/206955/viewspace-767099/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/206955/viewspace-767099/