Views
Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.
Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.
Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.
CData JDBC Driver for Oracle SCM Views
| Name | Description |
| FlexFndDffDescriptiveFlexfieldContexts | Descriptive Flexfield Contexts |
| FlexFndPvsCharacterIdCharacterValues | FlexFndPvsCharacterIdCharacterValues |
| FlexFndPvsCharacterValues | FlexFndPvsCharacterValues |
| FlexFndPvsNumberIdCharacterValues | FlexFndPvsNumberIdCharacterValues |
| InspectionEvents | The Inspection Events resource manages inspection results. |
| InspectionEventsAttachments | The Event Attachments resource is used to view, create, or modify the attachments for the inspection events. |
| InspectionEventsEventDisposition | The Event Dispositions resource manages event dispositions. |
| InspectionEventsSample | The Samples resource manages sample items. |
| InspectionEventsSampleSampleDisposition | The Sample Dispositions resource manages sample item dispositions. |
| InspectionEventsSampleSampleDispositionSampleResult | The Sample Results resource manages the sample results for an item. |
| InspectionEventsSampleSampleDispositionSampleResultAttachments | The Result Attachments resource manages the attachments for the sample results. |
| InspectionEventsSampleSampleDispositionSampleResultResultEvaluation | The Result Evaluations resource manages the evaluation results. |
| InspectionFlagCommonParams | The Inspection Parameters resource manages inspection details. |
| InspectionPlans | The Inspection Plans resource manages inspection plan details. |
| InspectionPlansattachments | The Attachments in Inspection Plans resource displays attachment details for the inspection plan. |
| InspectionPlanscriteria | The Criteria in Inspection Plans resource manages criteria for the inspection plan. |
| InspectionPlansspecifications | The Specifications in Inspection Plans resource manages the specifications of the inspection plan. |
| InspectionPlansspecificationsattachments | The Specification Attachments in Inspection Plans resource displays attachment details for the specifications of the inspection plan. |
| ProductionResources | The Production Resources resource manages production resources that a manufacturing plant uses. A production resource can include labor, equipment, and tools that you allocate to a work center. You can categorize a production resource as Labor or Equipment. |
| ProductionResourcesEquipmentInstance | The Equipment Instances resource manages instances of an equipment resource. |
| ProductionResourcesEquipmentInstanceEquipmentInstanceDFF | The Flexfields for Equipment Instances resource manages descriptive flexfields that the equipment instances uses. |
| ProductionResourcesLaborInstance | The Labor Instances resource manages instances of a labor resource. |
| ProductionResourcesLaborInstanceLaborInstanceDFF | The Flexfields for Labor Instances resource manages descriptive flexfields that the labor instances uses. |
| ProductionResourcesResourceDFF | The Flexfields for Resources resource manages descriptive flexfields that the production resource uses. |
| StandardLookupsLOV | The standard lookups list of values resource is used to query the list of values of standard lookups, which list the available codes and translated meanings. Standard lookups are defined in the standard lookups view and store lookup codes that support reference data sharing. |
| StandardOperations | The Standard Operations resource manages standard operations. |
| StandardOperationsStandardOperationAttachment | The Attachments resource manages attachments that contain details about the standard operation. |
| StandardOperationsStandardOperationDFF | The Flexfields resource manages descriptive flexfields that contain details about the standard operation. |
| StandardOperationsStandardOperationResource | The Resources resource manages resources that the standard operation uses. |
| StandardOperationsStandardOperationResourceStandardOperationAlternateResource | The Alternative Resources resource manages alternative resources that the standard operation uses. |
| StandardOperationsStandardOperationResourceStandardOperationResourceAttachment | The attachments resource is used to view, create, and update attachments. |
| StandardOperationsStandardOperationResourceStandardOperationResourceDFF | The Flexfields for Resources resource manages descriptive flexfields that contain details about the standard operation resource. |
| WorkAreas | The Work Areas resource manages the names of the work areas that a manufacturing plant contains. A work area is a physical area in a manufacturing plant where the plant performs production. |
| WorkAreasWorkAreaDFF | The Flexfields for Work Areas resource manages the names of the descriptive flexfields that a work area references. |
| WorkCenters | The Work Centers resource manages work centers that the work area contains. A work center is a production unit that consists of people or equipment who possess similar capabilities. Each work center is part of a work area. You can use it to plan capacity requirements and to schedule detailed work. |
| WorkCentersWorkCenterDFF | The Flexfields for Work Centers resource manages the descriptive flexfields that the work center references. |
| WorkCentersWorkCenterResource | The Work Center Resources resource manages work center resources that the work center uses. |
| WorkCentersWorkCenterResourceWorkCenterResourceShift | The Shifts for Work Center Resources manages the shifts for each work center resource. The application automatically creates each shift when you assign a production resource to a work center. |
| WorkCentersWorkCenterSubinventory | The Subinventories for Work Centers resource manages the subinventories that each work center uses. You can use only one subinventory as the supply subinventory for each work center. |
| WorkDefinitionNames | The Work Definition Names resource manages the work definition names. A work definition name is used to define the different methods of making a given product. |
| WorkDefinitionNamestranslations | The Translations resource gets the work definition name and descriptions in different languages. |
| WorkDefinitions | The Work Definitions resource gets the details of the work definition. This resource cannot be used to create and update the work definitions. |
| WorkDefinitionsWorkDefinitionAttachment | The Attachments for Work Definitions resource gets the attachments that the work definition references. |
| WorkDefinitionsWorkDefinitionMaterial | The Work Definition Materials resource gets all the materials of a work definition across the operations. |
| WorkDefinitionsWorkDefinitionMaterialWorkDefinitionOperationMaterialAttachment | The attachments resource is used to view, create, and update attachments. |
| WorkDefinitionsWorkDefinitionMaterialWorkDefinitionOperationMaterialDFF | The Flexfields for Materials resource gets the descriptive flexfields that contain details about the material. |
| WorkDefinitionsWorkDefinitionMaterialWorkDefinitionOperationSubstituteMaterial | The Substitute Materials resource gets the substitute materials that the work definition operation uses. |
| WorkDefinitionsWorkDefinitionOperation | The Operations resource gets the operations for the work definition. |
| WorkDefinitionsWorkDefinitionOperationtranslations | The Translations for Operations resource gets the translations for operation name and operation description. |
| WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationAttachment | The Attachments for Operations resource gets the attachments that the work definition operation uses. |
| WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationDFF | The Flexfields for Operations resource gets the descriptive flexfields that contain details about the work definition operation. |
| WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial | The Materials for Operations gets the materials that the work definition operation uses. |
| WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterialWorkDefinitionOperationMaterialAttachment | The Attachments for Materials resource gets the attachments that contain details about the material. |
| WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterialWorkDefinitionOperationMaterialDFF | The Flexfields for Materials resource gets the descriptive flexfields that contain details about the material. |
| WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterialWorkDefinitionOperationSubstituteMaterial | The Substitute Materials resource gets the substitute materials that the work definition operation uses. |
| WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationOutput | The Outputs for Operations gets the output that the work definition operation uses. |
| WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationOutputWorkDefinitionOperationOutputAttachment | The Attachments for Outputs resource gets the attachments that contain details about the output. |
| WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationOutputWorkDefinitionOperationOutputDFF | The Flexfields for Outputs resource gets the descriptive flexfields that contain details about the output. |
| WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationResource | The Resources for Operations resource gets the resources that the work definition operation uses. |
| workDefinitionsWorkDefinitionOperationWorkDefinitionOperationResourceWorkDefinitionOperationAlternateResource | The Alternate Resources resource gets the alternate resources that the work definition operation uses. |
| WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationResourceWorkDefinitionOperationResourceAttachment | The Attachments for Resources resource gets the attachments that contain details about the resource. |
| WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationResourceWorkDefinitionOperationResourceDFF | The Flexfields for Resources resource gets the descriptive flexfields that contain details about the resource that the work definition operation uses. |
| WorkDefinitionsWorkDefinitionOutput | The Work Definition Outputs resource gets all the outputs of a work definition across the operations. |
| WorkDefinitionsWorkDefinitionOutputWorkDefinitionOperationOutputAttachment | The attachments resource is used to view, create, and update attachments. |
| WorkDefinitionsWorkDefinitionOutputWorkDefinitionOperationOutputDFF | The Flexfields for Outputs resource gets the descriptive flexfields that contain details about the output. |
| WorkDefinitionsWorkDefinitionResource | The Work Definition Resources resource gets all the resources of a work definition across the operations. |
| WorkDefinitionsWorkDefinitionResourceWorkDefinitionOperationAlternateResource | The Alternate Resources resource gets the alternate resources that the work definition operation uses. |
| WorkDefinitionsWorkDefinitionResourceWorkDefinitionOperationResourceAttachment | The attachments resource is used to view, create, and update attachments. |
| WorkDefinitionsWorkDefinitionResourceWorkDefinitionOperationResourceDFF | The Flexfields for Resources resource gets the descriptive flexfields that contain details about the resource that the work definition operation uses. |
| WorkOrderStatuses | The Work Order Statuses resource manages the work order statuses. |