1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Tables (AR)

Discussion in 'Oracle Apps Technical' started by shrikantgarud, Oct 12, 2009.

  1. shrikantgarud

    shrikantgarud Forum Advisor

    Messages:
    21
    Likes Received:
    5
    Trophy Points:
    110
    Location:
    Mumbai
    [table]ar_action_notifications
    ar_adjustments_all
    ar_adjustments_rep_itf
    ar_ae_alloc_rec_gt
    ar_aging_buckets
    ar_aging_bucket_lines_b
    ar_aging_bucket_lines_tl
    ar_approval_action_history
    ar_approval_user_limits
    ar_app_rules
    ar_app_rule_details
    ar_app_rule_sets
    ar_archive_control
    ar_archive_control_detail
    ar_archive_detail
    ar_archive_header
    ar_archive_purge_interim
    ar_archive_purge_log
    ar_audit_data
    ar_autocash_hierarchies
    ar_autocash_rules
    ar_autorec_exceptions
    ar_bank_directory
    ar_batches_all
    ar_batch_sources_all
    ar_bpa_area_items
    ar_bpa_content_areas_b
    ar_bpa_content_areas_tl
    ar_bpa_datasrc_apps_b
    ar_bpa_datasrc_apps_tl
    ar_bpa_data_sources_b
    ar_bpa_data_sources_tl
    ar_bpa_data_src_params
    ar_bpa_items_b
    ar_bpa_items_tl
    ar_bpa_rules_b
    ar_bpa_rules_tl
    ar_bpa_rule_attributes_b
    ar_bpa_rule_attributes_tl
    ar_bpa_rule_templates
    ar_bpa_templates_b
    ar_bpa_templates_tl
    ar_bpa_urls_b
    ar_bpa_urls_tl
    ar_bpa_url_params
    ar_br_fmt_tmp
    ar_br_stamp_values_all
    ar_br_status_rep_itf
    ar_br_status_sum_itf
    ar_br_trx_batch_rpt
    ar_call_actions
    ar_cash_basis_dists_all
    ar_cash_receipts_all
    ar_cash_receipt_history_all
    ar_change_matrix
    ar_cmgt_auto_recommends
    ar_cmgt_auto_rules
    ar_cmgt_auto_rule_dtls
    ar_cmgt_bank_ref_accts
    ar_cmgt_bank_ref_data
    ar_cmgt_case_folders
    ar_cmgt_cf_aging_dtls
    ar_cmgt_cf_anl_notes
    ar_cmgt_cf_dnb_dtls
    ar_cmgt_cf_dtls
    ar_cmgt_cf_recommends
    ar_cmgt_check_lists
    ar_cmgt_check_list_dtls
    ar_cmgt_collateral_data
    ar_cmgt_credit_requests
    ar_cmgt_curr_usage_gt
    ar_cmgt_data_points_b
    ar_cmgt_data_points_tl
    ar_cmgt_dnb_elements_b
    ar_cmgt_dnb_elements_tl
    ar_cmgt_dnb_mappings
    ar_cmgt_financial_data
    ar_cmgt_guarantor_data
    ar_cmgt_other_data
    ar_cmgt_scores
    ar_cmgt_score_dtls
    ar_cmgt_score_weights
    ar_cmgt_setup_options
    ar_cmgt_trade_ref_data
    ar_cm_sum_trx_days_gt
    ar_colind
    ar_collection_indicators_all
    ar_collectors
    ar_conc_process_requests
    ar_conc_request_messages
    ar_confirmation_actions
    ar_cons_inv_all
    ar_cons_inv_trx_all
    ar_cons_inv_trx_lines_all
    ar_correspondences_all
    ar_corr_pay_sched_all
    ar_credit_histories
    ar_credit_memo_amounts
    ar_customer_alt_names
    ar_customer_balance_itf
    ar_customer_calls_all
    ar_customer_call_topics_all
    ar_customer_profiles
    ar_customer_profile_amounts
    ar_customer_profile_classes
    ar_cust_prof_class_amounts
    ar_cust_search_gt
    ar_debug
    ar_dispute_history
    ar_distributions_all
    ar_distribution_sets_all
    ar_distribution_set_lines_all
    ar_document_transfers
    ar_doc_sequence_audit
    ar_dunning_letters_b
    ar_dunning_letters_custom_tl
    ar_dunning_letters_tl
    ar_dunning_letter_sets
    ar_dunning_letter_set_lines
    ar_interim_cash_rcpt_lines_all
    ar_interim_cash_receipts_all
    ar_interim_posting
    ar_irec_custom_srch_gt
    ar_irec_payment_list_gt
    ar_journal_interim_all
    ar_location_accounts_all
    ar_location_combinations
    ar_location_rates
    ar_location_values
    ar_lockboxes_all
    ar_lookups_old
    ar_lookup_types_old
    ar_mc_adjustments
    ar_mc_batches
    ar_mc_cash_basis_dists_all
    ar_mc_cash_receipts
    ar_mc_cash_receipt_hist
    ar_mc_distributions_all
    ar_mc_misc_cash_dists
    ar_mc_payment_schedules
    ar_mc_rate_adjustments
    ar_mc_receivable_apps
    ar_mc_transaction_history
    ar_memo_lines_all_b
    ar_memo_lines_all_tl
    ar_misc_cash_distributions_all
    ar_mrc_cash_header
    ar_mrc_cash_lines
    ar_mrc_inq_trans_balances
    ar_notes
    ar_parallel_autoinstall
    ar_payments_interface_all
    ar_payment_schedules_all
    ar_periods
    ar_period_types
    ar_posting_control
    ar_posting_report_interim
    ar_purge_oe_exceptions
    ar_purge_rec_aux
    ar_purge_trx_aux
    ar_ramc_audit_trail
    ar_rate_adjustments_all
    ar_receipts_rep_itf
    ar_receipt_classes
    ar_receipt_methods
    ar_receipt_method_accounts_all
    ar_receivables_trx_all
    ar_receivable_applications_all
    ar_revenue_adjustments_all
    ar_sales_tax
    ar_sales_tax_rep_itf
    ar_selection_criteria
    ar_standard_text_b
    ar_standard_text_tl
    ar_statements_history_all
    ar_statements_history_all_temp
    ar_statement_cycles
    ar_statement_cycle_dates_all
    ar_statement_cycle_intervals
    ar_statement_headers
    ar_statement_line_clusters
    ar_sum_ref_event_hist
    ar_system_parameters_all
    ar_tax_conditions_all
    ar_tax_condition_actions_all
    ar_tax_condition_lines_all
    ar_tax_extract_dcl_itf
    ar_tax_extract_matrix_itf
    ar_tax_extract_sub_itf
    ar_tax_group_codes_all
    ar_tax_interface
    ar_ta_asgn_to_int_all
    ar_ta_cashapp_ob_all
    ar_ta_cr_agen_inf_all
    ar_ta_cust_hier_child
    ar_ta_cust_hier_parnt
    ar_ta_cust_int_all
    ar_ta_cust_trxstr_all
    ar_ta_dedn_assgns_all
    ar_ta_dedn_int_all
    ar_ta_dedn_relate_all
    ar_ta_legacy_cust_int
    ar_ta_legacy_stat_int
    ar_ta_paymnt_hist_all
    ar_ta_prof_assgnt_all
    ar_ta_promotions_all
    ar_ta_promotions_int
    ar_ta_prom_cust_all
    ar_ta_prom_cust_map
    ar_ta_prom_lines_int
    ar_ta_prom_paymnt_all
    ar_ta_prom_paymnt_typ
    ar_ta_prom_prods_all
    ar_ta_prom_status_map
    ar_ta_recon_info_all
    ar_ta_recv_trxset_all
    ar_ta_remit_hist_all
    ar_ta_remit_prof_all
    ar_ta_risk_coment_all
    ar_ta_rules_all
    ar_ta_rule_output
    ar_ta_rule_sets_all
    ar_ta_rule_set_ln_all
    ar_ta_trx_sets_all
    ar_ta_trx_set_ln_all
    ar_ta_trx_to_create
    ar_ta_trx_typ_int_all
    ar_ta_versions
    ar_transactions_rep_itf
    ar_transaction_history_all
    ar_transmissions_all
    ar_transmission_formats
    ar_trans_field_formats
    ar_trans_record_formats
    ar_trx_bal_summary
    ar_trx_summary
    ar_trx_summary_hist
    ar_vat_tax_all_b
    ar_vat_tax_all_tl
    hz_application_trans_gt
    hz_bank_val_gt
    hz_billing_preferences
    hz_certifications
    hz_citizenship
    hz_class_categories
    hz_class_category_uses
    hz_class_code_denorm
    hz_class_code_relations
    hz_code_assignments
    hz_contact_points
    hz_contact_point_val_gt
    hz_contact_preferences
    hz_contact_restrictions
    hz_credit_profiles
    hz_credit_profile_amts
    hz_credit_ratings
    hz_credit_usages
    hz_credit_usage_rules
    hz_credit_usage_rule_sets_b
    hz_credit_usage_rule_sets_tl
    hz_customer_merge_log
    hz_customer_profiles
    hz_customer_profiles_m
    hz_cust_accounts
    hz_cust_accounts_m
    hz_cust_account_roles
    hz_cust_account_roles_m
    hz_cust_acct_relate_all
    hz_cust_acct_relate_all_m
    hz_cust_acct_sites_all
    hz_cust_acct_sites_all_m
    hz_cust_contact_points
    hz_cust_merge_log_dict
    hz_cust_profile_amts
    hz_cust_profile_amts_m
    hz_cust_profile_classes
    hz_cust_prof_class_amts
    hz_cust_site_uses_all
    hz_cust_site_uses_all_m
    hz_dnb_request_log
    hz_dqm_details_gt
    hz_dqm_parties_gt
    hz_dqm_stage_gt
    hz_dqm_stage_log
    hz_dqm_sync_gt
    hz_dqm_sync_interface
    hz_dss_assignments
    hz_dss_criteria
    hz_dss_entities
    hz_dss_groups_b
    hz_dss_groups_tl
    hz_dss_scheme_functions
    hz_dss_secured_entities
    hz_dup_batch
    hz_dup_exclusions
    hz_dup_match_details
    hz_dup_merge_parties
    hz_dup_sets
    hz_dup_set_parties
    hz_education
    hz_employment_history
    hz_entity_attributes
    hz_ext_data_rules_tl
    hz_financial_numbers
    hz_financial_profile
    hz_financial_reports
    hz_group_val_gt
    hz_hierarchy_nodes
    hz_industrial_classes
    hz_industrial_class_app
    hz_industrial_reference
    hz_locations
    hz_location_val_gt
    hz_loc_assignments
    hz_log
    hz_log2
    hz_matched_contacts_gt
    hz_matched_cpts_gt
    hz_matched_parties_gt
    hz_matched_party_sites_gt
    hz_match_rules_b
    hz_match_rules_tl
    hz_match_rule_primary
    hz_match_rule_secondary
    hz_merge_batch
    hz_merge_dictionary
    hz_merge_entity_attributes
    hz_merge_parties
    hz_merge_parties_sugg
    hz_merge_partydtls_sugg
    hz_merge_party_details
    hz_merge_party_history
    hz_merge_party_log
    hz_mobile_prefixes
    hz_organization_indicators
    hz_organization_profiles
    hz_org_contacts
    hz_org_contact_roles
    hz_org_contact_val_gt
    hz_org_profile_val_gt
    hz_param_tab
    hz_parties
    hz_party_interface
    hz_party_interface_errors
    hz_party_preferences
    hz_party_relationships
    hz_party_score_dtls_gt
    hz_party_sites
    hz_party_site_uses
    hz_party_site_val_gt
    hz_party_val_gt
    hz_person_interest
    hz_person_language
    hz_person_profiles
    hz_phone_area_codes
    hz_phone_country_codes
    hz_phone_formats
    hz_primary_trans
    hz_purge_batches
    hz_purge_candidates
    hz_purge_gt
    hz_references
    hz_registrations
    hz_reg_verifications
    hz_relationships
    hz_relationship_types
    hz_relationship_val_gt
    hz_role_responsibility
    hz_secondary_trans
    hz_security_issued
    hz_select_data_sources
    hz_staged_contacts
    hz_staged_contact_points
    hz_staged_parties
    hz_staged_party_sites
    hz_stock_markets
    hz_styles_b
    hz_styles_tl
    hz_style_fmt_layouts_b
    hz_style_fmt_layouts_tl
    hz_style_fmt_locales
    hz_style_fmt_variations
    hz_style_formats_b
    hz_style_formats_tl
    hz_suspension_activity
    hz_thirdparty_exceps
    hz_thirdparty_rule
    hz_timezones
    hz_timezones_tl
    hz_timezone_mapping
    hz_trans_attributes_b
    hz_trans_attributes_tl
    hz_trans_functions_b
    hz_trans_functions_tl
    hz_user_create_rules
    hz_user_org_gt
    hz_user_overwrite_rules
    hz_win_source_exceps
    hz_word_lists
    hz_word_replacements
    hz_work_class
    je_de_ar_batches
    je_de_remittance_results
    jg_zz_ar_balances
    jg_zz_ar_tmp_account
    jg_zz_ar_tmp_bal
    jg_zz_ar_tmp_detail
    jg_zz_batch_number_r106
    jg_zz_ii_int_rates_all
    jg_zz_interest_batches_all
    jg_zz_interest_batch_r106
    jg_zz_interest_invoices_all
    jg_zz_interest_memos_r106
    jg_zz_int_inv_lines_all
    jg_zz_int_memo_invoices_r106
    jg_zz_jgzzcslp_messages
    jg_zz_lookup_values_all_r110
    jg_zz_system_parameters_r106
    mlog$_hz_relationships
    month_src_ti
    ra_account_combinations
    ra_account_defaults_all
    ra_account_default_segments
    ra_addresses_all
    ra_batches_all
    ra_batch_sources_all
    ra_cm_requests_all
    ra_cm_request_lines_all
    ra_contacts
    ra_contact_phones_int_all
    ra_contact_roles
    ra_customers
    ra_customers_interface_all
    ra_customer_banks_int_all
    ra_customer_merges
    ra_customer_merge_headers
    ra_customer_profiles_int_all
    ra_customer_relationships_all
    ra_customer_trx_all
    ra_customer_trx_lines_all
    ra_cust_pay_method_int_all
    ra_cust_receipt_methods
    ra_cust_trx_line_gl_dist_all
    ra_cust_trx_line_salesreps_all
    ra_cust_trx_types_all
    ra_grouping_rules
    ra_grouping_trx_types
    ra_group_bys
    ra_group_by_columns
    ra_interface_distributions_all
    ra_interface_errors_all
    ra_interface_lines_all
    ra_interface_salescredits_all
    ra_int_lines_bak
    ra_item_exception_rates
    ra_line_ordering_rules
    ra_line_order_bys
    ra_line_order_by_columns
    ra_mc_batches
    ra_mc_customer_trx
    ra_mc_customer_trx_lines
    ra_mc_trx_line_gl_dist
    ra_phones
    ra_recur_interim
    ra_regions
    ra_remit_tos_all
    ra_rules
    ra_rule_schedules
    ra_salesreps_all_old
    ra_salesrep_territories
    ra_salesrep_territories_wh
    ra_site_uses_all
    ra_tax_exemptions_all
    ra_terms_b
    ra_terms_lines
    ra_terms_lines_discounts
    ra_terms_tl
    ra_territories
    rupd$_hz_relationships
    total_cust
    ar_tax_code_combination_id_gt
    ocm_credit_review_gt
    dr$hz_stage_contact_t1$i
    dr$hz_stage_contact_t1$k
    dr$hz_stage_contact_t1$r
    dr$hz_stage_cpt_t1$i
    dr$hz_stage_contact_t1$n
    dr$hz_stage_cpt_t1$k
    dr$hz_stage_cpt_t1$r
    dr$hz_stage_cpt_t1$n
    dr$hz_class_code_denorm_t1$i
    dr$hz_class_code_denorm_t1$k
    dr$hz_class_code_denorm_t1$r
    dr$hz_class_code_denorm_t1$n
    dr$hz_stage_parties_t1$i
    dr$hz_stage_party_sites_t1$i
    dr$hz_stage_parties_t1$k
    dr$hz_stage_party_sites_t1$k
    dr$hz_stage_parties_t1$r
    dr$hz_stage_party_sites_t1$r
    dr$hz_stage_parties_t1$n
    dr$hz_stage_party_sites_t1$n
    hz_srch_psites
    hz_dup_results
    hz_int_dup_results
    hz_imp_dup_details
    hz_imp_dup_parties
    hz_imp_int_dedup_results
    hz_imp_parties_sg
    hz_imp_addresses_sg
    hz_imp_contactpts_sg
    hz_imp_creditrtngs_sg
    hz_imp_classifics_sg
    hz_imp_finreports_sg
    hz_imp_finnumbers_sg
    hz_imp_relships_sg
    hz_imp_contacts_sg
    hz_imp_contactroles_sg
    hz_imp_addressuses_sg
    ar_irec_custom_cust_gt
    ar_revenue_assignments_gt
    ar_statement_finchrg_gt
    ar_trx_errors_gt
    ar_bpa_print_requests
    hz_geography_types_b
    hz_geo_name_reference_log
    hz_imp_finreports_int
    hz_imp_finnumbers_int
    hz_geo_name_references
    hz_imp_classifics_int
    hz_geo_struct_map
    hz_imp_relships_int
    hz_geo_struct_map_dtl
    hz_imp_contactroles_int
    hz_imp_contacts_int
    hz_geo_structure_levels
    hz_srch_contacts
    hz_imp_addressuses_int
    hz_imp_errors
    hz_imp_tmp_errors
    hz_srch_cpts
    hz_imp_osr_change
    hz_imp_tmp_rel_end_date
    hz_srch_parties
    hz_orig_sys_mapping
    hz_orig_sys_references
    hz_adapter_logs
    ar_trx_header_gt
    ar_trx_dist_gt
    ar_trx_lines_gt
    ar_trx_salescredits_gt
    hz_dup_worker_chunk_gt
    hz_int_dup_results_gt
    ar_tax_extr_sub_ap_ext
    ar_tax_extr_sub_ar_ext
    ar_tax_extr_sub_com_ext
    ar_ccid_corrections_all
    hz_imp_work_units
    hz_email_domains
    ar_bpa_page_setups_b
    hz_imp_parties_int
    hz_geographies
    hz_imp_addresses_int
    ar_bpa_page_setups_tl
    hz_geography_identifiers
    hz_imp_contactpts_int
    ar_bpa_template_files
    hz_geography_ranges
    ar_bpa_template_fields
    hz_geography_types_tl
    hz_imp_creditrtngs_int
    hz_imp_adapters
    hz_imp_batch_details
    hz_imp_batch_summary
    hz_location_profiles
    hz_adapters
    hz_adapter_territories
    ctx_output
    ctx_adm
    dr$hz_cust_acct_sites_all_t1$i
    dr$hz_cust_acct_sites_all_t1$k
    dr$hz_cust_acct_sites_all_t1$r
    dr$hz_cust_acct_sites_all_t1$n
    aq$_ar_rev_rec_qt_s
    ar_rev_rec_qt
    aq$_ar_rev_rec_qt_h
    aq$_ar_rev_rec_qt_i
    aq$_ar_rev_rec_qt_t
    aq$ar_rev_rec_qt
    aq$ar_rev_rec_qt_s
    aq$ar_rev_rec_qt_r
    ctx_query
    ctx_ddl
    ctx_preferences
    ad_ctx_ddl[/table]
     
  2. rogerbnny

    rogerbnny Active Member

    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    75
    where are the tables
     
  3. zakkam

    zakkam Guest