Oracle Application has shipped a standard concurrent Program "Diagnostic Apps check" concurrent Program.
This Concurrent program take application name like (Order Management, Bill of Material, Account Receivable etc) as parameter and PRINTS the complete details about that Application (Module) like
1.All tables included custom if created in that instance
3.All Packages including custom also print the standard package file name along with the version.
4.All Profile options.
This is very interested and useful package if you want to see what all objects are associated with a particular Module.