Views in Accounts Receivables Module

Views in Oracle AR module:

AR_ACTIONS_V
AR_ACTIVE_REMIT_TO_ADDRESSES_V
AR_ACTIVITY_DETAILS_DFV
AR_ADDR_CATEGORIES_ACTIVE_V
AR_ADDRESSES_V
AR_ADJ_DIST_UPG_V
AR_ADJ_INF_V
AR_ADJUSTMENTS_ALL_MRC_V
AR_ADJUSTMENTS_ALL1_DFV
AR_ADJUSTMENTS_H_V
AR_ADJUSTMENTS_MRC_V
AR_ADJUSTMENTS_V
AR_AEL_GL_ADJ_V
AR_AEL_GL_CB_REC_V
AR_AEL_GL_INV_V
AR_AEL_GL_REC_ALL_V
AR_AEL_GL_REC_V
AR_AEL_SL_ADJ_MRC_V
AR_AEL_SL_ADJ_V
AR_AEL_SL_CB_REC_V
AR_AEL_SL_INV_MRC_V
AR_AEL_SL_INV_V
AR_AEL_SL_REC_MRC_V
AR_AEL_SL_REC_V
AR_AGING_BUCKET_LINES_B_DFV
AR_AGING_BUCKET_LINES_VL
AR_AGING_BUCKETS_DFV
AR_AGREEMENTS_S_V
AR_AGREEMENTS_S_VL
AR_AI_BATCH_SOURCE_V
AR_AI_ORG_V
AR_ALL_ENABLED_CURRENCIES_V
AR_AP_TAX_CODES_V
AR_APP_ADJ_V
AR_APP_DIST_UPG_V
AR_APPROVAL_ACTION_HISTORY_DFV
AR_APPROVAL_ACTION_HISTORY_V
AR_APPROVAL_USER_LIMITS_DFV
AR_AUTOCASH_HIERARCHIES_DFV
AR_AUTOCASH_RULES_DFV
AR_AUTOMATIC_RECEIPTS_FORMAT_V
AR_BATCH_REMIT_V
AR_BATCH_SOURCES_ALL_DFV
AR_BATCHES_ALL_DFV
AR_BATCHES_ALL_MRC_V
AR_BATCHES_MRC_V
AR_BATCHES_V
AR_BILL_DRAWEE_ADDRESS_V
AR_BILL_TO_ADDRESSES_ACTIVE_V
AR_BILL_TO_CUSTOMERS_S_V
AR_BILL_TO_SITE_USES_S_V
AR_BOE_AUTO_RECEIPTS_V
AR_BOE_REMIT_RECEIPTS_CBR_V
AR_BOE_REMIT_RECEIPTS_CBUNR_V
AR_BOE_REMIT_RECEIPTS_NONCBR_V
AR_BOE_REMIT_RECEIPTS_V
AR_BPA_CONTENT_AREAS_VL
AR_BPA_DATA_SOURCES_VL
AR_BPA_DATASRC_APPS_VL
AR_BPA_ITEMS_VL
AR_BPA_PAGE_SETUPS_VL
AR_BPA_RULE_ATTRIBUTES_VL
AR_BPA_RULES_VL
AR_BPA_TEMPLATES_VL
AR_BPA_URLS_VL
AR_BR_ACTIVITIES_V
AR_BR_ASSIGNMENTS_V
AR_BR_BATCHES_V
AR_BR_HISTORY_V
AR_BR_MAIN_REMIT_BATCH_V
AR_BR_STAMP_VALUES_ALL_DFV
AR_CALL_ACTIONS_V
AR_CASH_AUTO_RULE_SETS_VL
AR_CASH_AUTOMATCHES_VL
AR_CASH_BASIS_DISTS_MRC_V
AR_CASH_RECEIPT_HIST_ALL_MRC_V
AR_CASH_RECEIPT_HIST_MRC_V
AR_CASH_RECEIPTS_ALL_DFV
AR_CASH_RECEIPTS_ALL_MRC_V
AR_CASH_RECEIPTS_ALL1_DFV
AR_CASH_RECEIPTS_ALL2_DFV
AR_CASH_RECEIPTS_H_V
AR_CASH_RECEIPTS_L_V
AR_CASH_RECEIPTS_MRC_V
AR_CASH_RECEIPTS_S_V
AR_CASH_RECEIPTS_V
AR_CASH_RECOS_PS
AR_CBA_BANK_ACCOUNT_CONTACTS_V
AR_CBA_BANK_BRANCH_CONTACTS_V
AR_CBA_EFT_USER_NUMBER_V
AR_CC_ERROR_MAPPINGS_V
AR_CC_ERRORS_V
AR_CHARGE_SCHEDULE_HEADERS_V
AR_CHARGE_SCHEDULE_LINES_V
AR_CHARGEBACKS_V
AR_CM_ACTIVITIES_V
AR_CM_APP_DIST_LINES_L_V
AR_CM_BATCH_SRC_H_V
AR_CM_BATCH_SRC_S_V
AR_CM_BATCHES_H_V
AR_CM_BATCHES_S_V
AR_CM_BILL_SITE_USES_H_V
AR_CM_BILL_SITE_USES_S_V
AR_CM_BILL_TO_CUST_H_V
AR_CM_BILL_TO_CUST_S_V
AR_CM_ETAX_ACCOUNTS_L_V
AR_CM_ETAX_L_VL
AR_CM_INVENTORY_L_V
AR_CM_ITEM_CAT_L_VL
AR_CM_LINES_BASE_V
AR_CM_LINES_L_V
AR_CM_NET_REV_ASSIGNMENTS_FRM
AR_CM_NET_REVENUE
AR_CM_NET_REVENUE_ASSIGNMENTS
AR_CM_NET_REVENUE_FORM
AR_CM_PAY_CUST_H_V
AR_CM_PAY_CUST_S_V
AR_CM_PAY_SITE_USES_H_V
AR_CM_PAY_SITE_USES_S_V
AR_CM_SALESREP_H_V
AR_CM_SALESREP_L_V
AR_CM_SALESREP_S_V
AR_CM_SHIP_TO_CUST_H_V
AR_CM_SHIP_TO_CUST_S_V
AR_CM_SHIP_TO_SITE_USES_H_V
AR_CM_SHIP_TO_SITE_USES_S_V
AR_CM_SOLD_SITE_USES_H_V
AR_CM_SOLD_SITE_USES_S_V
AR_CM_SOLD_TO_CUST_H_V
AR_CM_SOLD_TO_CUST_S_V
AR_CM_UOM_L_VL
AR_CMGT_DATA_POINTS_VL
AR_CMGT_DNB_ELEMENTS_VL
AR_CMGT_PARTY_ACCOUNTS
AR_CMGT_SCORABLE_DATA_POINTS_V
AR_CONS_BILL_CYCLES_VL
AR_CONS_INV_DRAFT_V
AR_CONS_INV_V
AR_CONTACT_ROLES_V
AR_CONTACTS_ACTIVE_V
AR_CONTACTS_V
AR_CORRECT_GL_ACCOUNTS_V
AR_CORRECT_GL_LINES_V
AR_CORRESPONDENCES_V
AR_CR_INF_V
AR_CREDIT_HISTORIES_DFV
AR_CREDIT_MEMO_H_V
AR_CREDIT_MEMO_S_V
AR_CUST_CALLS_V
AR_CUST_CATEGORIES_ACTIVE_V
AR_CUST_PROF_CLASS_AMTS
AR_CUST_RECEIPT_METHODS_V
AR_CUST_TRX_LINES_BASE_V
AR_CUST_TRX_LINES_L_V
AR_CUSTOMER_ACCOUNTS
AR_CUSTOMER_ACCOUNTS_CA
AR_CUSTOMER_ACCOUNTS_CE
AR_CUSTOMER_ACCOUNTS_LA
AR_CUSTOMER_ACCOUNTS_LE
AR_CUSTOMER_ALT_NAMES_V
AR_CUSTOMER_BANK_ACCOUNTS_V
AR_CUSTOMER_BILLS_TRX_V
AR_CUSTOMER_CALL_TOPICS_AL_DFV
AR_CUSTOMER_CALL_TOPICS_V
AR_CUSTOMER_CALLS_ALL_DFV
AR_CUSTOMER_CALLS_V
AR_CUSTOMER_CLASSES_ACTIVE_V
AR_CUSTOMER_CONTACT_FIND_V
AR_CUSTOMER_FIND_V
AR_CUSTOMER_PAYMENT_SCHEDULES
AR_CUSTOMER_PROFILE_CLASSES_V
AR_CUSTOMER_PROFILES_V
AR_CUSTOMER_RELATIONSHIPS_V
AR_CUSTOMER_SEARCH_V
AR_CUSTOMER_VENDOR_NIF_V
AR_CUSTOMER_VENDOR_V
AR_CUSTOMER_VENDOR_VAT_V
AR_CUSTOMERS
AR_CUSTOMERS_ACTIVE_V
AR_CUSTOMERS_ALL_V
AR_CUSTOMERS_ASSIGNED_V
AR_DED_CHARGEBACKS_V
AR_DISPUTE_HISTORY_V
AR_DISTRIBUTION_SETS_H_V
AR_DISTRIBUTIONS_ALL_MRC_V
AR_DISTRIBUTIONS_BASE_V
AR_DISTRIBUTIONS_L_V
AR_DISTRIBUTIONS_MRC_V
AR_DOCS_RECEIVABLES_V
AR_DOCUMENT_LINES_V
AR_DOCUMENT_TRANSFERS_V
AR_DRAWEE_BANK_ACCOUNTS_H_V
AR_DRAWEE_CUSTOMERS_H_V
AR_DRAWEE_SITE_USES_H_V
AR_DUNNING_HISTORY_V
AR_DUNNING_LETTER_SET_LINE_DFV
AR_DUNNING_LETTER_SETS_DFV
AR_DUNNING_LETTERS_B_DFV
AR_DUNNING_LETTERS_CUSTOM_VL
AR_DUNNING_LETTERS_VL
AR_ETAX_ACCOUNTS_L_V
AR_ETAX_L_VL
AR_FEDERAL_CODE_ASSIG_V
AR_FUNDS_CAPTURE_ORDERS_V
AR_GL_SEGMENTS_REF_V
AR_GTA_GT_HEADERS_V
AR_GTA_GT_LINES_V
AR_GTA_TRX_HEADERS_V
AR_GTA_TRX_LINES_V
AR_ICR_LINES_TRX_V
AR_ICR_TRX_V
AR_IDEP_ACTIONS_NOT_TAKEN
AR_IDEP_ACTIONS_TAKEN
AR_IDEP_COMMITMENT_USAGE
AR_INTEREST_BATCHES_V
AR_INTEREST_HEADERS_V
AR_INTEREST_LINES_V
AR_INTERIM_CASH_RCPT_LINE1_DFV
AR_INTERIM_CASH_RCPT_LINE2_DFV
AR_INTERIM_CASH_RCPT_LINES_DFV
AR_INTERIM_CASH_RECEIPTS_1_DFV
AR_INTERIM_CASH_RECEIPTS_2_DFV
AR_INTERIM_CASH_RECEIPTS_A_DFV
AR_INTERIM_CASH_RECEIPTS_V
AR_INTERIM_CR_LINES_V
AR_INV_ACT_V
AR_INVENTORY_L_V
AR_INVOICE_ADJ_V
AR_INVOICE_COMMITMENT_INFO_V
AR_INVOICE_COUNT_TERMS_V
AR_INVOICE_HEADER_V
AR_INVOICE_INSTALLMENTS_V
AR_INVOICE_LINES_V
AR_INVOICE_TAX_SUMMARY_V
AR_INVOICE_TOTALS_V
AR_IREC_SELFREG_CUST_QS_DFV
AR_ITEM_CAT_L_VL
AR_LEDGER_H_V
AR_LINE_CONTINGENCIES_V
AR_LINE_DEFERRAL_REASONS_V
AR_LINE_EXCEPTIONS_V
AR_LINE_FREIGHT_V
AR_LINE_REVENUE_DETAILS_V
AR_LL_FREIGHT_CHARGES_V
AR_LL_LINES_GROUPS_V
AR_LL_SUMMARY_V
AR_LOC_FOUR_LEVEL_V
AR_LOC_ONE_LEVEL_V
AR_LOC_THREE_LEVEL_V
AR_LOC_TWO_LEVEL_V
AR_LOCATION_COMBINATIONS
AR_LOCATION_COMBINATIONS_DFV
AR_LOCATION_COMBINATIONS_KFV
AR_LOCATION_RATES
AR_LOCATION_RATES_DFV
AR_LOCATION_VALUES
AR_LOCATION_VALUES_DFV
AR_LOCATION_VALUES_V
AR_LOCKBOXES_ALL_DFV
AR_LOCVS_LOV_V
AR_LOOKUP_TYPES
AR_LOOKUPS
AR_MASS_APPLICATIONS_V
AR_MEMO_LINES_ALL_B_DFV
AR_MEMO_LINES_ALL_B1_DFV
AR_MEMO_LINES_ALL_VL
AR_MEMO_LINES_VL
AR_MERGE_ADDRESSES_V
AR_MISC_CASH_DIST_L_V
AR_MISC_CASH_DISTRIBUTION1_DFV
AR_MISC_CASH_DISTRIBUTIONS_DFV
AR_MISC_CASH_DISTRIBUTIONS_V
AR_MISC_CASH_DISTS_ALL_MRC_V
AR_MISC_CASH_DISTS_MRC_V
AR_NET_REVENUE
AR_NET_REVENUE_AMOUNT
AR_NET_REVENUE_ASSIGNMENTS
AR_NOTES_V
AR_OEX_CM_VIEW
AR_OEX_INVOICE_VIEW
AR_OEX_RECEIPTS_VIEW
AR_OPEN_ITEMS_V
AR_OPEN_TRX_V
AR_PARTY_FIND_V
AR_PAY_CUST_S_V
AR_PAY_SITE_USES_S_V
AR_PAYING_RELATIONSHIPS_V
AR_PAYMENT_SCHEDULES_ALL_DFV
AR_PAYMENT_SCHEDULES_ALL_MRC_V
AR_PAYMENT_SCHEDULES_ALL1_DFV
AR_PAYMENT_SCHEDULES_FLEX_VIEW
AR_PAYMENT_SCHEDULES_MRC_V
AR_PAYMENT_SCHEDULES_PMT_V
AR_PAYMENT_SCHEDULES_TRX_V
AR_PAYMENT_SCHEDULES_TRX2_V
AR_PAYMENT_SCHEDULES_V
AR_PAYMENT_TERM_S_V
AR_PAYMENT_TERM_S_VL
AR_PAYMENTS_INTERFACE_ALL_DFV
AR_PAYMENTS_INTERFACE_ALL1_DFV
AR_PAYMENTS_INTERFACE_V
AR_PERIODS_V
AR_PHONES_V
AR_POSTAL_CODE_RANGES_V
AR_POSTED_TRANSACTIONS_V
AR_RA_SELECTED_TRX_V
AR_RATE_ADJUSTMENTS_ALL_DFV
AR_RATE_ADJUSTMENTS_ALL_MRC_V
AR_RATE_ADJUSTMENTS_MRC_V
AR_RCT_CUST_H_V
AR_RCT_CUST_L_V
AR_RCT_CUST_S_V
AR_RCT_METHOD_H_V
AR_RCT_METHOD_S_V
AR_RCT_SITE_USES_H_V
AR_RCT_SITE_USES_S_V
AR_RDR_ITEMS_V
AR_RECEIPT_AMOUNTS_V
AR_RECEIPT_CLASSES_DFV
AR_RECEIPT_CLASSES1_DFV
AR_RECEIPT_HISTORY_H_V
AR_RECEIPT_HISTORY_L_V
AR_RECEIPT_METHOD_ACCOUNT1_DFV
AR_RECEIPT_METHOD_ACCOUNTS_DFV
AR_RECEIPT_METHOD_NAME_V
AR_RECEIPT_METHODS_DFV
AR_RECEIPT_METHODS1_DFV
AR_RECEIPT_TRX_TYPE_VIEW
AR_RECEIVABLE_APPLICATION1_DFV
AR_RECEIVABLE_APPLICATION2_DFV
AR_RECEIVABLE_APPLICATIONS_DFV
AR_RECEIVABLE_APPLICATIONS_V
AR_RECEIVABLE_APPS_ALL_MRC_V
AR_RECEIVABLE_APPS_L_V
AR_RECEIVABLE_APPS_MRC_V
AR_RECEIVABLES_TRX_ACT_S_V
AR_RECEIVABLES_TRX_ALL_DFV
AR_RECEIVABLES_TRX_ALL1_DFV
AR_RECEIVABLES_TRX_ED_L_V
AR_RECEIVABLES_TRX_MISC_H_V
AR_RECEIVABLES_TRX_UNED_L_V
AR_REMIT_BANK_ACCT_H_V
AR_REMIT_BANK_ACCT_S_V
AR_REMIT_TO_ADDRESSES_V
AR_REMIT_TO_COUNTRY
AR_REMIT_TO_STATE
AR_REMITTED_RECEIPTS_FORMAT_V
AR_REV_ASSIGN_FOR_PPRR_V
AR_REV_ASSIGN_FOR_STD_V
AR_REVENUE_ADJUSTMENTS_ALL_DFV
AR_REVENUE_ADJUSTMENTS_RA_V
AR_REVENUE_ASSIGNMENTS
AR_REVENUE_ASSIGNMENTS_V
AR_RGW_CASH_MANAGEMENT_V
AR_RGW_RATE_ADJUSTMENTS_V
AR_RGW_RECEIPT_HISTORY_V
AR_RX_OTHER_APPLICATIONS_V
AR_SALES_TAX_DFV
AR_SALES_TAX1_DFV
AR_SALESREP_L_V
AR_SALESREP_S_V
AR_SHIP_ADDRESS_V
AR_SHIP_TO_ADDRESSES_ACTIVE_V
AR_SHIP_TO_CUSTOMERS_S_V
AR_SHIP_TO_SITE_USES_S_V
AR_SITE_USE_V
AR_SITE_USES_V
AR_SITES_ASSIGNED_V
AR_SOLD_TO_CUSTOMERS_S_V
AR_SOLD_TO_SITE_USES_S_V
AR_STANDARD_TEXT_B_DFV
AR_STANDARD_TEXT_VL
AR_STATEMENT_CYCLES_DFV
AR_STATEMENTS_V
AR_SYSTEM_PARAM_H_V
AR_SYSTEM_PARAMETERS_ALL_DFV
AR_SYSTEM_PARAMETERS_ALL_MRC_V
AR_SYSTEM_PARAMETERS_ALL1_DFV
AR_SYSTEM_PARAMETERS_MRC_V
AR_SYSTEM_PARAMETERS_OU_V
AR_TA_HVRP_V
AR_TAX_CONDITION_ACTIONS_1_DFV
AR_TAX_CONDITION_ACTIONS_A_DFV
AR_TAX_CONDITION_LINES_AL1_DFV
AR_TAX_CONDITION_LINES_ALL_DFV
AR_TAX_CONDITIONS_ALL_DFV
AR_TAX_CONDITIONS_ALL1_DFV
AR_TAX_GROUP_CODES_ALL_DFV
AR_TAX_GROUP_CODES_ALL1_DFV
AR_TAX_LINES_V
AR_TAX_SUMM_V
AR_TO_SOP_DRILLDOWN_VIEW
AR_TRANS_RECORD_FORMATS_DFV
AR_TRANSACTION_HISTORY_ALL_DFV
AR_TRANSACTION_HISTORY_H_V
AR_TRANSACTIONS_S_V
AR_TRANSMISSION_FORMATS_DFV
AR_TRANSMISSIONS_ALL_DFV
AR_TRX_BATCH_SOURCE_S_V
AR_TRX_BATCHES_S_V
AR_TRX_DISCOUNTS_V
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
AR_TRX_TAX_L_VL
AR_UOM_L_VL
AR_VAT_TAX_ALL_B_DFV
AR_VAT_TAX_ALL_B1_DFV
AR_VAT_TAX_ALL_VL
AR_VAT_TAX_VL
AR_XLA_ARD_LINES_V
AR_XLA_CTLGD_LINES_V
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

2 responses to Views in Accounts Receivables Module

  1. hi,

    if i want view data from these views what are the set ups needed from taod.

    i have already set my policy context

  2. the login you use to connect to TOAD you need to ensure it has access permissions to these views, then you can see them. By default ‘APPS’ login will have all access.

Leave a reply

Your email address will not be published. Required fields are marked *