Previous  Next          Contents  Index  Navigation  Glossary  Library

Collection Plan and Import Results Database Views

Database views are virtual tables. They allow you to access data without having to know where or how that data is stored.

In Oracle Quality, collection plan and import results database views are dynamically created and updated as you create and update collection plans. View names are derived from the collection plan name. Plan results views use the Q_collection_plan_name_V naming convention. Import results views use the Q_collection_plan_name_IV naming convention.

Collection Plan Views

Collection plan results database views can be used to create custom reports, charts, and views for your quality results. You can also use database views to access quality results with products such as Oracle Discover 2000 and Oracle Developer 2000, as well as other data inquiry products which can select data from an Oracle database.

To make custom reporting easier, foreign key information for entities in other Oracle Applications are automatically included when collection plan results database views are created. This feature makes it possible to dynamically access information in foreign database tables. For example, if your collection plans contains the Supplier (ID for the supplier) collection element, the supplier name can be resolved using the collection plan result database view.

Collection Import Views

Collection import result database view facilitate the insertion of data into the Collection Import Interface Table. Instead of inserting data directly into the import table, you insert data into a view of the table.

See Also

Table and View Definitions, Oracle Quality Technical Reference Manual

Collection Import, Oracle Manufacturing Open Interfaces Manual, Release 11

         Previous  Next          Contents  Index  Navigation  Glossary  Library