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_IDb.APPLICATION_TABLE_NAME IN (UPPER ('<table_name>'))
AND b.DESCRIPTIVE_FLEXFIELD_NAME = a.DESCRIPTIVE_FLEXFIELD_NAME
No comments:
Post a Comment