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 Tableau Connector for Oracle Fusion Cloud SCM Views
| Name | Description |
| ChannelCustomerAvailableAccruals | Get channel customer available accruals. |
| ChannelCustomerCheckbookBalances | The Channel Customer Checkbook Balances resource queries total balances for a business unit, calendar year, and customer. It also queries customer balances for a business unit, calendar year, and customer. This resource also queries program balances for a customer. |
| ChannelCustomerProgramCheckbookBalances | The Channel Customer Program Checkbook Balances resource queries total balances for a program, accrue to customer and the associated bill-tos who made the purchases. It also queries customer balances for a program, accrue to customer and the associated bill-tos. This resource also queries bill-to balances for an accrue to customer. |
| ChannelOwnersLOV | Lists the persons who can be assigned as owners of channel programs, including names, emails, and business titles. |
| ChannelProgramsattachments | Manages attachments for channel programs, including file metadata and upload details. |
| ChannelProgramsmarketRulesV2 | Manages market rules that define the eligibility of channel programs, including qualifiers and comparison operators. |
| ChannelProgramsnotes | Manages notes for channel programs, including note text, visibility, and contact details. |
| ChannelSupplierManualAdjustments | Manages manual adjustments for channel supplier programs, including adjustment amounts, types, reasons, and approval details. |
| CjmLovClaimReasons | Lists the claim reasons used in channel claims, including effective dates and flow applicability. |
| CjmLovClaimTypes | Lists the claim types used in channel claims, including effective dates and flow applicability. |
| CjmLovSupplierItems | Lists the supplier items used in channel programs, including item and trading partner item details. |
| 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. |
| ConfigurationsmodelNodesstructureMappings | ConfigurationsmodelNodesstructureMappings |
| CurrencyConversionLists | Manages currency conversion lists used in channel programs, including business units, statuses, and effective dates. |
| FinBusinessUnitsLOV | Returns the available financial business units for use in list-of-values selections. |
| 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. |
| PricingMatrixClassesdimensions | PricingMatrixClassesdimensions |
| SalesOrderActionRequestsmanualPriceAdjustments | Manages manual price adjustments applied through sales order action requests, including adjustment amounts, types, and reasons. |
| 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. |
| SalesOrdersForOrderHublinesassociatedProductReferences | SalesOrdersForOrderHublinesassociatedProductReferences |
| 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. |
| SalesOrdersForOrderHublineschargeschargeTiers | SalesOrdersForOrderHublineschargeschargeTiers |
| SalesOrdersForOrderHublinescoverageReferences | Stores details about coverage items associated with sales order lines, specifying which items they cover. |
| SalesOrdersForOrderHublinescoveredAssetReference | SalesOrdersForOrderHublinescoveredAssetReference |
| 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. |
| SalesOrdersForOrderHublinesrenewSubscriptionReference | SalesOrdersForOrderHublinesrenewSubscriptionReference |
| SalesOrdersForOrderHublinessalesCredits | Tracks sales credit allocations for salespeople involved in the sales order. |
| SalesOrdersForOrderHublinesshipToCustomer | Records shipping customer details linked to sales orders for accurate delivery. |
| SalesOrdersForOrderHublinessubscriptionReferences | SalesOrdersForOrderHublinessubscriptionReferences |
| SalesOrdersForOrderHublinessubscriptionTerm | SalesOrdersForOrderHublinessubscriptionTerm |
| 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. |