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 ADO.NET Provider for Oracle Fusion Cloud Financials Views
| Name | Description |
| AccountCombinationsLOV | AccountCombinationsLOV |
| AccountCombinationsShorthandAliasesLOV | AccountCombinationsShorthandAliasesLOV |
| AccountingCalendarsLOV | AccountingCalendarsLOV |
| AccountingPeriodsLOV | AccountingPeriodsLOV |
| AccountingPeriodStatusLOV | AccountingPeriodStatusLOV |
| BankAccountUserRules | BankAccountUserRules |
| BudgetaryControlResults | BudgetaryControlResults |
| BudgetaryControlResultsBudgetImpacts | BudgetaryControlResultsBudgetImpacts |
| BudgetaryControlResultsBudgetTransactions | BudgetaryControlResultsBudgetTransactions |
| ChartOfAccountsLOV | ChartOfAccountsLOV |
| CurrencyConversionTypesLOV | CurrencyConversionTypesLOV |
| CurrencyRates | CurrencyRates |
| DisbursementPaymentMethodsLOV | DisbursementPaymentMethodsLOV |
| ErpBusinessEvents | ErpBusinessEvents |
| Erpintegrations | This view will return maximum of 500 records. The view is deprecated. |
| ExpenseAccommodationsPolicies | ExpenseAccommodationsPolicies |
| ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines | ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
| ExpenseAirfarePolicies | ExpenseAirfarePolicies |
| ExpenseAirfarePoliciesexpenseAirfarePolicyLines | ExpenseAirfarePoliciesexpenseAirfarePolicyLines |
| ExpenseCashAdvances | ExpenseCashAdvances |
| ExpenseCashAdvancesAttachments | ExpenseCashAdvancesAttachments |
| ExpenseCashAdvancesCashAdvanceDff | ExpenseCashAdvancesCashAdvanceDff |
| ExpenseConversionRateOptions | ExpenseConversionRateOptions |
| ExpenseConversionRateOptionsconversionRateTolerances | ExpenseConversionRateOptionsconversionRateTolerances |
| ExpenseCreditCardTransactions | ExpenseCreditCardTransactions |
| ExpenseDelegations | ExpenseDelegations |
| ExpenseDffContexts | ExpenseDffContexts |
| ExpenseDffSegments | ExpenseDffSegments |
| ExpenseDistributions | ExpenseDistributions |
| ExpenseDistributionsPJCDFF | ExpenseDistributionsPJCDFF |
| ExpenseEntertainmentPolicies | ExpenseEntertainmentPolicies |
| ExpenseEntertainmentPoliciesexpenseEntertainmentPolicyLines | ExpenseEntertainmentPoliciesexpenseEntertainmentPolicyLines |
| ExpenseLocations | ExpenseLocations |
| ExpenseMealsPolicies | ExpenseMealsPolicies |
| ExpenseMealsPoliciesexpenseMealsPolicyLines | ExpenseMealsPoliciesexpenseMealsPolicyLines |
| ExpenseMileagePolicies | ExpenseMileagePolicies |
| ExpenseMileagePoliciesexpenseMileagePolicyLines | ExpenseMileagePoliciesexpenseMileagePolicyLines |
| ExpenseMiscPolicies | ExpenseMiscPolicies |
| ExpenseMiscPoliciesexpenseMiscPolicyLines | ExpenseMiscPoliciesexpenseMiscPolicyLines |
| ExpenseOrganizationSettings | ExpenseOrganizationSettings |
| ExpensePerDiemCalculations | ExpensePerDiemCalculations |
| ExpensePerDiemPolicies | ExpensePerDiemPolicies |
| ExpensePerDiemPoliciesexpensePerDiemPolLines | ExpensePerDiemPoliciesexpensePerDiemPolLines |
| ExpensePerDiemPoliciesexpensePerDiemPolValues | ExpensePerDiemPoliciesexpensePerDiemPolValues |
| ExpensePersons | ExpensePersons |
| ExpensePreferences | ExpensePreferences |
| ExpensePreferredTypes | ExpensePreferredTypes |
| ExpenseProfileAttributes | ExpenseProfileAttributes |
| ExpenseReports | ExpenseReports |
| ExpenseReportsAttachments | ExpenseReportsAttachments |
| ExpenseReportsExpense | ExpenseReportsExpense |
| ExpenseReportsExpenseAttachments | ExpenseReportsExpenseAttachments |
| ExpenseReportsExpenseduplicateExpenses | ExpenseReportsExpenseduplicateExpenses |
| ExpenseReportsExpenseExpenseAttendee | ExpenseReportsExpenseExpenseAttendee |
| ExpenseReportsExpenseExpenseDff | ExpenseReportsExpenseExpenseDff |
| ExpenseReportsExpenseExpenseDistribution | ExpenseReportsExpenseExpenseDistribution |
| ExpenseReportsExpenseExpenseDistributionPJCDFF | ExpenseReportsExpenseExpenseDistributionPJCDFF |
| ExpenseReportsExpenseexpenseErrors | ExpenseReportsExpenseexpenseErrors |
| ExpenseReportsExpenseExpenseItemization | ExpenseReportsExpenseExpenseItemization |
| ExpenseReportsExpensematchedExpenses | ExpenseReportsExpensematchedExpenses |
| ExpenseReportsexpenseNotes | ExpenseReportsexpenseNotes |
| ExpenseReportsExpensePayment | ExpenseReportsExpensePayment |
| ExpenseReportsExpenseReportDff | ExpenseReportsExpenseReportDff |
| ExpenseReportsprocessingDetails | ExpenseReportsprocessingDetails |
| Expenses | Expenses |
| ExpensesAttachments | ExpensesAttachments |
| ExpensesduplicateExpenses | ExpensesduplicateExpenses |
| ExpenseSetupOptions | ExpenseSetupOptions |
| ExpensesExpenseAttendee | ExpensesExpenseAttendee |
| ExpensesExpenseDff | ExpensesExpenseDff |
| ExpensesExpenseDistribution | ExpensesExpenseDistribution |
| ExpensesExpenseDistributionPJCDFF | ExpensesExpenseDistributionPJCDFF |
| ExpensesexpenseErrors | ExpensesexpenseErrors |
| ExpensesExpenseItemization | ExpensesExpenseItemization |
| ExpensesmatchedExpenses | ExpensesmatchedExpenses |
| ExpenseTemplates | ExpenseTemplates |
| ExpenseTemplatesexpenseTypes | ExpenseTemplatesexpenseTypes |
| ExpenseTemplatesexpenseTypesitemizedExpenseTypes | ExpenseTemplatesexpenseTypesitemizedExpenseTypes |
| ExpenseTemplatesexpenseTypespreferredAgencyLists | ExpenseTemplatesexpenseTypespreferredAgencyLists |
| ExpenseTemplatesexpenseTypespreferredMerchantLists | ExpenseTemplatesexpenseTypespreferredMerchantLists |
| ExpenseTemplatesmobileExpenseTypes | ExpenseTemplatesmobileExpenseTypes |
| ExpenseTypes | ExpenseTypes |
| ExpenseTypesitemizedExpenseTypes | ExpenseTypesitemizedExpenseTypes |
| ExpenseTypespreferredAgencyLists | ExpenseTypespreferredAgencyLists |
| ExpenseTypespreferredMerchantLists | ExpenseTypespreferredMerchantLists |
| ExternalBankAccounts | ExternalBankAccounts |
| ExternalBankAccountsaccountOwners | ExternalBankAccountsaccountOwners |
| FinBusinessUnitsLOV | FinBusinessUnitsLOV |
| InstrumentAssignments | InstrumentAssignments |
| IntercompanyOrganizationsLOV | IntercompanyOrganizationsLOV |
| IntercompanyTransactionTypesLOV | IntercompanyTransactionTypesLOV |
| InterimDocumentsPayables | InterimDocumentsPayables |
| Invoices | Invoices |
| InvoicesappliedPrepayments | InvoicesappliedPrepayments |
| Invoicesattachments | Invoicesattachments |
| InvoicesavailablePrepayments | InvoicesavailablePrepayments |
| InvoicesinvoiceDff | InvoicesinvoiceDff |
| InvoicesinvoiceGdf | InvoicesinvoiceGdf |
| InvoicesinvoiceInstallments | InvoicesinvoiceInstallments |
| InvoicesinvoiceInstallmentsinvoiceInstallmentDff | InvoicesinvoiceInstallmentsinvoiceInstallmentDff |
| InvoicesinvoiceInstallmentsinvoiceInstallmentGdf | InvoicesinvoiceInstallmentsinvoiceInstallmentGdf |
| InvoicesinvoiceLines | InvoicesinvoiceLines |
| InvoicesinvoiceLinesinvoiceDistributions | InvoicesinvoiceLinesinvoiceDistributions |
| InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionDff | InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionDff |
| InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionGdf | InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionGdf |
| InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionProjectDff | InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionProjectDff |
| InvoicesinvoiceLinesinvoiceLineDff | InvoicesinvoiceLinesinvoiceLineDff |
| InvoicesinvoiceLinesinvoiceLineGdf | InvoicesinvoiceLinesinvoiceLineGdf |
| InvoicesinvoiceLinesinvoiceLineProjectDff | InvoicesinvoiceLinesinvoiceLineProjectDff |
| LedgersLOV | LedgersLOV |
| LegalEntitiesLOV | LegalEntitiesLOV |
| LegalJurisdictionsLOV | LegalJurisdictionsLOV |
| LegalReportingUnitsLOV | LegalReportingUnitsLOV |
| PayablesOptions | PayablesOptions |
| PayablesPaymentTerms | PayablesPaymentTerms |
| PayablesPaymentTermspayablesPaymentTermsLines | PayablesPaymentTermspayablesPaymentTermsLines |
| PayablesPaymentTermspayablesPaymentTermsSets | PayablesPaymentTermspayablesPaymentTermsSets |
| PayablesPaymentTermspayablesPaymentTermsTranslations | PayablesPaymentTermspayablesPaymentTermsTranslations |
| PayeeBankAccountsLOV | PayeeBankAccountsLOV |
| PaymentsExternalPayees | PaymentsExternalPayees |
| PaymentsExternalPayeesexternalPartyPaymentMethods | PaymentsExternalPayeesexternalPartyPaymentMethods |
| PreferredCurrenciesLOV | PreferredCurrenciesLOV |
| ReceivablesBusinessUnitsLOV | ReceivablesBusinessUnitsLOV |
| ReceivablesCreditMemos | ReceivablesCreditMemos |
| ReceivablesCreditMemosattachments | ReceivablesCreditMemosattachments |
| ReceivablesCreditMemosnotes | ReceivablesCreditMemosnotes |
| ReceivablesCreditMemosreceivablesCreditMemoDFF | ReceivablesCreditMemosreceivablesCreditMemoDFF |
| ReceivablesCreditMemosreceivablesCreditMemoDistributions | ReceivablesCreditMemosreceivablesCreditMemoDistributions |
| ReceivablesCreditMemosreceivablesCreditMemoDistributionsreceivablesCreditMemoDistributionDFF | ReceivablesCreditMemosreceivablesCreditMemoDistributionsreceivablesCreditMemoDistributionDFF |
| ReceivablesCreditMemosreceivablesCreditMemoGdf | ReceivablesCreditMemosreceivablesCreditMemoGdf |
| ReceivablesCreditMemosreceivablesCreditMemoLines | ReceivablesCreditMemosreceivablesCreditMemoLines |
| ReceivablesCreditMemosreceivablesCreditMemoLinesattachments | ReceivablesCreditMemosreceivablesCreditMemoLinesattachments |
| ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineDFF | ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineDFF |
| ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineGdf | ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineGdf |
| ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineTaxLines | ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineTaxLines |
| ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineTransactionDFF | ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineTransactionDFF |
| ReceivablesCreditMemosreceivablesCreditMemoTransactionDFF | ReceivablesCreditMemosreceivablesCreditMemoTransactionDFF |
| ReceivablesInvoices | ReceivablesInvoices |
| ReceivablesInvoicesattachments | ReceivablesInvoicesattachments |
| ReceivablesInvoicesnotes | ReceivablesInvoicesnotes |
| ReceivablesInvoicesreceivablesInvoiceDFF | ReceivablesInvoicesreceivablesInvoiceDFF |
| ReceivablesInvoicesreceivablesInvoiceDistributions | ReceivablesInvoicesreceivablesInvoiceDistributions |
| ReceivablesInvoicesreceivablesInvoiceDistributionsreceivablesInvoiceDistributionDFF | ReceivablesInvoicesreceivablesInvoiceDistributionsreceivablesInvoiceDistributionDFF |
| ReceivablesInvoicesreceivablesInvoiceGdf | ReceivablesInvoicesreceivablesInvoiceGdf |
| ReceivablesInvoicesreceivablesInvoiceInstallments | ReceivablesInvoicesreceivablesInvoiceInstallments |
| ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentGDF | ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentGDF |
| ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes | ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes |
| ReceivablesInvoicesreceivablesInvoiceLines | ReceivablesInvoicesreceivablesInvoiceLines |
| ReceivablesInvoicesreceivablesInvoiceLinesattachments | ReceivablesInvoicesreceivablesInvoiceLinesattachments |
| ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineDFF | ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineDFF |
| ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineGdf | ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineGdf |
| ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTaxLines | ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTaxLines |
| ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTransactionDFF | ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTransactionDFF |
| ReceivablesInvoicesreceivablesInvoiceTransactionDFF | ReceivablesInvoicesreceivablesInvoiceTransactionDFF |
| TaxClassifications | TaxClassifications |
| TransactionTaxLines | TransactionTaxLines |
| WithholdingTaxLines | WithholdingTaxLines |
| WorkflowUsers | WorkflowUsers |