Overview of Tables and Views
This guide contains the information about tables within Oracle Fusion Cloud Supply Chain Management and their columns, primary keys, and indexes. The guide also includes the information about views within Oracle Cloud Supply Chain Management along with the columns and queries associated with each view. For your reference:
-
Tables are the basic unit of data storage in Oracle Cloud Supply Chain Management, where data is stored in rows and columns. For example, the EGP_SYSTEM_ITEMS_B table stores all general information about items, such as item number, description, and operational attributes.
-
A view is a logical representation of a table or combination of tables. A view is a stored query that derives its data from the tables on which it is based. For example, the INV_PENDING_TXNS_V view shows the key attributes for the staged and validated inventory transactions, such as transaction type, transaction quantity, process status, transaction date, and so on.