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 |
| Carriers | The Carriers resource manages the carriers that fulfillment can use during shipping. Carriers model the shipping methods which can be used, as well as optional contacts and inbound tracking rules. |
| Carrierscontacts | The Contacts resource manages the contact information for a carrier. |
| CarriersDFF | The Flexfields for Carriers resource manages the descriptive flexfields for the carrier. |
| CarriersinboundTrackingRules | The Inbound Tracking Rules resource manages the web service which allows a shipment to be tracked when the carrier is used. |
| CarriersinboundTrackingRulesorganizationAssociations | The Inbound Tracking Rule Organization Associations resource manages the inventory organizations that may use the inbound tracking rule. |
| CarriersinboundTrackingRulesparameters | The Inbound Tracking Rule Parameters resource manages the unique parameter information required by the web service to track a shipment. |
| CarriersshippingMethods | The Shipping Methods resource manages the service level and method of transport that form a shipping method for a carrier. |
| CarriersshippingMethodsDFF | The Flexfields for Shipping Methods resource manages the descriptive flexfields for the shipping method. |
| CarriersshippingMethodsorganizationAssociations | The Shipping Method Organization Associations resource manages the inventory organizations that may use the shipping method. |
| DefaultExpenditureTypesForSupplyChain | The Default Expenditure Types resource manages the default value for an expenditure type for predefined supply chain transactions and business flows that can be integrated with financial projects. The default expenditure type is used if the item involved in the transaction does not have its own default expenditure type set. |
| FlexFndDffDescriptiveFlexfieldContexts | Descriptive Flexfield Contexts |
| FlexFndPvsCharacterIdCharacterValues | FlexFndPvsCharacterIdCharacterValues |
| FlexFndPvsCharacterValues | FlexFndPvsCharacterValues |
| FlexFndPvsNumberIdCharacterValues | FlexFndPvsNumberIdCharacterValues |
| InventoryOrganizations | The Inventory Organizations resource manages subsets of organizations or types of organizations. A logistic, manufacturing, or asset management application can use this resource to find inventory organizations. When creating or updating an Item Organization, only the Starting Revision and Master Item Organization attributes are applicable as child resource attributes. Item Organizations are a lighter weight representation of an organization. All other attributes are specific to Inventory Organizations. |
| InventoryOrganizationsinvOrgParameters | The Parameters resource manages the default values for the warehouse transaction or inventory transaction for each inventory organization. |
| InventoryOrganizationsinvOrgParametersorganizationParameterDFF | The Flexfields for Organization Parameters resource manages the descriptive flexfields for the inventory organization. |
| InventoryOrganizationsLOV | The Inventory Organizations List of Values (LOV) resource displays organizations or types of organizations. A logistic, manufacturing, or asset management application can use this resource to find inventory organizations. |
| InventoryOrganizationsplantParameters | The Plant Parameters resource manages the plant default values for each manufacturing organization or maintenance organization. |
| ItemUnitOfMeasureConversions | The Item Unit of Measure Conversions resource retrieves conversion data that may be used to report on transaction lines and convert transaction quantities to the primary unit of measure of the item. |
| PackagingStrings | The Packaging Strings resource manages the packaging strings that are associated with one or more items for use during transactions. |
| ProjectAttributeDefaultsForSupplyChain | The Project Attribute Defaults resource manages the ability to model default values for the projects, tasks, and expenditure organizations that are used in supply chain transactions. The defaults are modeled hierarchically to allow greater specificity when more inputs to the combination of project, task and organization are supplied. |
| ProjectAttributeDefaultsForSupplyChainDFF | The Flexfields for Project Attribute Defaults resource manages the descriptive flexfield default values to use for a combination of project, task, and expenditure organization. A supply chain transaction will retrieve the defaults to use for the project flexfields, giving precedence to defaults defined at the most specific level and using defaults at less specific combinations if a default value for an attribute is not defined. |
| ProjectTypeCostExclusionsForSupplyChain | The Project Type Cost Exclusions resource manages the status of whether a project does or does not use project costing. All projects using a project type inherit the behavior specified for that project type. The default state for all project types is to include costing. The POST operation changes this state to excluded. The DELETE operation reverts the project type to its default state to include costing. |
| ScheduleExceptions | The Schedule Exceptions resource defines a global change to the working time that you assign to one or more schedules. For example, a holiday. When assigned to a schedule, the exception updates the working time for any business objects using the associated schedule. |
| Schedules | The Schedules resource defines a schedule of working time assigned to one or more business objects. |
| SchedulesscheduleExceptionAssociations | The Schedule Exception Associations resource is used to assign one or more schedule exceptions to the schedule. |
| SchedulesscheduleWorkdayPatterns | The Schedule Workday Patterns resource is used to assign one or more workday patterns to the schedule. |
| Shifts | The Shifts resource gets the values for the working time for any business object using the associated schedule. Shifts repeat in Workday Patterns that repeat as part of a Schedule definition. Business objects that reference Schedule use the Shift definition to know which days and times are the working and non-working periods. |
| ShiftsshiftDetails | The Shift Details resource gets the collection of time segments that decompose the working time of the Shift. Only Time shifts that are of type Flexible or Punch have shift details. |
| 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. |
| TransitTimes | The Transit Times resource gets the transit times that indicate how long a package or shipment will be in transit. |
| TransitTimesshippingMethods | The Shipping Methods resource gets the shipping method associated between the origin and destination locations. |
| TransitTimesshippingMethodsDFF | The Flexfields for Shipping Methods resource manages the descriptive flexfields for the shipping method. |
| UnitOfMeasureClasses | The Unit of Measure Classes resource gets the classes that organize units of measure. |
| UnitOfMeasureClassesDFF | The Flexfields for Unit of Measure Classes resource manages the descriptive flexfields for the unit of measure class. |
| UnitOfMeasureClassesinterclassConversions | The Unit of Measure Interclass Conversions resource gets the interclass conversion rate for an item between two unit of measure classes. |
| UnitsOfMeasure | The Units of Measure resource gets the units of measure that an application, system, or service can use with the transaction. |
| UnitsOfMeasureDFF | The Flexfields for Units of Measure resource manages the descriptive flexfields for the unit of measure. |
| UnitsOfMeasureintraclassConversions | The Unit of Measure Intraclass Conversions resource gets the intraclass conversion rate for an item between a unit of measure and the base unit in the same class. The intraclass conversion supersedes the standard conversion rate. |
| WorkdayPatterns | The Workday Patterns resource defines how to apply one or more shifts to define the working time for any business object using the associated schedule. Workday patterns have length in days, and have associated shifts that detail what days are active within a pattern. Patterns repeat as part of a schedule definition from the schedule start date to the schedule end date, resulting in the shifts forming repeated patterns within the schedule. |
| WorkdayPatternsworkdayPatternShifts | The Pattern Shifts resource gets the collection of shifts that you assign to a pattern. |