To find the forms that use a table involves a number of steps. Log in to the application server Change directory to $AU_TOP/forms/US Find it using the command |
grep <name of table> *.fmb |
Once you've got the filenames, you can find the user-friendly version of the form name using:
Log in to Oracle Applications
Log in to Oracle Applications
Switch to Application Developer responsibility
Navigate to Application >> Form
Enter query mode (F11)
Paste the name of the form fmb filename WITHOUT the .fmb extension
Execute query (Ctrl+F11)