Wednesday, August 29, 2018

FA Tables in Oracle APPS

fa_methods
fa_ace_books
fa_additions_b
fa_additions_tl
fa_addition_rep_itf
fa_add_warranties
fa_adjustments
fa_adjust_rep_itf
fa_amort_schedules
fa_archive_history
fa_asset_hierarchy
fa_asset_hierarchy_purpose
fa_mass_reval_rep_itf
fa_reserve_ledger_gt
fa_balances_report_gt
fa_asset_hierarchy_values
fa_asset_history
fa_asset_invoices
fa_asset_keywords
fa_asset_listing_rep_itf
fa_as_efc_07_jan_2002_03
fa_as_efc_20_feb_2003_12
fa_balances_report
fa_balances_rep_itf
fa_bonus_rates
fa_bonus_rules
fa_books
fa_books_groups
fa_books_summary
fa_book_controls
fa_book_controls_history
fa_budget_distribution
fa_budget_interface
fa_calendar_periods
fa_calendar_types
fa_ceilings
fa_ceiling_types
fa_cl_efc_07_jan_2002_03
fa_cl_efc_20_feb_2003_12
fa_conventions
fa_convention_types
fa_costclear_rep_itf
fa_ct_efc_07_jan_2002_03
fa_ct_efc_20_feb_2003_12
fa_capital_budget
fa_cap_bud_efc_07_jan_2002_03
fa_cap_bud_efc_20_feb_2003_12
fa_cap_rep_itf
fa_categories_b
fa_categories_tl
fa_category_books
fa_category_book_defaults
fa_cbd_efc_07_jan_2002_03
fa_cbd_efc_20_feb_2003_12
fa_deferred_deprn
fa_deleted_mass_additions
fa_deprn_basis_rules
fa_distribution_defaults
fa_distribution_history
fa_distribution_sets
fa_exclude_hierarchy_levels
fa_ext_inv_retirements
fa_fiscal_year
fa_flat_rates
fa_formulas
fa_gar_efc_07_jan_2002_03
fa_gar_efc_20_feb_2003_12
fa_group_assets
fa_group_asset_default
fa_group_asset_rules
fa_group_deprn_detail
fa_group_deprn_rates
fa_group_deprn_summary
fa_group_rep_itf
fa_hierarchy_controls
fa_hierarchy_distributions
fa_hierarchy_rule_details
fa_hierarchy_rule_set
fa_hrd_efc_07_jan_2002_03
fa_hrd_efc_20_feb_2003_12
fa_hrh_efc_07_jan_2002_03
fa_hrh_efc_20_feb_2003_12
fa_hr_retirement_details
fa_hr_retirement_headers
fa_ins_lines
fa_ins_mst_pols
fa_ins_policies
fa_ins_values
fa_inventory
fa_invmiss_rep_itf
fa_invoice_transactions
fa_inv_compare_rep_itf
fa_inv_interface
fa_ip_efc_07_jan_2002_03
fa_ip_efc_20_feb_2003_12
fa_itc_rates
fa_itc_recapture_rates
fa_iv_efc_07_jan_2002_03
fa_iv_efc_20_feb_2003_12
fa_journal_entries
fa_leases
fa_lease_payments
fa_lease_payment_items
fa_lease_schedules
fa_life_derivation_info
fa_locations
fa_lookups_b
fa_lookups_tl
fa_lookup_types_b
fa_lookup_types_tl
fa_lsp_efc_07_jan_2002_03
fa_lsp_efc_20_feb_2003_12
fa_lss_efc_07_jan_2002_03
fa_lss_efc_20_feb_2003_12
fa_ls_efc_07_jan_2002_03
fa_ls_efc_20_feb_2003_12
fa_maint_events
fa_maint_rep_itf
fa_maint_schedule_dtl
fa_maint_schedule_hdr
fa_massadd_distributions
fa_massadd_rep_itf
fa_mass_additions
fa_mass_changes
fa_mass_changes_itf
fa_mass_external_transfers
fa_mass_ext_retirements
fa_mass_ext_ret_excepts
fa_mass_reclass
fa_mass_reclass_itf
fa_mass_retirements
fa_mass_ret_excepts
fa_mass_revaluations
fa_mass_revaluation_rules
fa_mass_tax_adjustments
fa_mass_transfers
fa_mass_update_batch_details
fa_mass_update_batch_headers
fa_mc_adjustments
fa_mc_asset_invoices
fa_mc_books
fa_mc_books_groups
fa_mc_books_rates
fa_mc_books_summary
fa_mc_book_controls
fa_mc_br_efc_07_jan_2002_03
fa_mc_br_efc_20_feb_2003_12
fa_mc_ch_efc_07_jan_2002_03
fa_mc_ch_efc_20_feb_2003_12
fa_mc_conversion_history
fa_mc_conversion_rates
fa_mc_deferred_deprn
fa_mc_deprn_detail
fa_mc_deprn_periods
fa_mc_deprn_summary
fa_mc_group_deprn_detail
fa_mc_group_deprn_summary
fa_mc_mass_rates
fa_mc_retirements
fa_me_efc_07_jan_2002_03
fa_me_efc_20_feb_2003_12
fa_mrc_inq_financials
fa_msd_efc_07_jan_2002_03
fa_msd_efc_20_feb_2003_12
fa_msh_efc_07_jan_2002_03
fa_msh_efc_20_feb_2003_12
fa_parallel_workers
fa_periodic_production
fa_period_maps
fa_plsql_debug
fa_price_indexes
fa_price_index_values
fa_production_interface
fa_project_rep_itf
fa_proptax_rep_itf
fa_rates
fa_reclass_rep_itf
fa_reserve_ledger
fa_retirements
fa_retire_rep_itf
fa_rx_attrsets_b
fa_rx_attrsets_tl
fa_rx_dynamic_columns
fa_rx_lov
fa_rx_multiformat_reps
fa_rx_reports
fa_rx_rep_columns_b
fa_rx_rep_columns_tl
fa_rx_rep_parameters
fa_rx_security
fa_rx_summary_tl
fa_short_tax_reserves
fa_super_groups
fa_super_group_rules
fa_system_controls
fa_tax_interface
fa_tax_report
fa_track_members
fa_transaction_headers
fa_transfer_details
fa_transfer_rep_itf
fa_trx_references
fa_warranties
fa_war_efc_07_jan_2002_03
fa_war_efc_20_feb_2003_12
fa_whatif_itf
je_de_fa_summary
je_hu_balances_report
jg_zz_fa_ins_lines_r110
jg_zz_fa_ins_mst_pols_r110
jg_zz_fa_ins_policies_r110
jg_zz_fa_ins_values_r110

No comments:

Post a Comment

Query To Fetch AP Invoice Details From SO Number(Doc ID 2949013.1)

SELECT dh.source_order_number       ,df.source_line_number as so_line_number   ,df.fulfill_line_number    ,ddr.doc_user_key as po_number...