Views
Views are similar to tables in the way that data is represented; however, views are read-only.
Queries can be executed against a view as if it were a normal table.
CData ODBC Driver for Oracle Sales Views
| Name | Description |
| AccountAttachments | An attachment includes additional information about an account. |
| AccountHierarchy | The account hierarchy summaries resource is used to view the account hierarchy information. |
| ActivityAttachments | An attachment includes additional information about an activity |
| ActivityFunctionLookups | Usage information for the operation ActivityFunctionLookups.rsd. |
| CatalogProductGroups | Usage information for the operation CatalogProductGroups.rsd. |
| ContactAttachments | An attachment includes additional information about a contact. |
| ContactsPictureAttachments | The contact picture attachment resource is used to view, create, and update the resource's picture.Get a resource's picture |
| EmployeeResourceAttachments | The contact picture attachment resource is used to view, create, and update the resource's picture.Get a resource's picture |
| OpportunityAttachments | An attachment includes additional information about an opportunity. |
| OpportunityDeals | A deal associated with the opportunity. |
| OpportunityRevenueProductGroups | The product group resource is used to view, create, and update the product groups associated with an opportunity. The product group let you categorize products and services that you sell. |
| OpportunityRevenueProducts | The following table describes the default response for this task. |
| Resources | The resources resource is used to view, create, and update a resource. A resource is a person within the deploying company who can be assigned work to accomplish business objectives, such as sales persons or partner members. |
| ResourceUsersResourceRoleAssignments | The resource role assignments resource is used to view the role assigned to a resource, such as implementer, reseller, and so on. |
| SalesLeadAttachments | The attachment resource is used to view, create, and update attachments of a sales lead. |
| SalesLeadsLeadOpportunity | The opportunity resource is used to view, create, or modify an opportunity generated from a lead. An opportunity list associated with the lead represents leads that have already been converted to the list of opportunities. |
| SalesLeadsLeadTeam | The lead teams resource is used to view the team members and territory team members associated with a lead. |
| SalesLeadsProductGroups | The product groups resource is used to capture the name of the product group associated with the sales lead. |
| SalesLeadsProducts | The product resource is used to capture the name of the product associated with the sales lead. |
| SalesLeadTerritories | The sales lead territories resource is used to view the associated sales lead territories. |
| ServiceDetails | Usage information for the operation ServiceDetails.rsd. |