Classification of tables in Oracle Applications

1. Transaction Data table : They are normal tables, they are used to stored the data in all the modules in which any DML queries can be performed.

2.Seed data tables: The data in these tables are created at the time of installation. The records in these tables are read only.

3.Interim data table: These tables are used for validations purpose. For instance, Staging tables. These tables are used when we are transferring the data from the external application. to the system tables.