AR Views (700)

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

ViewDescription
AP_PAYMENT_SCHEDULES_V
ARBR_DOCS_RECEIVABLES_V Creation of ARBR_DOCS_RECEIVABLES_V view this is view is required for payment settlemnt
ARBR_DOCUMENT_LINES_V Creation of ARBR_DOCUMENT_LINES_V view this is view is required for payment settlemnt
ARBR_FUNDS_CAPTURE_ORDERS_V Creation of ARBR_FUNDS_CAPTURE_ORDERS_V view this is view is required for payment settlemnt
ARBV_ADJUSTMENT_DISTRIBUTIONS
ARBV_ADJ_DISTS_ALT_CRNCY - Retrofitted
ARBV_APPLICATION_DISTRIBUTIONS
ARBV_APP_DISTS_ALT_CRNCY - Retrofitted
ARBV_AR_CUSTOMER_TRANS_LINES
ARBV_AR_PAYMENT_SCHEDULES -Retrofitted
ARBV_AR_TAX_CODES - Retrofitted
ARBV_AR_TAX_GROUPS - Retrofitted
ARBV_AR_TRANSACTIONS This shows information about transactions imported from a foreign system into Oracle Receivables.
ARBV_AR_TRANSACTIONS_OLD1 - Retrofitted
ARBV_CASH_APPLICATIONS This shows information about cash applied to customer transactions.
ARBV_CASH_DISTRIBUTIONS
ARBV_CASH_DISTS_ALT_CRNCY - Retrofitted
ARBV_CASH_RECEIPTS This shows information about receipts remitted by the customer as payment for goods or services.
ARBV_COLLECTION_CALLS This shows information about telephone calls made to a customer regarding outstanding account balances.
ARBV_CREDITS
ARBV_CREDIT_MEMO_APPLICATIONS
ARBV_CREDIT_MEMO_ARS This shows information about credit memos. Credit memos are documents that partially or fully reverse an original invoice.
ARBV_CUSTOMERS
ARBV_CUSTOMER_SITES
ARBV_DEBITS This shows information about items that increase your customer's receivable balance. Debit items remain open until the balance due is zero.
ARBV_FREIGHT_CHARGES - Retrofitted
ARBV_FREIGHT_DISTRIBUTIONS - Retrofitted
ARBV_FREIGHT_DISTS_ALT_CRNCY - Retrofitted
ARBV_INVOICE_ADJUSTMENTS - Retrofitted
ARBV_INVOICE_ARS - Retrofitted
ARBV_LOCATIONS
ARBV_NON_REVENUE_CREDITS - Retrofitted
ARBV_ON_ACCOUNT_CREDIT_MEMOS This shows information about credits that you assign to your customer's account that are not related to a specific invoice.
ARBV_RECEIPT_HISTORIES - Retrofitted
ARBV_RECEIPT_HISTORY
ARBV_REVENUES - Retrofitted
ARBV_REVENUE_CREDITS This shows revenue credit information for a transaction.
ARBV_REVENUE_DISTRIBUTIONS This shows information about revenue amounts posted to the General Ledger.
ARBV_REVENUE_DISTS_ALT_CRNCY - Retrofitted
ARBV_SALES_CREDITS This shows sales credit information for a transaction.
ARBV_TAXES This shows detailed tax information associated with transaction line items.
ARBV_TAX_DISTRIBUTIONS - Retrofitted
ARBV_TAX_DISTS_ALT_CRNCY - Retrofitted
ARBV_TRANSACTION_DISTRIBUTIONS This shows information about transactions posted to the General Ledger.
ARBV_TRANSACTION_DISTRIBU_OLD1 - Retrofitted
ARBV_UNREC_DISTRIBUTIONS - Retrofitted
ARBV_UNREC_DISTRIBUTIONS_OLD1 - Retrofitted
ARBV_UNREC_DISTS_ALT_CRNCY - Retrofitted
ARBV_UNREV_DISTRIBUTIONS - Retrofitted
ARBV_UNREV_DISTRIBUTIONS_OLD1 - Retrofitted
ARBV_UNREV_DISTS_ALT_CRNCY - Retrofitted
ARFV_ADJUSTMENT_DISTRIBUTIONS This shows information about adjustment amounts posted to the General Ledger.
ARFV_ADJUSTMENT_DISTRIBUT_OLD1 - Retrofitted
ARFV_ADJ_DISTS_ALC_V This shows Alternate Currencies information about adjustment amounts transferred to the Subledger Accounting.
ARFV_ADJ_DISTS_ALT_CRNCY
ARFV_APPLICATION_DISTRIBUTIONS This shows information about cash receipt applications posted to the General Ledger.
ARFV_APPLICATION_DISTRIBU_OLD1 - Retrofitted
ARFV_APP_DISTS_ALC_V This shows Alternate Currencies information about cash receipt applications transferred to the Subledger Accounting.
ARFV_APP_DISTS_ALT_CRNCY - Retrofitted
ARFV_AR_CUSTOMER_TRANS_LINES
ARFV_AR_PAYMENT_SCHEDULES This shows information about entries against accounts receivable transactions ( both debits and credits ), except adjustments and miscellane
ARFV_AR_PAYMENT_SCHEDULES_OLD1 - Retrofitted
ARFV_AR_TAX_CODES - Retrofitted
ARFV_AR_TAX_GROUPS - Retrofitted
ARFV_AR_TERMS Stores information about the specific payment conditions applicable to the customer for the sale of goods or services.
ARFV_AR_TERMS_OLD1 - Retrofitted
ARFV_AR_TRANSACTIONS This shows information about transactions imported from a foreign system into Oracle Receivables.
ARFV_CASH_APPLICATIONS - Retrofitted
ARFV_CASH_APPLICATIONS_OLD1 - Retrofitted
ARFV_CASH_DISTRIBUTIONS
ARFV_CASH_DISTS_ALC_V This shows Alternate Currencies information about cash amounts transferred to the Subledger Accounting.
ARFV_CASH_DISTS_ALT_CRNCY - Retrofitted
ARFV_CASH_RECEIPTS This shows information about payments remitted by the customer as payment for goods or services.
ARFV_COLLECTION_CALLS
ARFV_CREDITS This shows information about any item that you can apply to an open debit item to reduce the balance due for a customer. Credit items remai
ARFV_CREDITS_OLD1 - Retrofitted
ARFV_CREDIT_MEMO_APPLICATIONS
ARFV_CREDIT_MEMO_ARS This shows information about documents that partially or fully reduce the original balance due for an invoice.
ARFV_CUSTOMERS This shows basic information about any organization or individual who purchases goods or services.
ARFV_CUSTOMER_SITES
ARFV_DEBITS This shows information relating to items that increase your customer's receivable balance. Debit items remain open until the balance due is
ARFV_FREIGHT_CHARGES
ARFV_FREIGHT_DISTRIBUTIONS - Retrofitted
ARFV_FREIGHT_DISTRIBUTION_OLD1 - Retrofitted
ARFV_FREIGHT_DISTS_ALC_V This shows Alternate Currencies information about freight amounts transferred to the Subledger Accounting.
ARFV_FREIGHT_DISTS_ALT_CRNCY - Retrofitted
ARFV_INVOICE_ADJUSTMENTS
ARFV_INVOICE_ARS This shows information about an invoice. An invoice is a document that lists amounts owed for the purchase of goods or services.
ARFV_LOCATIONS
ARFV_NON_REVENUE_CREDITS
ARFV_ON_ACCOUNT_CREDIT_MEMOS This shows information about credits that you assign to your customers account that are not related to a specific invoice.
ARFV_ON_ACCOUNT_CREDIT__OLD1 - Retrofitted
ARFV_RECEIPT_HISTORIES
ARFV_RECEIPT_HISTORY
ARFV_REVENUES This shows detailed information about the revenue associated with transaction line items.
ARFV_REVENUE_CREDITS This shows revenue credit information for a transaction.
ARFV_REVENUE_DISTRIBUTIONS This shows information about revenue amounts posted to the General Ledger.
ARFV_REVENUE_DISTS_ALC_V This shows Alternate Currencies information about revenue amounts transferred to the Subledger Accounting.
ARFV_REVENUE_DISTS_ALT_CRNCY - Retrofitted
ARFV_SALES_CREDITS This shows sales credit information for a transaction.
ARFV_TAXES
ARFV_TAX_DISTRIBUTIONS This shows information about tax amounts posted to the General Ledger.
ARFV_TAX_DISTS_ALC_V This shows Alternate Currencies information about tax amounts transferred to the Subledger Accounting.
ARFV_TAX_DISTS_ALT_CRNCY - Retrofitted
ARFV_TRANSACTION_DISTRIBUTIONS
ARFV_UNREC_DISTRIBUTIONS
ARFV_UNREC_DISTS_ALC_V This shows Alternate Currencies information about unbilled receivables amounts transferred to the Subledger Accounting.
ARFV_UNREC_DISTS_ALT_CRNCY - Retrofitted
ARFV_UNREV_DISTRIBUTIONS
ARFV_UNREV_DISTS_ALC_V This shows Alternate Currencies information about unearned revenue amounts transferred to the Subledger Accounting.
ARFV_UNREV_DISTS_ALT_CRNCY - Retrofitted
ARI_CUSTOMER_SEARCH_V
AR_ACTIONS_V (Release 11.5 Only)
AR_ACTIVE_REMIT_TO_ADDRESSES_V (Release 11.5 Only)
AR_ADDRESSES_V This view is used in the customer form address block
AR_ADDR_CATEGORIES_ACTIVE_V Information about active address categories
AR_ADJUSTMENTS_ALL_MRC_V - Retrofitted
AR_ADJUSTMENTS_H_V
AR_ADJUSTMENTS_MRC_V - Retrofitted
AR_ADJUSTMENTS_V (Release 11.5 Only)
AR_ADJ_DIST_UPG_V AR XLA Extract
AR_ADJ_INF_V
AR_AEL_GL_ADJ_V
AR_AEL_GL_ADJ_V_OLD
AR_AEL_GL_INV_V
AR_AEL_GL_INV_V_OLD
AR_AEL_GL_REC_ALL_V
AR_AEL_GL_REC_CB_V
AR_AEL_GL_REC_V
AR_AEL_GL_REC_V_OLD
AR_AEL_SL_ADJ_MRC_V
AR_AEL_SL_ADJ_V
AR_AEL_SL_ADJ_V_OLD
AR_AEL_SL_CB_REC_V_OLD
AR_AEL_SL_INV_MRC_V
AR_AEL_SL_INV_V
AR_AEL_SL_INV_V_OLD
AR_AEL_SL_REC_MRC_V
AR_AEL_SL_REC_V
AR_AEL_SL_REC_V_OLD
AR_AGING_BUCKET_LINES_VL
AR_AGREEMENTS_S_V agreement shared extract
AR_AGREEMENTS_S_VL agreement shared mls extract
AR_AI_BATCH_SOURCE_V Selects batch sources based on the org returned from ar_ai_org_v. Each batch source (name) should appear on the list only once.
AR_AI_ORG_V Selects orgs from ar_system_parameters
AR_ALL_ENABLED_CURRENCIES_V (Release 10SC Only)
AR_APPROVAL_ACTION_HISTORY_V (Release 10SC Only)
AR_APP_ADJ_V (Release 11.5 Only)
AR_APP_DIST_UPG_V AR XLA extract
AR_AP_TAX_CODES_V
AR_AUTOMATIC_RECEIPTS_FORMAT_V Information about confirmed automatic receipts that are being formatted
AR_BATCHES_ALL_MRC_V
AR_BATCHES_MRC_V
AR_BATCHES_V
AR_BATCH_REMIT_V
AR_BILL_DRAWEE_ADDRESS_V
AR_BILL_TO_ADDRESSES_ACTIVE_V (Release 11.5 Only)
AR_BILL_TO_CUSTOMERS_S_V bill to customer shared extract
AR_BILL_TO_SITE_USES_S_V bill to customer site shared extract
AR_BOE_AUTO_RECEIPTS_V (Release 11.5 Only)
AR_BOE_REMIT_RECEIPTS_CBR_V (Release 11.5 Only)
AR_BOE_REMIT_RECEIPTS_CBUNR_V (Release 11.5 Only)
AR_BOE_REMIT_RECEIPTS_NONCBR_V (Release 11.5 Only)
AR_BOE_REMIT_RECEIPTS_V (Release 11.5 Only)
AR_BPA_CONTENT_AREAS_VL
AR_BPA_DATASRC_APPS_VL
AR_BPA_DATA_SOURCES_VL
AR_BPA_ITEMS_VL
AR_BPA_PAGE_SETUPS_VL
AR_BPA_RULES_VL
AR_BPA_RULE_ATTRIBUTES_VL
AR_BPA_TEMPLATES_VL
AR_BPA_URLS_VL
AR_BR_ACTIVITIES_V (Release 115 Only)
AR_BR_ASSIGNMENTS_V
AR_BR_BATCHES_V
AR_BR_HISTORY_V
AR_BR_MAIN_REMIT_BATCH_V
AR_CALL_ACTIONS_V (Release 10SC Only)
AR_CASH_AUTOMATCHES_VL View used to implement Automatch Cash Rule UI
AR_CASH_AUTO_RULE_SETS_VL View used to implement Automatch Cash Rule Set UI
AR_CASH_BASIS_DISTS_MRC_V
AR_CASH_RECEIPTS_ALL_MRC_V
AR_CASH_RECEIPTS_H_V
AR_CASH_RECEIPTS_L_V AR XLA Extract
AR_CASH_RECEIPTS_MRC_V
AR_CASH_RECEIPTS_S_V cash receipt shared extract
AR_CASH_RECEIPTS_V This is the base table view for the Receipts window.
AR_CASH_RECEIPT_HIST_ALL_MRC_V
AR_CASH_RECEIPT_HIST_MRC_V
AR_CASH_RECOS_PS View used to implement Recommendations UI
AR_CBA_BANK_ACCOUNT_CONTACTS_V (Release 11.6 Only)
AR_CBA_BANK_BRANCH_CONTACTS_V (Release 11.6 Only)
AR_CBA_EFT_USER_NUMBER_V (Release 11.6 Only)
AR_CC_ERRORS_V This view has been used in credit error card correction OA page.
AR_CC_ERROR_MAPPINGS_V This is the base table view for Credit Card Error mappings window.
AR_CHARGEBACKS_V (Release 10SC Only)
AR_CHARGE_SCHEDULE_HEADERS_V View for Charge Schedules
AR_CHARGE_SCHEDULE_LINES_V View for Charge Schedule lines
AR_CMGT_DATA_POINTS_VL
AR_CMGT_DNB_ELEMENTS_VL
AR_CMGT_PARTY_ACCOUNTS
AR_CMGT_SCORABLE_DATA_POINTS_V
AR_CM_ACTIVITIES_V
AR_CM_APP_DIST_LINES_L_V This view is used to fetch interface line attributes data for CM applications.
AR_CM_BATCHES_H_V AR XLA Extract
AR_CM_BATCHES_S_V credit memo batch source shared extract
AR_CM_BATCH_SRC_H_V AR XLA Extract
AR_CM_BATCH_SRC_S_V credit memo batch source header extract
AR_CM_BILL_SITE_USES_H_V AR XLA Extract
AR_CM_BILL_SITE_USES_S_V credit memo bill to site shared extract
AR_CM_BILL_TO_CUST_H_V AR XLA Extract
AR_CM_BILL_TO_CUST_S_V credit memo bill to customer shared extract
AR_CM_ETAX_ACCOUNTS_L_V Ebusiness tax sources to AR XLA uptake for Credit Memo
AR_CM_ETAX_L_VL Ebusiness tax sources to AR XLA uptake for Credit Memo languages sensitive sources
AR_CM_INVENTORY_L_V credit memo item line line extract
AR_CM_ITEM_CAT_L_VL credit memo item category line extract
AR_CM_LINES_BASE_V credit memo line base extract
AR_CM_LINES_L_V credit memo line extract
AR_CM_NET_DISTS_V Determine the amount to credit for a given invoice line
AR_CM_NET_REVENUE Determine the uncredited amount
AR_CM_NET_REVENUE_ASSIGNMENTS Determines the credit memo lines that credit a given invoice line
AR_CM_NET_REVENUE_FORM Determine the uncredited amount
AR_CM_NET_REV_ASSIGNMENTS_FRM Determine the credit memo lines that credit a given invoice line
AR_CM_NET_REV_DIST_FORM Determine the uncredited amount
AR_CM_PAY_CUST_H_V AR XLA Extract
AR_CM_PAY_CUST_S_V credit memo paying customer shared extract
AR_CM_PAY_SITE_USES_H_V AR XLA Extract
AR_CM_PAY_SITE_USES_S_V credit memo paying site shared extract
AR_CM_SALESREP_H_V AR XLA Extract
AR_CM_SALESREP_L_V credit memo salesrep line extract
AR_CM_SALESREP_S_V credit memo salesrep shared extract
AR_CM_SHIP_TO_CUST_H_V AR XLA Extract
AR_CM_SHIP_TO_CUST_S_V credit memo ship to customer shared extract
AR_CM_SHIP_TO_SITE_USES_H_V AR XLA Extract
AR_CM_SHIP_TO_SITE_USES_S_V credit memo ship to site shared extract
AR_CM_SOLD_SITE_USES_H_V AR XLA Extract
AR_CM_SOLD_SITE_USES_S_V credit memo sold to site shared extract
AR_CM_SOLD_TO_CUST_H_V AR XLA Extract
AR_CM_SOLD_TO_CUST_S_V credit memo sold to customer shared extract
AR_CM_UOM_L_VL credit memo unit of measure line extract
AR_CONS_BILL_CYCLES_VL
AR_CONS_INV_DRAFT_V
AR_CONS_INV_V
AR_CONTACTS_ACTIVE_V
AR_CONTACTS_V (Release 11.5 Only)
AR_CONTACT_ROLES_V (Release 11.5 Only)
AR_CORRECT_GL_ACCOUNTS_V
AR_CORRECT_GL_LINES_V
AR_CORRESPONDENCES_V (Release 11.5 Only)
AR_CREDIT_MEMO_H_V AR XLA Extract
AR_CREDIT_MEMO_S_V credit memo shared extract
AR_CR_INF_V
AR_CUSTOMERS (Release 11.5 Only)
AR_CUSTOMERS_ACTIVE_V (Release 11.5 Only)
AR_CUSTOMERS_ALL_V (Release 11.5 Only)
AR_CUSTOMERS_ASSIGNED_V
AR_CUSTOMERS_V
AR_CUSTOMER_ACCOUNTS (Release 11.5 Only)
AR_CUSTOMER_ACCOUNTS_CA (Release 11.5 Only)
AR_CUSTOMER_ACCOUNTS_CE (Release 11.5 Only)
AR_CUSTOMER_ACCOUNTS_LA (Release 11.5 Only)
AR_CUSTOMER_ACCOUNTS_LE (Release 11.5 Only)
AR_CUSTOMER_ALT_NAMES_V Alternate customer names for lockbox name matching
AR_CUSTOMER_BANK_ACCOUNTS_V (Release 10SC Only)
AR_CUSTOMER_BILLS_TRX_V
AR_CUSTOMER_CALLS_V (Release 11.5 Only)
AR_CUSTOMER_CALL_TOPICS_V (Release 10SC Only)
AR_CUSTOMER_CLASSES_ACTIVE_V (Release 10SC Only)
AR_CUSTOMER_CONTACT_FIND_V
AR_CUSTOMER_FIND_V
AR_CUSTOMER_PAYMENT_SCHEDULES Facilitate queries on sums across customers" invoices
AR_CUSTOMER_PROFILES_V (Release 11.5 Only)
AR_CUSTOMER_PROFILE_CLASSES_V (Release 12.0 Only)
AR_CUSTOMER_RELATIONSHIPS_V (Release 11.5 Only)
AR_CUSTOMER_SEARCH_V
AR_CUSTOMER_VENDOR_NIF_V Customer and Vendor NIF codes
AR_CUSTOMER_VENDOR_V Customer and Vendor Names
AR_CUSTOMER_VENDOR_VAT_V Customer and Vendor VAT/Tax Codes
AR_CUST_CALLS_V (Release 11.5 Only)
AR_CUST_CATEGORIES_ACTIVE_V (Release 10SC Only)
AR_CUST_PROF_CLASS_AMTS View for profile class amounts
AR_CUST_RECEIPT_METHODS_V (Release 10SC Only)
AR_CUST_TRX_LINES_BASE_V transaction line base extract
AR_CUST_TRX_LINES_L_V transaction line extract
AR_DED_CHARGEBACKS_V
AR_DEFAULT_TAX_CODE_V View used to implement defaults of Tax Codes from within Order Entry
AR_DISPUTE_HISTORY_V (Release 115 Only)
AR_DISTRIBUTIONS_ALL_MRC_V Accounting records for receipts in multiple reporting currencies
AR_DISTRIBUTIONS_BASE_V distribution base extract
AR_DISTRIBUTIONS_L_V distribution line extract
AR_DISTRIBUTIONS_MRC_V Accounting records for receipts in multiple reporting currencies
AR_DISTRIBUTION_SETS_H_V distribution set header extract
AR_DMS_TO_TA_REQUEST_ID_V
AR_DOCS_RECEIVABLES_V
AR_DOCUMENT_LINES_V
AR_DOCUMENT_TRANSFERS_V
AR_DRAWEE_BANK_ACCOUNTS_H_V drawee bank account header extract
AR_DRAWEE_CUSTOMERS_H_V drawee customer header extract
AR_DRAWEE_SITE_USES_H_V drawee customer site header extract
AR_DUNNING_HISTORY_V View dunning history information
AR_DUNNING_LETTERS_CUSTOM_VL
AR_DUNNING_LETTERS_VL
AR_ETAX_ACCOUNTS_L_V Ebusiness tax sources to AR XLA uptake for invoice and its applications
AR_ETAX_L_VL Ebusiness tax sources to AR XLA uptake for invoice and its applications languages sensitive sources
AR_FEDERAL_CODE_ASSIG_V View used in Customer From for 1099 assignemnt
AR_FUNDS_CAPTURE_ORDERS_V
AR_GL_SEGMENTS_REF_V This is a reference view to return Balancing segment and Natural Account sources
AR_GTA_GT_HEADERS_V Header level information for gta invoice
AR_GTA_GT_LINES_V Detail information for GTA invoice and VAT invoice
AR_GTA_TRX_HEADERS_V Header level information for gta invoice
AR_GTA_TRX_LINES_V Detail information for GTA invoice and VAT invoice
AR_HCUSTOMER_PROFILES Customer credit information
AR_HCUSTOMER_PROFILE_AMOUNTS Customer profile amount limits for each currency
AR_HCUSTOMER_PROFILE_CLASSES Customer profile class information
AR_HCUST_PROF_CLASS_AMOUNTS Customer profile class amount limits for each currency
AR_ICR_LINES_TRX_V (Release 115 Only)
AR_ICR_TRX_V (Release 115 Only)
AR_IDEP_ACTIONS_NOT_TAKEN
AR_IDEP_ACTIONS_TAKEN
AR_IDEP_COMMITMENT_USAGE
AR_INTEREST_BATCHES_V Late Charge batch preview work bench
AR_INTEREST_HEADERS_V Late Charge header preview work bench
AR_INTEREST_LINES_V Late Charge line preview work bench
AR_INTERIM_CASH_RECEIPTS_V (Release 115 Only)
AR_INTERIM_CR_LINES_V (Release 115 Only)
AR_INVENTORY_L_V inventory item line extract
AR_INVOICE_COMMITMENT_INFO_V Collects information about commitments
AR_INVOICE_COUNT_TERMS_V Collects the number of payment dates defined for a transaction
AR_INVOICE_HEADER_V Collects invoice header-level information
AR_INVOICE_INSTALLMENTS_V Collects invoice installment information
AR_INVOICE_LINES_V Collects invoice line item information
AR_INVOICE_TAX_SUMMARY_V Collects tax information for transactions
AR_INVOICE_TOTALS_V Collects the total amount of charges for a transaction
AR_INV_ACT_V (Release 11.5 Only)
AR_ITEM_CAT_L_VL inventory item category line extract
AR_LEDGER_H_V ledger extract
AR_LINE_CONTINGENCIES_V Holds contingency information for a deferred billing line.
AR_LINE_DEFERRAL_REASONS_V (Release 12 Only )
AR_LINE_EXCEPTIONS_V Holds contingency information for a deferred billing line whose revenue has been adjusted.
AR_LINE_FREIGHT_V (Release 10SC Only)
AR_LINE_REVENUE_DETAILS_V
AR_LL_FREIGHT_CHARGES_V The AR_LL_LINES_GROUPS_V view is used by the Line-Level Cash Application form
AR_LL_LINES_GROUPS_V Lines and Groups for Line-Level Cash Application
AR_LL_SUMMARY_V Summary for Line-Level Cash Application
AR_LOCATION_VALUES_V
AR_LOCVS_LOV_V (Release 10SC Only)
AR_LOC_FOUR_LEVEL_V (Release 10SC Only)
AR_LOC_ONE_LEVEL_V (Release 10SC Only)
AR_LOC_THREE_LEVEL_V (Release 10SC Only)
AR_LOC_TWO_LEVEL_V (Release 10SC Only)
AR_LOOKUPS Release 11.5
AR_LOOKUP_TYPES AR_LOOKUP_TYPES stores standard lookup types for Quickcodes
AR_MASS_APPLICATIONS_V
AR_MEMO_LINES_ALL_VL
AR_MEMO_LINES_VL
AR_MERGE_ADDRESSES_V
AR_MISC_CASH_DISTRIBUTIONS_V (Release 115 Only)
AR_MISC_CASH_DISTS_ALL_MRC_V
AR_MISC_CASH_DISTS_MRC_V
AR_MISC_CASH_DIST_L_V miscellanous cash receipt line distribution extract
AR_NET_REVENUE Determine the uncredited amount on a transaction line
AR_NET_REVENUE_AMOUNT Determine the uncredited amount on a transaction line
AR_NET_REVENUE_AMOUNT_OLD Determine the uncredited amount on a transaction line
AR_NET_REVENUE_ASSIGNMENTS
AR_NOTES_V (Release 10SC Only)
AR_OEX_CM_VIEW
AR_OEX_INVOICE_VIEW (Invoice view for Oracle Exchange Invoices)
AR_OEX_RECEIPTS_VIEW This is the view for the Oracle Exchange Bill Presentment Payments page.
AR_OPEN_ITEMS_V (Release 115 Only)
AR_OPEN_TRX_V (Release 115 Only)
AR_PARTY_FIND_V
AR_PAYING_RELATIONSHIPS_V (Release 11.5 Only)
AR_PAYMENTS_INTERFACE_V Payments Interface used in the maintain transmission data form
AR_PAYMENT_SCHEDULES_ALL_MRC_V
AR_PAYMENT_SCHEDULES_FLEX_VIEW Descriptive Flexfields for payment schedules
AR_PAYMENT_SCHEDULES_MRC_V
AR_PAYMENT_SCHEDULES_PMT_V (Release 115 Only )
AR_PAYMENT_SCHEDULES_TRX2_V
AR_PAYMENT_SCHEDULES_TRX_V (Release 115 Only )
AR_PAYMENT_SCHEDULES_V
AR_PAYMENT_TERM_S_V payment term shared extract
AR_PAYMENT_TERM_S_VL payment term shared mls extract
AR_PAY_CUST_S_V paying customer shared extract
AR_PAY_SITE_USES_S_V paying site shared extract
AR_PERIODS_V (Release 10SC Only)
AR_PHONES_V (Release 115 Only)
AR_POSTAL_CODE_RANGES_V (Release 115 Only)
AR_POSTED_TRANSACTIONS_V (Release 11)
AR_RATE_ADJUSTMENTS_ALL_MRC_V - Retrofitted
AR_RATE_ADJUSTMENTS_MRC_V - Retrofitted
AR_RA_SELECTED_TRX_V (Release 11.5 Only)
AR_RCT_CUST_H_V AR XLA Extract
AR_RCT_CUST_L_V AR XLA Extract
AR_RCT_CUST_S_V cash receipt customer shared extract
AR_RCT_METHOD_H_V AR XLA Extract
AR_RCT_METHOD_S_V cash receipt receipt method shared extract
AR_RCT_SITE_USES_H_V AR XLA Extract
AR_RCT_SITE_USES_S_V cash receipt site shared extract
AR_RDR_ITEMS_V
AR_RECEIPT_AMOUNTS_V (Release 10SC Only)
AR_RECEIPT_HISTORY_H_V cash receipt history header extract
AR_RECEIPT_HISTORY_L_V cash receipt history lines extract
AR_RECEIPT_METHOD_NAME_V
AR_RECEIPT_TRX_TYPE_VIEW A union of AR_RECEIPT_METHODS and RA_CUST_TRX_TYPES
AR_RECEIVABLES_TRX_ACT_S_V receivable activity shared extract
AR_RECEIVABLES_TRX_ED_L_V earned discount activity line extract
AR_RECEIVABLES_TRX_MISC_H_V miscellaneous cash receipt receivable activity header extract
AR_RECEIVABLES_TRX_UNED_L_V unearned discount activity line extract
AR_RECEIVABLE_APPLICATIONS_V (Release 11.5 Only)
AR_RECEIVABLE_APPS_ALL_MRC_V
AR_RECEIVABLE_APPS_L_V receivable application line extract
AR_RECEIVABLE_APPS_MRC_V
AR_REMITTED_RECEIPTS_FORMAT_V Holds general information of remitted receipts being formatted for reporting purpose
AR_REMIT_BANK_ACCT_H_V AR XLA Extract
AR_REMIT_BANK_ACCT_S_V cash receipt remit bank account shared extract
AR_REMIT_TO_ADDRESSES_V (Release 11.5 Only)
AR_REMIT_TO_COUNTRY Combines FND_TERRITORIES and AR_LOOKUPS
AR_REMIT_TO_STATE This view combines all STATE values in AR_LOCATION_VALUES and the DEFAULT lookup code in AR_LOOKUPS
AR_REVENUE_ADJUSTMENTS_RA_V
AR_REVENUE_ASSIGNMENTS Determine the revenue recognition schedules for invoices that use invoicing rules
AR_REVENUE_ASSIGNMENTS_V
AR_REV_ASSIGN_FOR_PPRR_V Determine the revenue recognition schedules for invoices that use invoicing rules
AR_REV_ASSIGN_FOR_STD_V Determine the revenue recognition schedules for invoices that use invoicing rules
AR_RGW_CASH_MANAGEMENT_V (Release 10SC Only)
AR_RGW_RATE_ADJUSTMENTS_V (Release 10SC Only)
AR_RGW_RECEIPT_HISTORY_V (Release 10SC Only)
AR_RX_OTHER_APPLICATIONS_V (Base view for RXi:Other Applications Report )
AR_SALESREP_L_V salesrep line extract
AR_SALESREP_S_V salesrep shared extract
AR_SHIP_ADDRESS_V Active Ship to Addresses
AR_SHIP_TO_ADDRESSES_ACTIVE_V (Release 11.5 Only)
AR_SHIP_TO_CUSTOMERS_S_V ship to customer shared extract
AR_SHIP_TO_SITE_USES_S_V ship to site shared extract
AR_SITES_ASSIGNED_V
AR_SITE_USES_V (Release 11.5 Only)
AR_SITE_USE_V (Release 11.5 Only)
AR_SOLD_TO_CUSTOMERS_S_V sold to customer shared extract
AR_SOLD_TO_SITE_USES_S_V sold to site shared extract
AR_STANDARD_TEXT_VL
AR_STATEMENTS_V (Release 11.5 Only)
AR_SYSTEM_PARAMETERS_ALL_MRC_V - Retrofitted
AR_SYSTEM_PARAMETERS_MRC_V - Retrofitted
AR_SYSTEM_PARAMETERS_OU_V Release 11.5
AR_SYSTEM_PARAM_H_V
AR_TAX_LINES_V (Release 10SC Only)
AR_TAX_SUMM_V (Release 10SC Only)
AR_TA_ASGN_TO_INT SINGLE_ORG view
AR_TA_CASHAPP_OB SINGLE_ORG view
AR_TA_CR_AGEN_INF SINGLE_ORG view
AR_TA_CR_AGEN_INF_V
AR_TA_CUSTOMER_PROFILE_V
AR_TA_CUST_INT SINGLE_ORG view
AR_TA_CUST_TRXSTR SINGLE_ORG view
AR_TA_DEDN_ASSGNS SINGLE_ORG view
AR_TA_DEDN_ASSGNS_ALL_V Deduction Assignment Details
AR_TA_DEDN_INT SINGLE_ORG view
AR_TA_DEDN_RELATE SINGLE_ORG view
AR_TA_DEDUCTIONS_V
AR_TA_DEDUCTN_ASSIGNED_TO_V
AR_TA_ESS_CREDIT_V
AR_TA_ESS_INVOICE_V
AR_TA_ESS_LINE_V
AR_TA_INT_BATCH_NAME_V
AR_TA_INT_CHECK_NUMBER_V
AR_TA_INT_CUST_REF_NUM_V
AR_TA_INT_DEDUCTN_NUM_V
AR_TA_INT_INVOICE_NUMBER_V
AR_TA_INT_LOCATION_NUMBER_V
AR_TA_LINE_OF_BUSINESS_V
AR_TA_PAYMENTS_INTERFACE_BAT_V
AR_TA_PAYMENTS_INTERFACE_REM_V
AR_TA_PAYMENTS_INTERFACE_RET_V
AR_TA_PAYMNT_HIST SINGLE_ORG view
AR_TA_PROCEDURES_TEXT_V
AR_TA_PROF_ASSGNT SINGLE_ORG view
AR_TA_PROF_ASSGNT_V
AR_TA_PROMOTIONS SINGLE_ORG view
AR_TA_PROMOTIONS_V
AR_TA_PROM_CUST SINGLE_ORG view
AR_TA_PROM_CUST_MAP_V
AR_TA_PROM_LEGACY_CUSTOMERS_V
AR_TA_PROM_PAYMNT SINGLE_ORG view
AR_TA_PROM_PRODS SINGLE_ORG view
AR_TA_RECON_INFO SINGLE_ORG view
AR_TA_RECV_TRXSET SINGLE_ORG view
AR_TA_RECV_TRXSET_V
AR_TA_REMIT_HIST SINGLE_ORG view
AR_TA_REMIT_PROF SINGLE_ORG view
AR_TA_REMIT_PROF_V
AR_TA_RISK_COMENT SINGLE_ORG view
AR_TA_RULES SINGLE_ORG view
AR_TA_RULE_SETS SINGLE_ORG view
AR_TA_RULE_SET_LN SINGLE_ORG view
AR_TA_RULE_SET_LN_V
AR_TA_SPLIT_MERGE_V
AR_TA_TO_DMS_REQUEST_ID_V
AR_TA_TRX_SETS SINGLE_ORG view
AR_TA_TRX_SET_LN SINGLE_ORG view
AR_TA_TRX_SET_LN_V
AR_TA_TRX_TYP_INT SINGLE_ORG view
AR_TA_VRH_ADJ_V
AR_TA_VRH_DEDU_V
AR_TA_VRH_MTRX_V
AR_TA_VRH_RECEIPTS_V
AR_TA_VRH_RLINES_V
AR_TA_VUP_DETAILS_V
AR_TRANSACTIONS_S_V transaction shared extract
AR_TRANSACTION_HISTORY_H_V transaction history header extract
AR_TRX_BATCHES_S_V transaction batch shared extract
AR_TRX_BATCH_SOURCE_S_V transaction batch source shared extract
AR_TRX_DISCOUNTS_V (Release 11.5 Only)
AR_TRX_DIST_LINE_REP_ITF_V
AR_TRX_HISTORY_ALL_MRC_V
AR_TRX_HISTORY_MRC_V
AR_TRX_INF_V
AR_TRX_REP_ITF_V
AR_TRX_SCHEDULES_REP_ITF_V
AR_TRX_TAX_L_V transaction tax line extract
AR_TRX_TAX_L_VL transaction tax line mls extract
AR_UOM_L_VL unit of measure line mls extract
AR_VAT_TAX_ALL_VL
AR_VAT_TAX_VL
AR_XLA_ARD_ADJ_LINES_V help reports to read the CCID from XLA
AR_XLA_ARD_CRH_LINES_V help reports to read the CCID from XLA
AR_XLA_ARD_LINES_V help reports to read the CCID from XLA
AR_XLA_ARD_MCD_LINES_V help reports to read the CCID from XLA
AR_XLA_ARD_RA_LINES_V help reports to read the CCID from XLA
AR_XLA_ARD_TRH_LINES_V help reports to read the CCID from XLA
AR_XLA_CTLGD_LINES_V help reports to read the CCID from XLA
AR_XML_INVOICE_CHARGE_V
AR_XML_INVOICE_LINE_V
AR_XML_INVOICE_REMIT_TO_V
AR_XML_INVOICE_TAX_V
AR_XML_INVOICE_TP_V
AR_XML_INVOICE_V
AR_XML_PAYMENT_TERMS_V
AR_XML_PO_INFO_V
AR_XML_SO_INFO_V
GEOCODECI
GEOCODECO
HZ_ATTRIBUTE_TRANS_V
HZ_ATTRIB_PRIMARY_SEC_V
HZ_CLASSCODE_RELATIONS_V
HZ_CLASS_CATEGORIES_V Translation view for classification categories
HZ_CLASS_CATEGORY_GROUPINGS_V Classification Category Groupings
HZ_CLASS_CATEGORY_V
HZ_CONTACT_FIND_V
HZ_CONTACT_RESTRICTIONS
HZ_CREDIT_PROFILES_V
HZ_CREDIT_PROFILE_AMTS_V
HZ_CREDIT_RATINGS_EXT_VL Multilingual view of extensible attributes for credit ratings
HZ_CREDIT_RATINGS_OCV_V
HZ_CREDIT_USAGES_V
HZ_CREDIT_USAGE_RULES_V
HZ_CREDIT_USAGE_RULE_SETS_V
HZ_CREDIT_USAGE_RULE_SETS_VL
HZ_CUSTOMER_PARTY_FIND_V
HZ_CUSTOMER_PARTY_SITE_FIND_V
HZ_DQM_AC_AS_V
HZ_DQM_AC_CS_V
HZ_DQM_AC_C_V
HZ_DQM_CPTS_V
HZ_DQM_CS_CPT_V
HZ_DQM_CS_C_V
HZ_DQM_CS_U_V
HZ_DQM_ORG_CONTACT_INFO_V
HZ_DQM_PARTY_CPT_V
HZ_DQM_PS_CPT_V
HZ_DQM_PS_C_V
HZ_DQM_PS_U_V
HZ_DQM_PS_V
HZ_DQM_P_AC_V
HZ_DQM_P_PS_V
HZ_DQM_P_V
HZ_DQM_RE_P_V
HZ_DSS_GRANTS_V
HZ_DSS_GROUPS_VL
HZ_DSS_SECURED_CLASSES_V
HZ_DSS_SECURED_MODULES_V
HZ_DSS_SECURED_REL_TYPES_V
HZ_DSS_SEL_ENTITIES_V
HZ_DUP_BATCH_REVIEW_DTL_V
HZ_DUP_BATCH_REVIEW_V
HZ_DUP_SETS_V
HZ_DUP_SET_PARTIES_V
HZ_EXT_DATA_RULES_VL
HZ_FIN_NUMBERS_EXT_VL Multilingual view of extensible attributes for financial numbers
HZ_FIN_NUMBERS_OCV_V
HZ_FIN_REPORTS_EXT_VL Multilingual view of extensible attributes for financial reports
HZ_FIN_REPORTS_OCV_V
HZ_GEOGRAPHY_TYPES_VL
HZ_GROUP_WF_ROLES_V
HZ_GROUP_WF_USER_ROLES_V
HZ_LOCATIONS_EXT_VL Multilingual view of extensible attributes for locations
HZ_LOCATIONS_OCV_V
HZ_MATCH_RULES_VL
HZ_MERGE_ADDRESSES_V
HZ_MERGE_PARTY_RELN_V
HZ_MERGE_PARTY_SITE_DETAILS_V
HZ_ORGANIZATION_PROFILES_V
HZ_ORG_CONTACTS_CPUI_V Organization Contacts
HZ_ORG_CONTACTS_V
HZ_ORG_PROFILES_CPUI_V Organization Profiles
HZ_ORG_PROFILES_EXT_VL Multilingual view of extensible attributes for organizations
HZ_ORG_PROFILES_OCV_V
HZ_ORIG_SYSTEMS_VL
HZ_PARTY_CONTACT_POINTS_V
HZ_PARTY_RELATIONSHIPS
HZ_PARTY_RELATIONSHIP_V
HZ_PARTY_SITES_EXT_VL Multilingual view of extensible attributes for party sites
HZ_PARTY_SITES_OCV_V
HZ_PARTY_SITES_V
HZ_PARTY_USAGES_VL VL view to select party usage.
HZ_PARTY_WF_ROLES_V
HZ_PARTY_WF_USER_ROLES_V
HZ_PERSON_PROFILES_CPUI_V Person Profiles
HZ_PERSON_PROFILES_V
HZ_PER_PROFILES_EXT_VL Multilingual view of extensible attributes for persons
HZ_PER_PROFILES_OCV_V
HZ_PROFILE_AMTS_V
HZ_RELATIONSHIPS_V
HZ_RELATIONSHIP_GROUPINGS_V Relationship Groupings
HZ_SITE_USES_V
HZ_STYLES_VL Translation view for name and address formatting styles
HZ_STYLE_FMT_LAYOUTS_VL Translation view for name and address formatting style layouts
HZ_STYLE_FORMATS_VL Translation view for name and address formatting style formats
HZ_TIMEZONES_VL
HZ_TRANSFORMATION_ATTRIBUTES_V
HZ_TRANS_ATTRIBUTES_VL
HZ_TRANS_FUNCTIONS_VL
HZ_WORD_RPL_CONDS_VL Ties in the HZ_WORD_RPL_CONDS_TL and HZ_WORD_RPL_CONDS_B tables
HZ_WSRVC_ACCT_SITE_USES_V Internal view for Account Site Use
HZ_WSRVC_ORG_ACCOUNT_V Internal view for Organization Account
HZ_WSRVC_PARTY_GROUPS_V Internal view for Groups
HZ_WSRVC_PERSON_ACCOUNT_V Internal view for Person Account
HZ_WSRVC_REL_TYPES_V Internal view for Relationship Types
OKL_AR_ADJUSTMENTS_H_V
OKL_AR_CASH_RECEIPTS_H_V required for public and self-service views
OKL_AR_CM_LINES_L_V
OKL_AR_CUST_TRX_LINES_L_V
OKL_AR_RECEIVABLE_APPS_L_V required for public and self-service views
RATECI
RATECO
RA_ADDRESSES
RA_ADDRESSES_MORG Customer address information
RA_BATCHES_ALL_MRC_V
RA_BATCHES_MRC_V
RA_BATCHES_V (Release 115)
RA_CUSTOMERS_VIEW SINGLE_ORG view
RA_CUSTOMER_BILL_VIEW Information about customer who is billed
RA_CUSTOMER_RELATIONSHIPS SINGLE_ORG view
RA_CUSTOMER_RELATIONSHIPS_MORG Information about customer relationships
RA_CUSTOMER_SHIP_VIEW Information about customer who gets the shipments
RA_CUSTOMER_TRX_ALL_MRC_V
RA_CUSTOMER_TRX_CM_V (Release 115 Only)
RA_CUSTOMER_TRX_CR_TRX_V (Release 115 Only)
RA_CUSTOMER_TRX_FRT_V (Release 115 Only)
RA_CUSTOMER_TRX_INST_V (Release 10SC Only)
RA_CUSTOMER_TRX_LINES_FRT_V (Release 10SC Only)
RA_CUSTOMER_TRX_LINES_RA_V
RA_CUSTOMER_TRX_LINES_V (Release 115)
RA_CUSTOMER_TRX_MRC_V
RA_CUSTOMER_TRX_PARTIAL_V (Release 115 Only)
RA_CUSTOMER_TRX_PART_CB_V (Release 115 Only)
RA_CUSTOMER_TRX_RA_V
RA_CUSTOMER_TRX_V (Release 115)
RA_CUST_TRX_LINE_GL_DIST_RA_V (Release 115)
RA_CUST_TRX_LINE_GL_DIST_V (Release 115)
RA_CUST_TRX_LINE_SALESREPS_V (Release 10SC Only)
RA_CUST_TRX_LINE_SALESREP_RA_V
RA_CUST_TRX_LN_ALL_MRC_V
RA_CUST_TRX_LN_MRC_V
RA_HCONTACTS
RA_HCONTACT_ROLES Contact roles
RA_HCUSTOMERS Customer information
RA_HPHONES
RA_INTERFACE_ERRORS_V
RA_SALESREPS Backward compatible single-org view for ra_salesreps_all
RA_SITE_USES
RA_SITE_USES_MORG Business purpose of a customer address
RA_TAX_EXEMPTIONS_STRC_V (Release 115 Only)
RA_TERMS_VL (Release 11.5 and Release 12.0)
RA_TRX_LINE_GL_DIST_ALL_MRC_V
RA_TRX_LINE_GL_DIST_MRC_V
TAXVNYCITY
TAX_ADJUSTMENTS_V Approved Tax Adjustments affecting Transactions or Receipt reversals
TAX_ADJUSTMENTS_V_A Release 11.5
TAX_ADJUSTMENTS_V_V Release 11.5
TAX_EXEMPTIONS_QP_V Lists Candidate Exemption Certificates for the Bill To Customer and the Ship To Site
TAX_EXEMPTIONS_V
TAX_LINES_CM_V Lines to retax after a user manually updates invoice header attributes
TAX_LINES_CM_V_A Release 11
TAX_LINES_CM_V_V Release 11
TAX_LINES_CREATE_V Lines to retax after a user manually updates invoice header attributes
TAX_LINES_CREATE_V_A Release 11
TAX_LINES_CREATE_V_V Release 11
TAX_LINES_DELETE_V Lines to retax after a user manually updates invoice header attributes
TAX_LINES_DELETE_V_A Release 11
TAX_LINES_DELETE_V_V Release 11