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 |
JAnani said on October 17, 2013
hi,
if i want view data from these views what are the set ups needed from taod.
i have already set my policy context
oracleguru said on October 17, 2013
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.