column,table,application,appshortname sql query

select ft.table_name,fc.column_name, fa.application_id, fa.application_short_name, fat.application_name
from fnd_tables ft,
 fnd_columns fc,
 fnd_application fa, fnd_application_tl fat
where ft.table_id = fc.table_id
and fc.column_name = 'CREATION_DATE'
and fa.application_id = ft.application_id
and fa.application_id = fc.application_id
and fa.application_id = fat.application_id