CE Views (215)

CE - Cash Management — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

View	Description
`CEBV_BANK_ACCOUNTS`	Business view
`CEBV_BANK_BRANCHES`	Business view
`CEBV_BANK_STATEMENTS`	Business View
`CEBV_BANK_STATEMENT_LINES`	Business View
`CEBV_BSRE`	Business View
`CEBV_CASH_FORECASTS`	Business View
`CEBV_CASH_FORECAST_CELLS`	Business View
`CEBV_ECT`	Business View
`CEBV_STMTRECON`	Business View
`CEFV_BANK_ACCOUNTS`	Business view
`CEFV_BANK_BRANCHES`	Business view
`CEFV_BANK_STATEMENTS`	Business View
`CEFV_BANK_STATEMENT_LINES`	Business View
`CEFV_BSRE`	Business View
`CEFV_CASH_FORECASTS`	Business View
`CEFV_CASH_FORECAST_CELLS`	Business View
`CEFV_ECT`	Business View
`CEFV_STMTRECON`	Business View
`CE_101_RECONCILED_V`	Reconciled GL journals for unreconciling
`CE_101_TRANSACTIONS_V`	Available GL journals for reconciliation
`CE_185_RECONCILED_V`	Reconciled Treasury transactions for unreconciling via Open Interface
`CE_185_TRANSACTIONS_V`	Available Treasury transactions for reconciliation via Open Interface
`CE_200_BATCHES_V`	Available AP payment batches for reconciliation
`CE_200_GROUPS_V`	Available AP/IBY payment Groups for reconciliation
`CE_200_RECONCILED_V`	Reconciled AP payments for unreconciling
`CE_200_REVERSAL_V`	AP transactions for unclearing
`CE_200_TRANSACTIONS_V`	Available AP payments for reconciliation or clearing
`CE_222_BATCHES_V`	Available AR remittance batches for reconciliation
`CE_222_RECONCILED_V`	Reconciled AR receipts for unreconciling
`CE_222_REVERSAL_V`	AR receipts for reversing or unclearing
`CE_222_TRANSACTIONS_V`	Available AR receipts for reconciliation or clearing
`CE_222_TXN_FOR_BATCH_V`	Available Remittance Batches for Reconciliation or Clearing.
`CE_260_CF_RECONCILED_V`	Reconciled cashflow receipts and payments for unreconciling
`CE_260_CF_REVERSAL_V`	AR receipts for reversing or unclearing
`CE_260_CF_TRANSACTIONS_V`	Available cashflow payments/receipts for reconciliation or clearing
`CE_260_RECONCILED_V`	Reconciled statement lines for unreconciling
`CE_260_TRANSACTIONS_V`	Available statement lines for reconciliation
`CE_801_EFT_RECONCILED_V`	Reconciled Payroll payments for unreconciling
`CE_801_EFT_TRANSACTIONS_V`
`CE_801_RECONCILED_V`	Reconciled Payroll payments for unreconciling
`CE_801_TRANSACTIONS_V`	Available Payroll payments for reconciliation
`CE_999_INTERFACE_V`	Open interface view for reconciliation
`CE_999_RECONCILED_V`	Reconciled transactions for unreconciling via Open Interface
`CE_999_REVERSAL_V`	Open interface transactions for unclearing
`CE_999_TRANSACTIONS_V`	Available transactions for reconciliation via Open Interface
`CE_ALL_STATEMENTS_V`
`CE_AP_FC_DISC_INVOICES_V`	Forecasting source - AP invoices with discounts
`CE_AP_FC_DUE_INVOICES_V`	Forecasting source - AP invoices based on due dates
`CE_AP_FC_EXP_REPORTS_V`	Forecasting source - AP Expense Reports
`CE_AP_FC_PAYMENTS_V`	Forecasting source - AP payments
`CE_ARCH_HEADERS`
`CE_ARCH_INTERFACE_HEADERS`	(SINGLE-ORG view)
`CE_ARCH_INTRA_HEADERS`	Base view for CE_ARCH_INTRA_HEADERS_ALL.
`CE_ARCH_RECONCILIATIONS`	(SINGLE-ORG view)
`CE_AR_FC_INVOICES_V`	Forecasting source - AR invoices
`CE_AR_FC_RECEIPTS_V`	Forecasting source - AR receipts
`CE_AS_FC_SALES_FCST_V`	Forecasting source - Oracle Sales
`CE_AVAILABLE_BATCHES_V`	Available batches for reconciliation
`CE_AVAILABLE_TRANSACTIONS_V`	Available transactions for reconciliation
`CE_AVAIL_STATEMENTS_V`
`CE_BANKS_MERGE_V`	Banks
`CE_BANKS_V`	Banks
`CE_BANK_ACCOUNTS_V`	This view stores bank account information.
`CE_BANK_ACCTS_CALC_V`
`CE_BANK_ACCTS_GT_V`
`CE_BANK_ACCTS_SEARCH_GT_V`
`CE_BANK_ACCT_USES`
`CE_BANK_ACCT_USES_BG_V`	This view stores bank account uses information for business groups.
`CE_BANK_ACCT_USES_GT_V`
`CE_BANK_ACCT_USES_LE_V`	This view stores bank account uses information for legal entities.
`CE_BANK_ACCT_USES_OU_V`	This view stores bank account uses information for operating units.
`CE_BANK_BRANCHES_MERGE_V`	Bank branches
`CE_BANK_BRANCHES_V`	This view stores bank branch information.
`CE_BANK_STMT_INT_MAP_V`
`CE_BANK_STMT_MAP_HDR_V`
`CE_BANK_STMT_MAP_LINE_V`
`CE_BANK_TRX_CODES_V`	- Retrofitted
`CE_BA_SIGNATORIES_V`	A supplementary view used to simplify forms coding. Used by Bank Account Signatory form
`CE_CE_CASHFLOWS_V`
`CE_CP_APP_V`	Cash Positioning source for Discoverer - AP Payments
`CE_CP_ARR_V`	Cash Positioning source for Discoverer - AR Receipts
`CE_CP_BANK_ACCOUNTS_V`	Bank accounts for non-treasury users
`CE_CP_DISC_APP_V`	Cash Positioning Discoverer View for AP Payments
`CE_CP_DISC_ARR_V`	Cash Positioning Discoverer View for AR Receipts
`CE_CP_DISC_CEI_V`	Cash Positioning Discoverer View for Cash management infows
`CE_CP_DISC_CEO_V`	Cash Positioning Discoverer View for Cash management outflows
`CE_CP_DISC_CLOSE_V`	No longer Used
`CE_CP_DISC_IDA_V`	Cash Positioning Discoverer View for Intra-day Activities
`CE_CP_DISC_NET_V`	No longer Used
`CE_CP_DISC_OPEN_V`	Cash Positioning Discoverer View for Opening Balances
`CE_CP_DISC_OVERDUE_V`	Cash Positioning Discoverer View for Overdue Transactions
`CE_CP_DISC_PAY_V`	Cash Positioning Discoverer View for Payroll Expenses
`CE_CP_DISC_PRIOR_V`	Cash Positioning Discoverer View for Prior-day Balances
`CE_CP_DISC_SURPLUS_V`	No Longer Used
`CE_CP_DISC_TARGET_V`	Cash Positioning Discoverer View for Target Balances
`CE_CP_DISC_TRX_V`	Cash Positioning Discoverer View for All Transaction Sources
`CE_CP_DISC_V`	Cash Positioning Discoverer View
`CE_CP_DISC_XTI_V`	Cash Positioning Discoverer View for Treasury Inflow
`CE_CP_DISC_XTO_V`	Cash Positioning Discoverer View for Treasury Outflow
`CE_CP_OPEN_BAL_V`	This view shows the opening balances for bank accounts
`CE_CP_PAY_V`	Cash Positioning source for Discoverer - Payroll
`CE_CP_SUB_OPEN_BAL_V`	Opening balances for Treasury subsidiary bank accounts
`CE_CP_WS_BA_DISC_V`
`CE_CP_WS_BA_V`	Bank account list based on Cash Position worksheets
`CE_CP_WS_LE_V`	Legal Entity list based on Cash Position worksheets
`CE_CP_XTI_V`	Cash Positioning source for Discoverer - Treasury Inflow
`CE_CP_XTO_V`	Cash Positioning source for Discoverer - Treasury Inflow
`CE_CP_XTR_BANK_ACCOUNTS_V`	Bank accounts for treasury users
`CE_DISC_INVOICES_V`	Cash forecasting source - AP invoices based on discounts
`CE_DISC_PROJECT_INV_V`	Cash forecasting source - AP invoices based on discounts and projects
`CE_DOCUMENTS_PAYABLE`
`CE_DUE_PROJECT_INV_V`	Forecasting source - AP invoices based on due dates and projects
`CE_FC_AGING_BUCKETS_V`
`CE_FC_AMTS_BANK_V`	This is a new view created to group forecast results by bank account
`CE_FC_AMTS_DISC_V`
`CE_FC_AMTS_GLCP_V`	This is a new view created to group forecast results by GL cash account
`CE_FC_AMTS_SRC_BANK_V`	This is a new view created to group forecast results for a particular bank account by transaction source type
`CE_FC_AMTS_SRC_GLCP_V`	This is a new view created to group forecast results for a particular GL cash account by transaction source type
`CE_FC_AMTS_SRC_V`	This is a new view created to group forecast results by transaction source type
`CE_FC_API_DISC_V`
`CE_FC_APP_DISC_V`
`CE_FC_APX_DISC_V`
`CE_FC_ARI_DISC_V`
`CE_FC_ARR_DISC_V`
`CE_FC_ASF_DISC_V`
`CE_FC_BANK_NETFLOW_V`	This is a new view created to track the cash inflow per forecast period by bank account
`CE_FC_GLCP_NETFLOW_V`	This is a new view created to track the cash inflow per forecast period by GL cash account
`CE_FC_MANUAL_AMTS_SRC_V`
`CE_FC_NETFLOW_DISC_V`
`CE_FC_OEO_DISC_V`
`CE_FC_PAB_DISC_V`
`CE_FC_PAIO_DISC_V`
`CE_FC_PAT_DISC_V`
`CE_FC_PAY_DISC_V`
`CE_FC_POP_DISC_V`
`CE_FC_POR_DISC_V`
`CE_FC_RX_COLUMN_TITLE_V`	- Retrofitted
`CE_FC_RX_TITLE1_V`	- Retrofitted
`CE_FC_RX_TITLE2_V`	- Retrofitted
`CE_FC_RX_TITLE3_V`	- Retrofitted
`CE_FC_RX_TITLE4_V`	- Retrofitted
`CE_FC_RX_TITLE5_V`	- Retrofitted
`CE_FC_RX_TITLE6_V`	- Retrofitted
`CE_FC_RX_TITLE7_V`	- Retrofitted
`CE_FC_RX_V`	- Retrofitted
`CE_FC_XTR_DISC_V`
`CE_FORECASTS_V`	- Retrofitted
`CE_FORECAST_AP_ORGS_V`	- Retrofitted
`CE_FORECAST_AR_ORGS_V`	- Retrofitted
`CE_FORECAST_AS_ORGS_V`	- Retrofitted
`CE_FORECAST_COLUMNS_V`	- Retrofitted
`CE_FORECAST_ERRORS_V`	- Retrofitted
`CE_FORECAST_EXT_VIEWS_V`	- Retrofitted
`CE_FORECAST_HEADERS_V`	- Retrofitted
`CE_FORECAST_LINES_AMT_V`	- Retrofitted
`CE_FORECAST_LINES_CELLID_V`	- Retrofitted
`CE_FORECAST_LINES_V`	- Retrofitted
`CE_FORECAST_OE_ORGS_V`	- Retrofitted
`CE_FORECAST_ORGS_V`	- Retrofitted
`CE_FORECAST_PAY_ORGS_V`	- Retrofitted
`CE_FORECAST_PA_ORGS_V`	- Retrofitted
`CE_FORECAST_PO_ORGS_V`	- Retrofitted
`CE_FORECAST_ROWS_V`	- Retrofitted
`CE_HR_BUS_GRPS_V`	- Retrofitted
`CE_INTEREST_RATES_V`
`CE_INTERNAL_BANK_ACCOUNTS_V`	- Retrofitted
`CE_INTERNAL_BANK_ACCTS_GT_V`
`CE_INTERNAL_BANK_ACCTS_V`	Public view that shows all internal bank accounts including netting bank accounts.
`CE_INTRA_STMT_HDRS_LINES_V`	The CE_INTRA_STMT_HDRS_LINES_V view contains intra-day bank statement headers and lines information. This view is used in cash positioning.
`CE_INTRA_STMT_HEADERS`	Base view for CE_INTRA_STMT_HEADERS_ALL.
`CE_JE_MAPPINGS_V`	View on CE_JE_MAPPINGS to simply Forms coding
`CE_LE_BG_OU_VS_V`	This view stores organization access information.
`CE_LOOKUPS`	Lookup codes
`CE_MISC_TAX_CODE_V`	- Retrofitted
`CE_MISC_TRANSACTIONS_V`	- Retrofitted
`CE_PAY_FC_PAYROLL_V`	Forecasting source - payroll expenses
`CE_PO_FC_NO_TERMS_TEMP_V`	Forecasting source - temp labor purchase orders with no terms
`CE_PO_FC_ORDERS_NO_TERMS_V`	Forecasting source - goods and services purchase orders with no terms
`CE_PO_FC_ORDERS_TEMP_V`	Forecasting source - temp labor purchase orders
`CE_PO_FC_ORDERS_TERMS_TEMP_V`	Forecasting source - temp labor purchase orders with terms
`CE_PO_FC_ORDERS_TERMS_V`	Forecasting source - goods and services purchase orders with terms
`CE_PO_FC_ORDERS_V`	Forecasting source - goods and services purchase orders
`CE_PO_FC_REQUISITIONS_TEMP_V`	Forecasting source - temp labor PO requisitions
`CE_PO_FC_REQUISITIONS_V`	Forecasting source - goods and services PO requisitions
`CE_P_BA_SIGNATORY_HIST_V`	Public view to show consolidated information of the bank account signatory's history for audit purposes
`CE_RECEIPT_METHODS_V`	Payment Methods available in CE
`CE_RECEIVABLE_ACTIVITIES_V`	- Retrofitted
`CE_RECONCILED_TRANSACTIONS_V`	Reconciled transactions
`CE_RECONCILIATION_ERRORS_V`	Reconciliation errors
`CE_REVERSAL_AR_TRX_V`
`CE_REVERSAL_TRANSACTIONS_V`	Available transactions for reversal or unclearing
`CE_RX_AGING_BUCKETS_V`	- Retrofitted
`CE_SECURITY_PROFILES_V`	This view stores organization security access information.
`CE_SO_FC_ORDERS_NO_TERMS_V`	Forecasting source - sales orders
`CE_SO_FC_ORDERS_TERMS_V`	Forecasting source - sales orders.
`CE_SO_FC_ORDERS_V`	Forecasting source - sales orders. This view retrieves sales orders for forecasting when the option of including payment terms in the foreca
`CE_STATEMENT_BANKS_V`
`CE_STATEMENT_HEADERS`
`CE_STATEMENT_HEADERS_INTERFACE`
`CE_STATEMENT_HEADERS_V`	- Retrofitted
`CE_STATEMENT_LINES_V`	- Retrofitted
`CE_STATEMENT_NUMBERS_V`
`CE_STATEMENT_RECONCILIATIONS`
`CE_STATEMENT_RECON_GT_V`
`CE_STAT_HDRS_INF_V`	- Retrofitted
`CE_STAT_LINES_INF_V`	- Retrofitted
`CE_SYSTEM_PARAMETERS`
`CE_SYSTEM_PARAMETERS_MRC_V`	- Retrofitted
`CE_SYSTEM_PARAMETERS_V`	- Retrofitted
`CE_TRANSACTION_CODES_V`	- Retrofitted
`CE_UPGA_BA_USES`	This view is a single org view of the CE_UPGA_BA_USES_ALL table
`CE_UPG_BA_USES`	This view is a single org view of the CE_UPG_BA_USES_ALL table
`CE_XLA_EXT_HEADERS_V`
`CE_XLA_TRANSACTIONS_V`	This view retrieves Subledger Accounting transaction information.
`CE_XTR_CASHFLOWS_V`	Forecasting source - treasury