Table columns, Forms

Here are some useful tables, views and queries to find tables which contains a certain column or forms which contains a certain personalization action or a form's user name etc.

ALL_TAB_COLS
FND_FORMS_CUSTOM_RULES
FND_FORMS_CUSTOM_ACTIONS
FND_FORM
FND_FORM_TL

select table_name, column_name, data_type, data_length, qualified_col_name from ALL_TAB_COLS

select function_name, description, trigger_event, rl.sequence, rl.enabled, form_name, act.enabled
from FND_FORM_CUSTOM_rules rl, FND_FORM_CUSTOM_ACTIONS act
where rl.id=act.rule_id

select f.application_id, f.form_name, ft.language, ft.user_form_name, ft.description
from FND_FORM f, FND_FORM_TL ft
where f.form_id=ft.form_id