Sunday, June 24, 2012

Query to know the Attributes(DFF Fields) Actual Column Names in Oracle tables



SELECT
b.APPLICATION_TABLE_NAME,
b.DESCRIPTIVE_FLEXFIELD_NAME,
a.DESCRIPTIVE_FLEX_CONTEXT_CODE,
a.APPLICATION_COLUMN_NAME,
a.END_USER_COLUMN_NAME
FROM
FND_DESCR_FLEX_COLUMN_USAGES a,
FND_DESCRIPTIVE_FLEXS_vl b
WHERE
b.APPLICATION_TABLE_NAME in (UPPER('<table_name>')) AND
b.DESCRIPTIVE_FLEXFIELD_NAME=a.DESCRIPTIVE_FLEXFIELD_NAME AND b.APPLICATION_ID=a.APPLICATION_ID