Like this:

Check on this Custom SQL for the same.

SELECT   dff.descriptive_flexfield_

name,
dff.application_table_name,
app.application_short_name app,
u.descriptive_flex_context_code,
u.application_column_name,
u.end_user_column_name
FROM     fnd_descr_flex_column_usages u,
fnd_descriptive_flexs dff,
fnd_application app
WHERE    u.descriptive_flexfield_name NOT LIKE ‘$SRS$.%’
AND      dff.descriptive_flexfield_name = u.descriptive_flexfield_name
AND      app.application_id = dff.table_application_id
–AND      dff.application_table_name = ‘OE_ORDER_HEADERS_ALL’
–and u.descriptive_flexfield_name = ‘RA_ADDRESSES_HZ’
ORDER BY app.application_short_name,
descriptive_flexfield_name,
descriptive_flex_context_code,
TO_NUMBER (REGEXP_REPLACE (u.application_column_name,
‘[^0-9]‘))

Advertisement