Fixed Assets - Details from Tables

[anu_uma]

Hi all,

Can anyone provide me the details like the table name, column names and the query to find out the below given details

Asset Book,Asset No,Asset Gross Block Code Combination,Acc Dep Code Combination and Depreciation Code Combination

[?]

Regards,

[ramesh040671]

Hi Anu,

Please find below the FA - Base Tables name
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_ASSET_HIERARCHY_VALUES
FA_ASSET_HISTORY
FA_ASSET_INVOICES
FA_ASSET_KEYWORDS
FA_ASSET_LISTING_REP_ITF
FA_BALANCES_REPORT
FA_BALANCES_REP_ITF
FA_BONUS_RATES
FA_BONUS_RULES
FA_BOOKS
FA_BOOKS_GROUPS
FA_BOOK_CONTROLS
FA_BOOK_CONTROLS_HISTORY
FA_BUDGET_DISTRIBUTION
FA_BUDGET_INTERFACE
FA_CALENDAR_PERIODS
FA_CALENDAR_TYPES
FA_CAPITAL_BUDGET
FA_CAP_REP_ITF
FA_CATEGORIES_B
FA_CATEGORIES_TL
FA_CATEGORY_BOOKS
FA_CATEGORY_BOOK_DEFAULTS
FA_CEILINGS
FA_CEILING_TYPES
FA_CONVENTIONS
FA_CONVENTION_TYPES
FA_COSTCLEAR_REP_ITF
FA_DEFERRED_DEPRN
FA_DELETED_MASS_ADDITIONS
FA_DEPRN_BASIS_RULES
FA_DEPRN_DETAIL
FA_DEPRN_OVERRIDE
FA_DEPRN_PERIODS
FA_DEPRN_REP_ITF
FA_DEPRN_RULE_DETAILS
FA_DEPRN_SUMMARY
FA_DEPRN_TAX_REP_ITF
FA_DEPRN_TAX_REP_NBVS
FA_DISTRIBUTION_ACCOUNTS
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_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_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_ITC_RATES
FA_ITC_RECAPTURE_RATES
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_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_BOOK_CONTROLS
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_METHODS
FA_MRC_INQ_FINANCIALS
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_WHATIF_ITF
JE_DE_FA_SUMMARY
JE_HU_BALANCES_REPORT


Thanks
Ramesh - Oracle Apps Consultant

[anu_uma]

Hi,
I have all the table names but I want to know from which tables I can get the above details?

Anyway Thanks for your efforts.

[ramkic]

Hi,
Asset Book from FA_ADDTIONS_B and FA_ADDITIONS_TL AND FA_BOOKS
Asset No FA_ADDTIONS_B and FA_ADDITIONS_TL
,Asset Gross Block Code Combination --> No idea may be you are looking at a FORM derived volumns
,Acc Dep Code Combination and Depreciation Code Combination can get from FA_DISTRIBUTION_ACCOUNTS.

There are some other tables in which you may be interested like
FA_MASS_ADDITIONS (Interface table) and FA_ASSET_INVOICES ( Invoices from AP) will also have the Accounting combinations.

Thanks
Regards
ramkic

[anu_uma]

Hi Ramkic,

Thanks for your efforts and really it is helpful to me..

Thank you once again