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 JDBC Driver for Oracle Fusion Cloud SCM Views


Name	Description
Configurations	Stores configuration details used in order management, defining customizable settings.
ConfigurationsConfigurationLineAttributes	Tracks transactional item attributes for configurations or configuration lines, ensuring accurate configuration management.
ConfigurationsConfigurationLines	Manages individual configuration lines, defining specific details for each line.
ConfigurationsConfigurationMessages	Stores messages related to configurations, facilitating communication and error handling.
ConfigurationsconnectedItems	Tracks connected items linked to a configuration, ensuring comprehensive item management.
ConfigurationsmodelNodes	Manages model nodes for active configurations, defining hierarchical structure.
ConfigurationsmodelNodesmodelNodes	Tracks hierarchical relationships among model nodes for configurations, enabling complex model management.
Finders	Lists finder names and their attributes for specific views, aiding in view management.
FlexFndDffDescriptiveFlexfieldContexts	Provides access to descriptive flexfield contexts through the Oracle REST API, enabling customization and data retrieval.
FlexFndPvsCharacterIdCharacterValues	Manages character value attributes across different flexfields for comprehensive value tracking.
FlexFndPvsCharacterValues	Tracks character-based values for flexfields, enabling flexible attribute management.
FlexFndPvsNumberIdCharacterValues	Tracks numerical values for flexfields, facilitating numerical attribute management.
PricingMatrixClasses	Stores information about pricing matrix classes, supporting dynamic pricing strategies.
SalesOrdersForOrderHub	Enables creation, retrieval, and updating of sales orders, offering comprehensive order management capabilities.
SalesOrdersForOrderHubadditionalInformation	Manages additional details stored in flexfields for sales orders, supporting detailed data tracking.
SalesOrdersForOrderHubattachments	Tracks documents attached to sales orders, ensuring proper documentation for order processing.
SalesOrdersForOrderHubbillToCustomer	Manages billing information associated with customers linked to sales orders, ensuring accurate invoicing.
SalesOrdersForOrderHubcopyOrderReference	Tracks references to original orders used as templates for creating new orders, enabling order duplication.
SalesOrdersForOrderHubholds	Tracks active and released holds on order lines, providing visibility into order processing constraints.
SalesOrdersForOrderHublines	Manages detailed information about sales order lines, including item specifications, quantities, and associated order details.
SalesOrdersForOrderHublinesadditionalInformation	Stores additional, customizable sales order data maintained using flexfields to meet specific business needs.
SalesOrdersForOrderHublinesamendSubscriptionReferences	Tracks references for subscription amendments, facilitating seamless integration with Oracle Subscription Management Cloud for subscription line updates and replacements.
SalesOrdersForOrderHublinesassetTransactionDetails	Captures asset transaction data to support license migrations; currently not actively used in operations.
SalesOrdersForOrderHublinesattachments	Manages documents and files attached to both sales order headers and order lines for better traceability.
SalesOrdersForOrderHublinesbillingPlans	Tracks the billing plans linked to sales orders, including schedule and payment terms.
SalesOrdersForOrderHublinesbillToCustomer	Records billing customer information referenced by sales order headers for invoicing purposes.
SalesOrdersForOrderHublineschannelPrograms	Stores details about channel programs associated with sales order lines for targeted marketing or sales strategies.
SalesOrdersForOrderHublinescharges	Tracks pricing information, including charges and applied costs for sales orders.
SalesOrdersForOrderHublineschargeschargeComponents	Manages detailed breakdowns of pricing components, such as taxes and discounts, at the order line level.
SalesOrdersForOrderHublinescoverageReferences	Stores details about coverage items associated with sales order lines, specifying which items they cover.
SalesOrdersForOrderHublinescoveredProductReferences	Tracks items covered by specific coverage items, ensuring warranty and service consistency.
SalesOrdersForOrderHublinesdropShipPurchaseOrderReference	Tracks purchase orders used in drop shipping scenarios for sales order fulfillment.
SalesOrdersForOrderHublinesdropShipRequisitionReference	Manages requisitions linked to drop-ship orders, coordinating third-party fulfillment processes.
SalesOrdersForOrderHublinesexternalAssetReference	Stores external asset references tied to subscription items, aiding integration with external systems.
SalesOrdersForOrderHublinesexternalFulfillmentSalesOrderReference	Tracks sales orders submitted to external fulfillment systems for processing and delivery.
SalesOrdersForOrderHublinesholds	Manages active and released holds on sales order lines, enabling better control of order processing.
SalesOrdersForOrderHublinesinternalOrderReference	Tracks sales orders that are managed internally within the order management system.
SalesOrdersForOrderHublineslineDetails	Records specific details about shipping and billing for each order line, including carrier and payment terms.
SalesOrdersForOrderHublineslotSerials	Captures lot and serial number details for inventory management, especially for returns or traceable items.
SalesOrdersForOrderHublinesmanualPriceAdjustments	Tracks manual price adjustments made to sales order lines by Order Entry Specialists.
SalesOrdersForOrderHublinesoriginalOrderReference	Tracks the original order linked to return sales orders for reconciliation.
SalesOrdersForOrderHublinespayments	Manages detailed payment records associated with sales orders, including methods and schedules.
SalesOrdersForOrderHublinespriceAdjustments	Manages price changes such as discounts applied to sales orders.
SalesOrdersForOrderHublinespriceValidations	Ensures compliance with pricing rules by tracking validations and resolving pricing violations.
SalesOrdersForOrderHublinesproject	Tracks project-related data associated with sales order lines for cost allocation and tracking.
SalesOrdersForOrderHublinesprojectprojectDetail	Manages detailed project information associated with specific sales order lines.
SalesOrdersForOrderHublinessalesCredits	Tracks sales credit allocations for salespeople involved in the sales order.
SalesOrdersForOrderHublinesshipToCustomer	Records shipping customer details linked to sales orders for accurate delivery.
SalesOrdersForOrderHublinessupplyOrderReference	Manages references to supply orders used to fulfill sales order requirements.
SalesOrdersForOrderHublinestransactionItemAttributes	Tracks transaction-specific attributes for items on each order line, supporting custom requirements.
SalesOrdersForOrderHubpayments	Manages payment-related data for the entire sales order, including totals and payment terms.
SalesOrdersForOrderHubsalesCredits	Tracks salesperson credit distribution for completed sales orders.
SalesOrdersForOrderHubshipToCustomer	Manages customer shipping information for all orders under the sales order hub.
SalesOrdersForOrderHubtotals	Tracks total sales order costs, including subtotals and tax calculations.
SalesOrdersForOrderHubtotalstotalComponents	Breaks down components contributing to total order costs for transparency.
StandardLookupsLOV	Provides a comprehensive list of available lookup values and associated metadata for standard references.