Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - OFA Tables and Views

TABLE - FA.FA_ACE_BOOKS
TABLE - FA.FA_ADDITIONS_B
TABLE - FA.FA_ADDITIONS_TL
TABLE - FA.FA_ADDITION_REP_ITF
TABLE - FA.FA_ADD_WARRANTIES
TABLE - FA.FA_ADJUSTMENTS
TABLE - FA.FA_ADJUSTMENTS_T
TABLE - FA.FA_ADJUST_REP_ITF
TABLE - FA.FA_AMORT_SCHEDULES
TABLE - FA.FA_ARCHIVE_HISTORY
TABLE - FA.FA_ASSET_HIERARCHY
TABLE - FA.FA_ASSET_HIERARCHY_PURPOSE
TABLE - FA.FA_ASSET_HIERARCHY_VALUES
TABLE - FA.FA_ASSET_HISTORY
TABLE - FA.FA_ASSET_INVOICES
TABLE - FA.FA_ASSET_KEYWORDS
TABLE - FA.FA_ASSET_LISTING_REP_ITF
TABLE - FA.FA_BALANCES_REPORT
TABLE - FA.FA_BALANCES_REP_ITF
TABLE - FA.FA_BONUS_RATES
TABLE - FA.FA_BONUS_RULES
TABLE - FA.FA_BOOKS
TABLE - FA.FA_BOOKS_GROUPS
TABLE - FA.FA_BOOKS_SUMMARY
TABLE - FA.FA_BOOKS_SUMMARY_T
TABLE - FA.FA_BOOK_CONTROLS
TABLE - FA.FA_BOOK_CONTROLS_HISTORY
TABLE - FA.FA_BUDGET_DISTRIBUTION
TABLE - FA.FA_BUDGET_INTERFACE
TABLE - FA.FA_CALENDAR_PERIODS
TABLE - FA.FA_CALENDAR_TYPES
TABLE - FA.FA_CAPITAL_BUDGET
TABLE - FA.FA_CAP_REP_ITF
TABLE - FA.FA_CASH_GEN_UNITS
TABLE - FA.FA_CATEGORIES_B
TABLE - FA.FA_CATEGORIES_TL
TABLE - FA.FA_CATEGORY_ACCOUNTS_GT
TABLE - FA.FA_CATEGORY_BOOKS
TABLE - FA.FA_CATEGORY_BOOK_DEFAULTS
TABLE - FA.FA_CEILINGS
TABLE - FA.FA_CEILING_TYPES
TABLE - FA.FA_CONVENTIONS
TABLE - FA.FA_CONVENTION_TYPES
TABLE - FA.FA_COSTCLEAR_REP_ITF
TABLE - FA.FA_DEFERRED_DEPRN
TABLE - FA.FA_DEFERRED_DEPRN_EVENTS
TABLE - FA.FA_DELETED_MASS_ADDITIONS
TABLE - FA.FA_DEPRN_BASIS_RULES
TABLE - FA.FA_DEPRN_DETAIL
TABLE - FA.FA_DEPRN_DETAIL_H
TABLE - FA.FA_DEPRN_EVENTS
TABLE - FA.FA_DEPRN_OVERRIDE
TABLE - FA.FA_DEPRN_PERIODS
TABLE - FA.FA_DEPRN_REP_ITF
TABLE - FA.FA_DEPRN_RULE_DETAILS
TABLE - FA.FA_DEPRN_SUMMARY
TABLE - FA.FA_DEPRN_SUMMARY_H
TABLE - FA.FA_DEPRN_TAX_AUTHORITIES
TABLE - FA.FA_DEPRN_TAX_ENTITIES
TABLE - FA.FA_DEPRN_TAX_REP_ITF
TABLE - FA.FA_DEPRN_TAX_REP_NBVS
TABLE - FA.FA_DISTRIBUTION_ACCOUNTS
TABLE - FA.FA_DISTRIBUTION_DEFAULTS
TABLE - FA.FA_DISTRIBUTION_HISTORY
TABLE - FA.FA_DISTRIBUTION_SETS
TABLE - FA.FA_EXCLUDE_HIERARCHY_LEVELS
TABLE - FA.FA_EXT_INV_RETIREMENTS
TABLE - FA.FA_FISCAL_YEAR
TABLE - FA.FA_FLAT_RATES
TABLE - FA.FA_FORMULAS
TABLE - FA.FA_GROUP_ASSETS
TABLE - FA.FA_GROUP_ASSET_DEFAULT
TABLE - FA.FA_GROUP_ASSET_RULES
TABLE - FA.FA_GROUP_DEPRN_DETAIL
TABLE - FA.FA_GROUP_DEPRN_RATES
TABLE - FA.FA_GROUP_DEPRN_SUMMARY
TABLE - FA.FA_GROUP_REP_ITF
TABLE - FA.FA_HIERARCHY_CONTROLS
TABLE - FA.FA_HIERARCHY_DISTRIBUTIONS
TABLE - FA.FA_HIERARCHY_RULE_DETAILS
TABLE - FA.FA_HIERARCHY_RULE_SET
TABLE - FA.FA_HR_RETIREMENT_DETAILS
TABLE - FA.FA_HR_RETIREMENT_HEADERS
TABLE - FA.FA_IMPAIRMENTS
TABLE - FA.FA_INS_LINES
TABLE - FA.FA_INS_MST_POLS
TABLE - FA.FA_INS_POLICIES
TABLE - FA.FA_INS_VALUES
TABLE - FA.FA_INVENTORY
TABLE - FA.FA_INVMISS_REP_ITF
TABLE - FA.FA_INVOICE_TRANSACTIONS
TABLE - FA.FA_INV_COMPARE_REP_ITF
TABLE - FA.FA_INV_INTERFACE
TABLE - FA.FA_ITC_RATES
TABLE - FA.FA_ITC_RECAPTURE_RATES
TABLE - FA.FA_ITF_IMPAIRMENTS
TABLE - FA.FA_JOURNAL_ENTRIES
TABLE - FA.FA_LEASES
TABLE - FA.FA_LEASE_PAYMENTS
TABLE - FA.FA_LEASE_PAYMENT_ITEMS
TABLE - FA.FA_LEASE_SCHEDULES
TABLE - FA.FA_LIFE_DERIVATION_INFO
TABLE - FA.FA_LOCATIONS
TABLE - FA.FA_LOOKUPS_B
TABLE - FA.FA_LOOKUPS_TL
TABLE - FA.FA_LOOKUP_TYPES_B
TABLE - FA.FA_LOOKUP_TYPES_TL
TABLE - FA.FA_MAINT_EVENTS
TABLE - FA.FA_MAINT_REP_ITF
TABLE - FA.FA_MAINT_SCHEDULE_DTL
TABLE - FA.FA_MAINT_SCHEDULE_HDR
TABLE - FA.FA_MASSADD_DISTRIBUTIONS
TABLE - FA.FA_MASSADD_REP_ITF
TABLE - FA.FA_MASS_ADDITIONS
TABLE - FA.FA_MASS_ADDITIONS_GT
TABLE - FA.FA_MASS_CHANGES
TABLE - FA.FA_MASS_CHANGES_ITF
TABLE - FA.FA_MASS_EXTERNAL_TRANSFERS
TABLE - FA.FA_MASS_EXT_RETIREMENTS
TABLE - FA.FA_MASS_EXT_RET_EXCEPTS
TABLE - FA.FA_MASS_RECLASS
TABLE - FA.FA_MASS_RECLASS_ITF
TABLE - FA.FA_MASS_RETIREMENTS
TABLE - FA.FA_MASS_RET_EXCEPTS
TABLE - FA.FA_MASS_REVALUATIONS
TABLE - FA.FA_MASS_REVALUATION_RULES
TABLE - FA.FA_MASS_REVAL_REP_ITF
TABLE - FA.FA_MASS_TAX_ADJUSTMENTS
TABLE - FA.FA_MASS_TAX_ADJ_REP_T
TABLE - FA.FA_MASS_TRANSFERS
TABLE - FA.FA_MASS_UPDATE_BATCH_DETAILS
TABLE - FA.FA_MASS_UPDATE_BATCH_HEADERS
TABLE - FA.FA_MC_ADJUSTMENTS
TABLE - FA.FA_MC_ASSET_INVOICES
TABLE - FA.FA_MC_BOOKS
TABLE - FA.FA_MC_BOOKS_GROUPS
TABLE - FA.FA_MC_BOOKS_RATES
TABLE - FA.FA_MC_BOOKS_SUMMARY
TABLE - FA.FA_MC_BOOK_CONTROLS
TABLE - FA.FA_MC_CONVERSION_HISTORY
TABLE - FA.FA_MC_CONVERSION_RATES
TABLE - FA.FA_MC_DEFERRED_DEPRN
TABLE - FA.FA_MC_DEPRN_DETAIL
TABLE - FA.FA_MC_DEPRN_DETAIL_H
TABLE - FA.FA_MC_DEPRN_PERIODS
TABLE - FA.FA_MC_DEPRN_SUMMARY
TABLE - FA.FA_MC_DEPRN_SUMMARY_H
TABLE - FA.FA_MC_GROUP_DEPRN_DETAIL
TABLE - FA.FA_MC_GROUP_DEPRN_SUMMARY
TABLE - FA.FA_MC_IMPAIRMENTS
TABLE - FA.FA_MC_ITF_IMPAIRMENTS
TABLE - FA.FA_MC_MASS_RATES
TABLE - FA.FA_MC_RETIREMENTS
TABLE - FA.FA_METHODS
TABLE - FA.FA_PARALLEL_WORKERS
TABLE - FA.FA_PERIODIC_PRODUCTION
TABLE - FA.FA_PERIOD_MAPS
TABLE - FA.FA_PLSQL_DEBUG
TABLE - FA.FA_PRICE_INDEXES
TABLE - FA.FA_PRICE_INDEX_VALUES
TABLE - FA.FA_PRODUCTION_INTERFACE
TABLE - FA.FA_PROJECT_REP_ITF
TABLE - FA.FA_PROPTAX_REP_ITF
TABLE - FA.FA_RATES
TABLE - FA.FA_RECLASS_REP_ITF
TABLE - FA.FA_RESERVE_LEDGER
TABLE - FA.FA_RETIREMENTS
TABLE - FA.FA_RETIRE_REP_ITF
TABLE - FA.FA_RX_ATTRSETS_B
TABLE - FA.FA_RX_ATTRSETS_TL
TABLE - FA.FA_RX_DYNAMIC_COLUMNS
TABLE - FA.FA_RX_LOV
TABLE - FA.FA_RX_MULTIFORMAT_REPS
TABLE - FA.FA_RX_REPORTS
TABLE - FA.FA_RX_REP_COLUMNS_B
TABLE - FA.FA_RX_REP_COLUMNS_TL
TABLE - FA.FA_RX_REP_PARAMETERS
TABLE - FA.FA_RX_SECURITY
TABLE - FA.FA_RX_SUMMARY_TL
TABLE - FA.FA_SHORT_TAX_RESERVES
TABLE - FA.FA_SUPER_GROUPS
TABLE - FA.FA_SUPER_GROUP_RULES
TABLE - FA.FA_SYSTEM_CONTROLS
TABLE - FA.FA_TAX_INTERFACE
TABLE - FA.FA_TAX_REPORT
TABLE - FA.FA_TRANSACTION_HEADERS
TABLE - FA.FA_TRANSACTION_INTERFACE
TABLE - FA.FA_TRANSFER_DETAILS
TABLE - FA.FA_TRANSFER_REP_ITF
TABLE - FA.FA_TRX_REFERENCES
TABLE - FA.FA_WARRANTIES
TABLE - FA.FA_WHATIF_ITF
TABLE - FA.FA_WORKER_JOBS
TABLE - FA.FA_XLA_EXT_HEADERS_B_GT
TABLE - FA.FA_XLA_EXT_LINES_B_GT
TABLE - FA.FA_XLA_EXT_LINES_STG_GT
TABLE - FA.FA_XLA_EXT_LINES_TL_GT
VIEW - APPS.FABV_ACCT_PRDS
VIEW - APPS.FABV_ASSETS
VIEW - APPS.FABV_ASSET_ASSIGNS
VIEW - APPS.FABV_ASSET_BKS
VIEW - APPS.FABV_ASSET_CATS
VIEW - APPS.FABV_ASSET_LEASES
VIEW - APPS.FABV_ASSET_LOCS
VIEW - APPS.FABV_BOOKS
VIEW - APPS.FABV_DEPRECIATIONS
VIEW - APPS.FABV_SRC_LNS
VIEW - APPS.FABV_TRANS_HDRS
VIEW - APPS.FABV_TRANS_LINES
VIEW - APPS.FAFV_ACCT_PRDS
VIEW - APPS.FAFV_ASSETS
VIEW - APPS.FAFV_ASSET_ASSIGNS
VIEW - APPS.FAFV_ASSET_BKS
VIEW - APPS.FAFV_ASSET_CATS
VIEW - APPS.FAFV_ASSET_LEASES
VIEW - APPS.FAFV_ASSET_LOCS
VIEW - APPS.FAFV_BOOKS
VIEW - APPS.FAFV_DEPRECIATIONS
VIEW - APPS.FAFV_SRC_LNS
VIEW - APPS.FAFV_TRANS_HDRS
VIEW - APPS.FAFV_TRANS_LINES
VIEW - APPS.FA_ADDITIONS_ASSET_V
VIEW - APPS.FA_ADDITIONS_NON_SEC_VL
VIEW - APPS.FA_ADDITIONS_V
VIEW - APPS.FA_ADDITIONS_VL
VIEW - APPS.FA_ADDITIONS_WEB_V
VIEW - APPS.FA_ADD_INVOICE_WEB_V
VIEW - APPS.FA_ADJUSTMENTS_MRC_V
VIEW - APPS.FA_AEL_GL_V
VIEW - APPS.FA_AEL_SL_MRC_V
VIEW - APPS.FA_AEL_SL_V
VIEW - APPS.FA_ASSET_DISTRIBUTION_V
VIEW - APPS.FA_ASSET_HIERARCHY_PURPOSE_V
VIEW - APPS.FA_ASSET_HIERARCHY_V
VIEW - APPS.FA_ASSET_HIERARCHY_VALUES_V
VIEW - APPS.FA_ASSET_HISTORY_V
VIEW - APPS.FA_ASSET_HIST_WEB_V
VIEW - APPS.FA_ASSET_HRCHY_DETAILS_V
VIEW - APPS.FA_ASSET_INVOICES_MRC_V
VIEW - APPS.FA_ASSET_INVOICES_V
VIEW - APPS.FA_ASSET_V
VIEW - APPS.FA_BOOKS_BK_CNTRL_WEB_V
VIEW - APPS.FA_BOOKS_BOOK_CONTROLS_V
VIEW - APPS.FA_BOOKS_GROUPS_MRC_V
VIEW - APPS.FA_BOOKS_GROUPS_V
VIEW - APPS.FA_BOOKS_GROUPS_V1
VIEW - APPS.FA_BOOKS_MRC_V
VIEW - APPS.FA_BOOKS_SUMMARY_MRC_V
VIEW - APPS.FA_BOOKS_V
VIEW - APPS.FA_BOOK_CONTROLS_MRC_V
VIEW - APPS.FA_CAPITALIZE_CIP_V
VIEW - APPS.FA_CATEGORIES_VL
VIEW - APPS.FA_CHILD_ASSETS_V
VIEW - APPS.FA_CURR_DEPRN_ADJ_V
VIEW - APPS.FA_DEFERRED_DEPRN_EVENTS_V
VIEW - APPS.FA_DEFERRED_DEPRN_MRC_V
VIEW - APPS.FA_DEPRN_DETAIL_H_MRC_V
VIEW - APPS.FA_DEPRN_DETAIL_MRC_V
VIEW - APPS.FA_DEPRN_EVENTS_V
VIEW - APPS.FA_DEPRN_GROUPS_V
VIEW - APPS.FA_DEPRN_GROUPS_V1
VIEW - APPS.FA_DEPRN_OVERRIDE_V
VIEW - APPS.FA_DEPRN_PERIODS_MRC_V
VIEW - APPS.FA_DEPRN_SUMMARY_H_MRC_V
VIEW - APPS.FA_DEPRN_SUMMARY_MRC_V
VIEW - APPS.FA_DEPRN_WEB_V
VIEW - APPS.FA_DISTRIBUTION_HISTORY_V
VIEW - APPS.FA_DISTRIBUTION_HIST_WEB_V
VIEW - APPS.FA_DISTRIBUTION_INQUIRY_V
VIEW - APPS.FA_DISTRIBUTION_INQ_WEB_V
VIEW - APPS.FA_EMPLOYEES
VIEW - APPS.FA_EMP_ASSET_WEB_V
VIEW - APPS.FA_EXTENDED_DEPRN_V
VIEW - APPS.FA_FINANCIAL_INQUIRY_COST_V
VIEW - APPS.FA_FINANCIAL_INQUIRY_DEPRN_V
VIEW - APPS.FA_FINANCIAL_INQUIRY_UPL_V
VIEW - APPS.FA_FIN_INQRY_COST_WEB_V
VIEW - APPS.FA_FIN_INQRY_DEPRN_WEB_V
VIEW - APPS.FA_FIN_INQRY_UPL_WEB_V
VIEW - APPS.FA_FUTURE_MASS_ADDITIONS_V
VIEW - APPS.FA_GROUP_COST_INQUIRY_V
VIEW - APPS.FA_GROUP_DEPRN_DETAIL_MRC_V
VIEW - APPS.FA_GROUP_DEPRN_SUMMARY_MRC_V
VIEW - APPS.FA_HIERARCHY_BATCH_DETAILS_V
VIEW - APPS.FA_HIERARCHY_BATCH_HEADER_V
VIEW - APPS.FA_HIERARCHY_DISTRIBUTIONS_V
VIEW - APPS.FA_HIERARCHY_RULE_DETAILS_V
VIEW - APPS.FA_HR_BATCH_DIST_NEW_V
VIEW - APPS.FA_HR_BATCH_DIST_OLD_V
VIEW - APPS.FA_HR_RETIREMENT_DETAILS_V
VIEW - APPS.FA_HR_RETIREMENT_HEADERS_V
VIEW - APPS.FA_IMPAIRMENTS_MRC_V
VIEW - APPS.FA_INS_ADDITIONS_V
VIEW - APPS.FA_INS_LINES_V
VIEW - APPS.FA_INS_MST_POLS_V
VIEW - APPS.FA_INS_POLICIES_V
VIEW - APPS.FA_INVENTORY_V
VIEW - APPS.FA_INVOICE_DETAILS_V
VIEW - APPS.FA_INVOICE_DETAILS_WEB_V
VIEW - APPS.FA_INVOICE_TRANSFERS_V
VIEW - APPS.FA_INV_INTERFACE_V
VIEW - APPS.FA_ITF_IMPAIRMENTS_MRC_V
VIEW - APPS.FA_LEASES_V
VIEW - APPS.FA_LEASES_WEB_V
VIEW - APPS.FA_LEASE_PAYMENT_ITEMS_V
VIEW - APPS.FA_LOOKUPS_VL
VIEW - APPS.FA_LOOKUP_TYPES_VL
VIEW - APPS.FA_MASS_ADDITIONS_V
VIEW - APPS.FA_MASS_EXTERNAL_TRANSFERS_V
VIEW - APPS.FA_MASS_EXT_RETIREMENTS_V
VIEW - APPS.FA_MUPD_V
VIEW - APPS.FA_PRRUN_PERIODS_V
VIEW - APPS.FA_QUICK_ADDITIONS_V
VIEW - APPS.FA_QUICK_BOOKS_V
VIEW - APPS.FA_QUICK_DISTRIBUTIONS_V
VIEW - APPS.FA_RESERVE_TRANSFERS_V
VIEW - APPS.FA_RETIRED_ASSET_WEB_V
VIEW - APPS.FA_RETIREMENTS_MRC_V
VIEW - APPS.FA_RETIREMENTS_V
VIEW - APPS.FA_RETIREMENTS_WEB_V
VIEW - APPS.FA_RETIREMENT_ADJUSTMENTS_V
VIEW - APPS.FA_RETIREMENT_REQUESTS_V
VIEW - APPS.FA_RX_ATTRSETS_VL
VIEW - APPS.FA_RX_CR_REPORTS_V
VIEW - APPS.FA_RX_NOCR_REPORTS_V
VIEW - APPS.FA_RX_REPORTS_V
VIEW - APPS.FA_RX_REP_COLUMNS_VL
VIEW - APPS.FA_RX_REP_PARAMETERS_V
VIEW - APPS.FA_RX_SUMMARY_VL
VIEW - APPS.FA_SOURCE_LINES_V
VIEW - APPS.FA_SXL_BOOKS_V
VIEW - APPS.FA_TRANSACTIONS_V
VIEW - APPS.FA_TRANSACTION_HEADERS_V
VIEW - APPS.FA_TRANSACTION_HISTORY_BOOKS_V
VIEW - APPS.FA_TRANSACTION_HISTORY_TRX_V
VIEW - APPS.FA_TRANSFER_INVOICES_V
VIEW - APPS.FA_TRANS_HIST_BOOKS_WEB_V
VIEW - APPS.FA_TRANS_HIST_TRX_WEB_V
VIEW - APPS.FA_UNPLANNED_DEPR_V

Table: FA_ACE_BOOKS

Description: Financial information for updating ACE book
Primary Key: FA_ACE_BOOKS_PK
  1. ASSET_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_ACE_BOOKS.ASSET_ID FA_ADDITIONS_B
FA_ACE_BOOKS.DEPRN_METHOD_CODE
FA_ACE_BOOKS.LIFE_IN_MONTHS 		FA_METHODS
FA_ACE_BOOKS.PRORATE_CONVENTION_CODE FA_CONVENTION_TYPES

[top of page]

FA.FA_ACE_BOOKS does not reference any database object

FA.FA_ACE_BOOKS is referenced by following:

APPS
SYNONYM - FA_ACE_BOOKS

[top of page]

Table: FA_ADDITIONS_B

Description: Descriptive information about assets (base MLS table)
Primary Key: FA_ADDITIONS_B_PK
  1. ASSET_ID
Primary Key: FA_ADDITIONS_B_UK1
  1. ASSET_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_ADDITIONS_B.ASSET_CATEGORY_ID FA_CATEGORIES_B
FA_ADDITIONS_B.PARENT_ASSET_ID FA_ADDITIONS_B
FA_ADDITIONS_B.LEASE_ID FA_LEASES
FA_ADDITIONS_B.ASSET_KEY_CCID FA_ASSET_KEYWORDS
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSI_I_ASSETS.FA_ASSET_ID FA_ADDITIONS_B
FA_ACE_BOOKS.ASSET_ID FA_ADDITIONS_B
FA_MASSADD_REP_ITF.GROUP_ASSET_NUMBER FA_ADDITIONS_B
FA_ADDITIONS_B.PARENT_ASSET_ID FA_ADDITIONS_B
FA_ADDITION_REP_ITF.GROUP_ASSET_NUMBER FA_ADDITIONS_B
FA_ADD_WARRANTIES.ASSET_ID FA_ADDITIONS_B
FA_ADJUSTMENTS.ASSET_ID FA_ADDITIONS_B
FA_ADJUST_REP_ITF.GROUP_ASSET_NUMBER FA_ADDITIONS_B
FA_ASSET_HISTORY.ASSET_ID FA_ADDITIONS_B
FA_ASSET_INVOICES.ASSET_ID FA_ADDITIONS_B
FA_BALANCES_REP_ITF.GROUP_ASSET_NUMBER FA_ADDITIONS_B
FA_BOOKS.ASSET_ID FA_ADDITIONS_B
FA_BOOKS_SUMMARY.ASSET_ID FA_ADDITIONS_B
FA_BOOKS_SUMMARY.GROUP_ASSET_ID FA_ADDITIONS_B
FA_CAPITAL_BUDGET.ASSET_ID FA_ADDITIONS_B
FA_CATEGORY_BOOK_DEFAULTS.GROUP_ASSET_ID FA_ADDITIONS_B
FA_DEFERRED_DEPRN.ASSET_ID FA_ADDITIONS_B
FA_DEPRN_DETAIL.ASSET_ID FA_ADDITIONS_B
FA_DEPRN_OVERRIDE.ASSET_ID FA_ADDITIONS_B
FA_DEPRN_REP_ITF.GROUP_ASSET_NUMBER FA_ADDITIONS_B
FA_DEPRN_SUMMARY.ASSET_ID FA_ADDITIONS_B
FA_DISTRIBUTION_HISTORY.ASSET_ID FA_ADDITIONS_B
FA_INS_LINES.ASSET_ID FA_ADDITIONS_B
FA_INS_POLICIES.ASSET_ID FA_ADDITIONS_B
FA_INS_VALUES.ASSET_ID FA_ADDITIONS_B
FA_MAINT_EVENTS.ASSET_ID FA_ADDITIONS_B
FA_MAINT_SCHEDULE_HDR.FROM_ASSET_NUMBER FA_ADDITIONS_B
FA_MAINT_SCHEDULE_HDR.TO_ASSET_NUMBER FA_ADDITIONS_B
FA_ADDITIONS_B
FA_MASS_ADDITIONS.ADD_TO_ASSET_ID FA_ADDITIONS_B
FA_MASS_ADDITIONS.ASSET_NUMBER FA_ADDITIONS_B
FA_ADDITIONS_B
FA_ADDITIONS_B
FA_MASS_ADDITIONS.PARENT_ASSET_ID FA_ADDITIONS_B
FA_MASS_CHANGES.FROM_GROUP_ASSET_ID FA_ADDITIONS_B
FA_MASS_CHANGES.TO_GROUP_ASSET_ID FA_ADDITIONS_B
FA_MASS_CHANGES.FROM_ASSET_NUMBER FA_ADDITIONS_B
FA_MASS_CHANGES.TO_ASSET_NUMBER FA_ADDITIONS_B
FA_MASS_CHANGES_ITF.FROM_GROUP_ASSET_NUMBER FA_ADDITIONS_B
FA_MASS_CHANGES_ITF.TO_GROUP_ASSET_NUMBER FA_ADDITIONS_B
FA_MASS_CHANGES_ITF.ASSET_ID FA_ADDITIONS_B
FA_MASS_CHANGES_ITF.ASSET_NUMBER FA_ADDITIONS_B
FA_MASS_RECLASS.FROM_ASSET_NUMBER FA_ADDITIONS_B
FA_MASS_RECLASS.TO_ASSET_NUMBER FA_ADDITIONS_B
FA_MASS_RECLASS_ITF.ASSET_ID FA_ADDITIONS_B
FA_MASS_RECLASS_ITF.ASSET_NUMBER FA_ADDITIONS_B
FA_MASS_RETIREMENTS.FROM_ASSET_NUMBER FA_ADDITIONS_B
FA_MASS_RETIREMENTS.TO_ASSET_NUMBER FA_ADDITIONS_B
FA_MASS_REVALUATION_RULES.ASSET_ID FA_ADDITIONS_B
FA_MASS_REVAL_REP_ITF.ASSET_ID FA_ADDITIONS_B
FA_MASS_REVAL_REP_ITF.ASSET_NUMBER FA_ADDITIONS_B
FA_MASS_TAX_ADJ_REP_T.ASSET_ID FA_ADDITIONS_B
FA_MASS_TAX_ADJ_REP_T.ASSET_NUMBER FA_ADDITIONS_B
FA_MC_ADJUSTMENTS.ASSET_ID FA_ADDITIONS_B
FA_MC_ASSET_INVOICES.ASSET_ID FA_ADDITIONS_B
FA_MC_BOOKS.ASSET_ID FA_ADDITIONS_B
FA_MC_BOOKS_RATES.ASSET_ID FA_ADDITIONS_B
FA_MC_CONVERSION_RATES.ASSET_ID FA_ADDITIONS_B
FA_MC_DEFERRED_DEPRN.ASSET_ID FA_ADDITIONS_B
FA_MC_DEPRN_DETAIL.ASSET_ID FA_ADDITIONS_B
FA_MC_DEPRN_SUMMARY.ASSET_ID FA_ADDITIONS_B
FA_MC_RETIREMENTS.ASSET_ID FA_ADDITIONS_B
FA_MC_RETIREMENTS.TRADE_IN_ASSET_ID FA_ADDITIONS_B
FA_PARALLEL_WORKERS.ASSET_ID FA_ADDITIONS_B
FA_PARALLEL_WORKERS.PARENT_ASSET_ID FA_ADDITIONS_B
FA_PARALLEL_WORKERS.OLD_GROUP_ASSET_ID FA_ADDITIONS_B
FA_PARALLEL_WORKERS.NEW_GROUP_ASSET_ID FA_ADDITIONS_B
FA_PERIODIC_PRODUCTION.ASSET_ID FA_ADDITIONS_B
FA_RESERVE_LEDGER.ASSET_ID FA_ADDITIONS_B
FA_RETIREMENTS.ASSET_ID FA_ADDITIONS_B
FA_RETIREMENTS.TRADE_IN_ASSET_ID FA_ADDITIONS_B
FA_RETIRE_REP_ITF.GROUP_ASSET_NUMBER FA_ADDITIONS_B
FA_SHORT_TAX_RESERVES.ASSET_NUMBER FA_ADDITIONS_B
FA_TAX_INTERFACE.ASSET_NUMBER FA_ADDITIONS_B
FA_TAX_INTERFACE.GROUP_ASSET_ID FA_ADDITIONS_B
FA_TRANSACTION_HEADERS.ASSET_ID FA_ADDITIONS_B
FA_TRX_REFERENCES.SRC_ASSET_ID FA_ADDITIONS_B
FA_TRX_REFERENCES.DEST_ASSET_ID FA_ADDITIONS_B
FA_TRX_REFERENCES.MEMBER_ASSET_ID FA_ADDITIONS_B
IA_REQUEST_DETAILS.ASSET_ID FA_ADDITIONS_B
JAI_FA_AST_BLOCK_DTLS.ASSET_ID FA_ADDITIONS_B
JAI_FA_DEP_BLOCKS_T.ASSET_ID FA_ADDITIONS_B
JA_AU_BAL_CHG_APPLIED.ASSET_ID FA_ADDITIONS_B
JA_AU_BAL_CHG_SOURCE.ASSET_ID FA_ADDITIONS_B
JA_AU_CAPITAL_VALUE.ASSET_ID FA_ADDITIONS_B
JA_AU_SRW_TAX_DEPRN_TMP.ASSET_ID FA_ADDITIONS_B
JL_CO_FA_ADJUSTMENTS.ASSET_ID FA_ADDITIONS_B
JL_MX_FA_ISR_IMPAC.ASSET_ID FA_ADDITIONS_B
OKL_EXT_FA_LINE_SOURCES_B.ASSET_ID FA_ADDITIONS_B
PA_PROJECT_ASSETS_ALL.PARENT_ASSET_ID FA_ADDITIONS_B
PA_PROJECT_ASSETS_ALL.RET_TARGET_ASSET_ID FA_ADDITIONS_B
PA_PROJECT_ASSETS_ALL.FA_ASSET_ID FA_ADDITIONS_B

[top of page]

FA.FA_ADDITIONS_B does not reference any database object

FA.FA_ADDITIONS_B is referenced by following:

APPS
SYNONYM - FA_ADDITIONS_B

[top of page]

Table: FA_ADDITIONS_TL

Description: Descriptive information about assets (translated MLS table)
Primary Key: FA_ADDITIONS_TL_PK
  1. ASSET_ID
  2. LANGUAGE

[top of page]

FA.FA_ADDITIONS_TL does not reference any database object

FA.FA_ADDITIONS_TL is referenced by following:

APPS
SYNONYM - FA_ADDITIONS_TL

[top of page]

Table: FA_ADDITION_REP_ITF

Description: Interface table for Report eXchange reports
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_ADDITION_REP_ITF.GROUP_ASSET_NUMBER FA_ADDITIONS_B

[top of page]

FA.FA_ADDITION_REP_ITF does not reference any database object

FA.FA_ADDITION_REP_ITF is referenced by following:

APPS
SYNONYM - FA_ADDITION_REP_ITF

[top of page]

Table: FA_ADD_WARRANTIES

Description: Warranty information
Primary Key: FA_ADD_WARRANTIES_PK
  1. WARRANTY_ID
  2. ASSET_ID
  3. DATE_EFFECTIVE
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_ADD_WARRANTIES.WARRANTY_ID FA_WARRANTIES
FA_ADD_WARRANTIES.ASSET_ID FA_ADDITIONS_B

[top of page]

FA.FA_ADD_WARRANTIES does not reference any database object

FA.FA_ADD_WARRANTIES is referenced by following:

APPS
SYNONYM - FA_ADD_WARRANTIES

[top of page]

Table: FA_ADJUSTMENTS

Description: Information used by the posting program to generate journal entry lines in the general ledger
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_ADJUSTMENTS.TRANSACTION_HEADER_ID FA_TRANSACTION_HEADERS
FA_ADJUSTMENTS.DISTRIBUTION_ID FA_DISTRIBUTION_HISTORY
FA_ADJUSTMENTS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_ADJUSTMENTS.ASSET_ID FA_ADDITIONS_B
FA_ADJUSTMENTS.CODE_COMBINATION_ID GL_CODE_COMBINATIONS
FA_ADJUSTMENTS.JE_HEADER_ID
FA_ADJUSTMENTS.JE_LINE_NUM 		GL_JE_LINES
FA_ADJUSTMENTS.BOOK_TYPE_CODE
FA_ADJUSTMENTS.PERIOD_COUNTER_ADJUSTED 		FA_DEPRN_PERIODS
FA_ADJUSTMENTS.BOOK_TYPE_CODE
FA_ADJUSTMENTS.PERIOD_COUNTER_CREATED 		FA_DEPRN_PERIODS

[top of page]

FA.FA_ADJUSTMENTS does not reference any database object

FA.FA_ADJUSTMENTS is referenced by following:

APPS
SYNONYM - FA_ADJUSTMENTS

[top of page]

Table: FA_ADJUSTMENTS_T

Description: FA_ADJUSTMENTS_T is a temporary table used during processing of impairment transaction and Extended Depreciation.

[top of page]

FA.FA_ADJUSTMENTS_T does not reference any database object

FA.FA_ADJUSTMENTS_T is referenced by following:

APPS
SYNONYM - FA_ADJUSTMENTS_T

[top of page]

Table: FA_ADJUST_REP_ITF

Description: Interface table for Report eXchange reports
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_ADJUST_REP_ITF.GROUP_ASSET_NUMBER FA_ADDITIONS_B

[top of page]

FA.FA_ADJUST_REP_ITF does not reference any database object

FA.FA_ADJUST_REP_ITF is referenced by following:

APPS
SYNONYM - FA_ADJUST_REP_ITF

[top of page]

Table: FA_AMORT_SCHEDULES

Description: Amortization schedules
Primary Key: FA_AMORT_SCHEDULES_PK
  1. PAYMENT_SCHEDULE_ID
  2. AMORTIZATION_LINE_NUM

[top of page]

FA.FA_AMORT_SCHEDULES does not reference any database object

FA.FA_AMORT_SCHEDULES is referenced by following:

APPS
SYNONYM - FA_AMORT_SCHEDULES

[top of page]

Table: FA_ARCHIVE_HISTORY

Description: Archive, purge, and restore request information
Primary Key: FA_ARCHIVE_HISTORY_PK
  1. ARCHIVE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_ARCHIVE_HISTORY.BOOK_TYPE_CODE FA_BOOK_CONTROLS

[top of page]

FA.FA_ARCHIVE_HISTORY does not reference any database object

FA.FA_ARCHIVE_HISTORY is referenced by following:

APPS
SYNONYM - FA_ARCHIVE_HISTORY

[top of page]

Table: FA_ASSET_HIERARCHY

Description: Defines hierarchy nodes and the relationship between them.

[top of page]

FA.FA_ASSET_HIERARCHY does not reference any database object

FA.FA_ASSET_HIERARCHY is referenced by following:

APPS
SYNONYM - FA_ASSET_HIERARCHY

[top of page]

Table: FA_ASSET_HIERARCHY_PURPOSE

Description: Contains Purpose information. This contains rules regarding how the Inheritance Rule Set will be used and whether the relationship between an asset and a node is mandatory or not.

[top of page]

FA.FA_ASSET_HIERARCHY_PURPOSE does not reference any database object

FA.FA_ASSET_HIERARCHY_PURPOSE is referenced by following:

APPS
SYNONYM - FA_ASSET_HIERARCHY_PURPOSE

[top of page]

Table: FA_ASSET_HIERARCHY_VALUES

Description: Stores attribute values associated with a hierarchy node that may be inherited by other nodes.

[top of page]

FA.FA_ASSET_HIERARCHY_VALUES does not reference any database object

FA.FA_ASSET_HIERARCHY_VALUES is referenced by following:

APPS
SYNONYM - FA_ASSET_HIERARCHY_VALUES

[top of page]

Table: FA_ASSET_HISTORY

Description: Historical information about asset reclassifications and unit adjustments
Primary Key: FA_ASSET_HISTORY_PK
  1. ASSET_ID
  2. DATE_EFFECTIVE
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_ASSET_HISTORY.ASSET_ID FA_ADDITIONS_B
FA_ASSET_HISTORY.CATEGORY_ID FA_CATEGORIES_B
FA_ASSET_HISTORY.TRANSACTION_HEADER_ID_IN FA_TRANSACTION_HEADERS
FA_ASSET_HISTORY.TRANSACTION_HEADER_ID_OUT FA_TRANSACTION_HEADERS

[top of page]

FA.FA_ASSET_HISTORY does not reference any database object

FA.FA_ASSET_HISTORY is referenced by following:

APPS
SYNONYM - FA_ASSET_HISTORY

[top of page]

Table: FA_ASSET_INVOICES

Description: Accounts payable and purchasing information for each asset
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_ASSET_INVOICES.ASSET_ID FA_ADDITIONS_B
FA_ASSET_INVOICES.INVOICE_ID AP_INVOICES_ALL
FA_ASSET_INVOICES.INVOICE_ID
FA_ASSET_INVOICES.AP_DISTRIBUTION_LINE_NUMBER 		AP_INVOICE_DISTRIBUTIONS_ALL
FA_ASSET_INVOICES.INVOICE_TRANSACTION_ID_OUT FA_INVOICE_TRANSACTIONS
FA_ASSET_INVOICES.PROJECT_ID PA_PROJECTS_ALL
FA_ASSET_INVOICES.TASK_ID PA_TASKS
FA_ASSET_INVOICES.PROJECT_ASSET_LINE_ID PA_PROJECT_ASSET_LINES_ALL
FA_ASSET_INVOICES.PARENT_MASS_ADDITION_ID FA_MASS_ADDITIONS
FA_ASSET_INVOICES.MERGE_PARENT_MASS_ADDITIONS_ID FA_MASS_ADDITIONS
FA_ASSET_INVOICES.INVOICE_TRANSACTION_ID_IN FA_INVOICE_TRANSACTIONS
FA_ASSET_INVOICES.PO_DISTRIBUTION_ID PO_DISTRIBUTIONS_ALL
FA_ASSET_INVOICES.PO_NUMBER PO_HEADERS_ALL
FA_ASSET_INVOICES.PAYABLES_CODE_COMBINATION_ID GL_CODE_COMBINATIONS
FA_ASSET_INVOICES.CREATE_BATCH_ID FND_CONCURRENT_REQUESTS
FA_ASSET_INVOICES.POST_BATCH_ID FND_CONCURRENT_REQUESTS
FA_ASSET_INVOICES.SPLIT_PARENT_MASS_ADDITIONS_ID FA_MASS_ADDITIONS
FA_ASSET_INVOICES.PO_VENDOR_ID PO_VENDORS

[top of page]

FA.FA_ASSET_INVOICES does not reference any database object

FA.FA_ASSET_INVOICES is referenced by following:

APPS
SYNONYM - FA_ASSET_INVOICES
SYNONYM - FA_ASSET_INVOICES_BAS

[top of page]

Table: FA_ASSET_KEYWORDS

Description: Asset key flexfield segment combinations
Primary Key: FA_ASSET_KEYWORDS_PK
  1. CODE_COMBINATION_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_ADDITIONS_B.ASSET_KEY_CCID FA_ASSET_KEYWORDS
FA_ASSET_KEYWORDS
FA_MASS_ADDITIONS.ASSET_KEY_CCID FA_ASSET_KEYWORDS
FA_MASS_RECLASS.ASSET_KEY_ID FA_ASSET_KEYWORDS

[top of page]

FA.FA_ASSET_KEYWORDS does not reference any database object

FA.FA_ASSET_KEYWORDS is referenced by following:

APPS
SYNONYM - FA_ASSET_KEYWORDS

[top of page]

Table: FA_ASSET_LISTING_REP_ITF

Description: Interface table for Report eXchange reports

[top of page]

FA.FA_ASSET_LISTING_REP_ITF does not reference any database object

FA.FA_ASSET_LISTING_REP_ITF is referenced by following:

APPS
SYNONYM - FA_ASSET_LISTING_REP_ITF

[top of page]

Table: FA_BALANCES_REPORT

Description: Temporary storage area for the balance reports

[top of page]

FA.FA_BALANCES_REPORT does not reference any database object

FA.FA_BALANCES_REPORT is referenced by following:

APPS
SYNONYM - FA_BALANCES_REPORT

[top of page]

Table: FA_BALANCES_REP_ITF

Description: Interface table for Report eXchange reports
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_BALANCES_REP_ITF.GROUP_ASSET_NUMBER FA_ADDITIONS_B

[top of page]

FA.FA_BALANCES_REP_ITF does not reference any database object

FA.FA_BALANCES_REP_ITF is referenced by following:

APPS
SYNONYM - FA_BALANCES_REP_ITF

[top of page]

Table: FA_BONUS_RATES

Description: Bonus rate information used by the Depreciation program
Primary Key: FA_BONUS_RATES_PK
  1. BONUS_RULE
  2. START_YEAR
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_BONUS_RATES.BONUS_RULE FA_BONUS_RULES

[top of page]

FA.FA_BONUS_RATES does not reference any database object

FA.FA_BONUS_RATES is referenced by following:

APPS
SYNONYM - FA_BONUS_RATES

[top of page]

Table: FA_BONUS_RULES

Description: Bonus rule information used by the Depreciation program
Primary Key: FA_BONUS_RULES_PK
  1. BONUS_RULE
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_BONUS_RATES.BONUS_RULE FA_BONUS_RULES
FA_BOOKS.BONUS_RULE FA_BONUS_RULES
FA_BOOKS_SUMMARY.BONUS_RULE FA_BONUS_RULES
FA_MASS_CHANGES_ITF.TO_BONUS_RULE FA_BONUS_RULES
FA_MASS_CHANGES_ITF.FROM_BONUS_RULE FA_BONUS_RULES
FA_MC_BOOKS.BONUS_RULE FA_BONUS_RULES

[top of page]

FA.FA_BONUS_RULES does not reference any database object

FA.FA_BONUS_RULES is referenced by following:

APPS
SYNONYM - FA_BONUS_RULES

[top of page]

Table: FA_BOOKS

Description: Financial information of each asset
Primary Key: FA_BOOKS_PK
  1. TRANSACTION_HEADER_ID_IN
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_BOOKS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_BOOKS.BOOK_TYPE_CODE
FA_BOOKS.PERIOD_COUNTER_FULLY_RESERVED 		FA_DEPRN_PERIODS
FA_BOOKS.BOOK_TYPE_CODE
FA_BOOKS.PERIOD_COUNTER_FULLY_RETIRED 		FA_DEPRN_PERIODS
FA_BOOKS.BOOK_TYPE_CODE
FA_BOOKS.PERIOD_COUNTER_CAPITALIZED 		FA_DEPRN_PERIODS
FA_BOOKS.CEILING_NAME FA_CEILING_TYPES
FA_BOOKS.BOOK_TYPE_CODE
FA_BOOKS.PERIOD_COUNTER_LIFE_COMPLETE 		FA_DEPRN_PERIODS
FA_BOOKS.BONUS_RULE FA_BONUS_RULES
FA_BOOKS.ASSET_ID FA_ADDITIONS_B
FA_BOOKS.SUPER_GROUP_ID FA_SUPER_GROUPS
FA_BOOKS.TRANSACTION_HEADER_ID_IN FA_TRANSACTION_HEADERS
FA_BOOKS.TRANSACTION_HEADER_ID_OUT FA_TRANSACTION_HEADERS
FA_BOOKS.DEPRN_METHOD_CODE
FA_BOOKS.LIFE_IN_MONTHS 		FA_METHODS
FA_BOOKS.PRORATE_CONVENTION_CODE FA_CONVENTION_TYPES
FA_BOOKS.RETIREMENT_ID FA_RETIREMENTS
FA_BOOKS.TAX_REQUEST_ID FND_CONCURRENT_REQUESTS
FA_BOOKS.ITC_AMOUNT_ID FA_ITC_RATES
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_CAPITAL_BUDGET.BOOK_HEADER_ID FA_BOOKS
FA_DISTRIBUTION_HISTORY.TRANSACTION_HEADER_ID_IN FA_BOOKS
FA_TRANSFER_DETAILS.BOOK_HEADER_ID FA_BOOKS

[top of page]

FA.FA_BOOKS does not reference any database object

FA.FA_BOOKS is referenced by following:

APPS
SYNONYM - FA_BOOKS
SYNONYM - FA_BOOKS_BAS
TRIGGER - JL_ZZ_FA_BOOKS_GLOB_FLEX_RL
TRIGGER - JL_ZZ_FA_BOOKS_GLOB_FLEX_SL

[top of page]

Table: FA_BOOKS_GROUPS

Description: Contains financial (cost) information for a group asset within a particular book. This is also a history table.

[top of page]

FA.FA_BOOKS_GROUPS does not reference any database object

FA.FA_BOOKS_GROUPS is referenced by following:

APPS
SYNONYM - FA_BOOKS_GROUPS

[top of page]

Table: FA_BOOKS_SUMMARY

Description: This table stores group assets' periodical financial information
Primary Key: FA_BOOKS_SUMMARY_PK
  1. ASSET_ID
  2. BOOK_TYPE_CODE
  3. PERIOD_COUNTER
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_BOOKS_SUMMARY.ASSET_ID FA_ADDITIONS_B
FA_BOOKS_SUMMARY.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_BOOKS_SUMMARY.BONUS_RULE FA_BONUS_RULES
FA_BOOKS_SUMMARY.CEILING_NAME FA_CEILING_TYPES
FA_BOOKS_SUMMARY.GROUP_ASSET_ID FA_ADDITIONS_B
FA_BOOKS_SUMMARY.SUPER_GROUP_ID FA_SUPER_GROUPS

[top of page]

FA.FA_BOOKS_SUMMARY does not reference any database object

FA.FA_BOOKS_SUMMARY is referenced by following:

APPS
SYNONYM - FA_BOOKS_SUMMARY

[top of page]

Table: FA_BOOKS_SUMMARY_T

Description:
Primary Key: FA_BOOKS_SUMMARY_T_PK
  1. BOOK_TYPE_CODE
  2. ASSET_ID
  3. PERIOD_COUNTER

[top of page]

FA.FA_BOOKS_SUMMARY_T does not reference any database object

FA.FA_BOOKS_SUMMARY_T is referenced by following:

APPS
SYNONYM - FA_BOOKS_SUMMARY_T

[top of page]

Table: FA_BOOK_CONTROLS

Description: Control information that affects all assets in a depreciation book
Primary Key: FA_BOOK_CONTROLS_PK
  1. BOOK_TYPE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_BOOK_CONTROLS.DEPRN_CALENDAR FA_CALENDAR_TYPES
FA_BOOK_CONTROLS.JE_RETIREMENT_CATEGORY GL_JE_CATEGORIES_TL
FA_BOOK_CONTROLS.JE_DEPRECIATION_CATEGORY GL_JE_CATEGORIES_TL
FA_BOOK_CONTROLS.JE_RECLASS_CATEGORY GL_JE_CATEGORIES_TL
FA_BOOK_CONTROLS.JE_ADDITION_CATEGORY GL_JE_CATEGORIES_TL
FA_BOOK_CONTROLS.JE_ADJUSTMENT_CATEGORY GL_JE_CATEGORIES_TL
FA_BOOK_CONTROLS.JE_TRANSFER_CATEGORY GL_JE_CATEGORIES_TL
FA_BOOK_CONTROLS.JE_DEFERRED_DEPRN_CATEGORY GL_JE_CATEGORIES_TL
FA_BOOK_CONTROLS.JE_CIP_ADJUSTMENT_CATEGORY GL_JE_CATEGORIES_TL
FA_BOOK_CONTROLS.JE_CIP_ADDITION_CATEGORY GL_JE_CATEGORIES_TL
FA_BOOK_CONTROLS.JE_CIP_RECLASS_CATEGORY GL_JE_CATEGORIES_TL
FA_BOOK_CONTROLS.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
FA_BOOK_CONTROLS.JE_CIP_RETIREMENT_CATEGORY GL_JE_CATEGORIES_TL
FA_BOOK_CONTROLS.JE_CIP_REVAL_CATEGORY GL_JE_CATEGORIES_TL
FA_BOOK_CONTROLS.JE_CIP_TRANSFER_CATEGORY GL_JE_CATEGORIES_TL
FA_BOOK_CONTROLS.JE_REVAL_CATEGORY GL_JE_CATEGORIES_TL
FA_BOOK_CONTROLS.JE_DEPRN_ADJUSTMENT_CATEGORY GL_JE_CATEGORIES_TL
FA_BOOK_CONTROLS.MASS_COPY_SOURCE_BOOK FA_BOOK_CONTROLS
FA_BOOK_CONTROLS.MASS_REQUEST_ID FND_CONCURRENT_REQUESTS
FA_BOOK_CONTROLS.FLEXBUILDER_DEFAULTS_CCID GL_CODE_COMBINATIONS
FA_BOOK_CONTROLS.DISTRIBUTION_SOURCE_BOOK FA_BOOK_CONTROLS
FA_BOOK_CONTROLS.BOOK_TYPE_CODE
FA_BOOK_CONTROLS.LAST_PURGE_PERIOD_COUNTER 		FA_DEPRN_PERIODS
FA_BOOK_CONTROLS.CREATE_ACCOUNTING_REQUEST_ID FND_CONCURRENT_REQUESTS
FA_BOOK_CONTROLS.BOOK_TYPE_CODE
FA_BOOK_CONTROLS.INITIAL_PERIOD_COUNTER 		FA_DEPRN_PERIODS
FA_BOOK_CONTROLS.BOOK_TYPE_CODE
FA_BOOK_CONTROLS.LAST_PERIOD_COUNTER 		FA_DEPRN_PERIODS
FA_BOOK_CONTROLS.BOOK_TYPE_CODE
FA_BOOK_CONTROLS.LAST_MASS_COPY_PERIOD_COUNTER 		FA_DEPRN_PERIODS
FA_BOOK_CONTROLS.PRORATE_CALENDAR FA_CALENDAR_TYPES
FA_BOOK_CONTROLS.DEPRN_REQUEST_ID FND_CONCURRENT_REQUESTS
FA_BOOK_CONTROLS.CURRENT_FISCAL_YEAR
FA_BOOK_CONTROLS.FISCAL_YEAR_NAME 		FA_FISCAL_YEAR
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSI_I_ASSETS.FA_BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_ADJUSTMENTS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_ARCHIVE_HISTORY.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_BOOKS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_BOOKS_SUMMARY.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_BOOK_CONTROLS.MASS_COPY_SOURCE_BOOK FA_BOOK_CONTROLS
FA_BOOK_CONTROLS.DISTRIBUTION_SOURCE_BOOK FA_BOOK_CONTROLS
FA_BUDGET_DISTRIBUTION.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_BOOK_CONTROLS
FA_CATEGORY_BOOKS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_CATEGORY_BOOK_DEFAULTS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_DEFERRED_DEPRN.CORP_BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_DEFERRED_DEPRN.TAX_BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_DELETED_MASS_ADDITIONS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_DEPRN_DETAIL.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_DEPRN_OVERRIDE.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_DEPRN_PERIODS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_DEPRN_SUMMARY.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_DISTRIBUTION_ACCOUNTS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_DISTRIBUTION_HISTORY.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_DISTRIBUTION_SETS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_INS_POLICIES.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_INVOICE_TRANSACTIONS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MAINT_EVENTS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MAINT_SCHEDULE_HDR.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_BOOK_CONTROLS
FA_MASS_ADDITIONS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MASS_CHANGES.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MASS_CHANGES_ITF.BOOK FA_BOOK_CONTROLS
FA_MASS_RECLASS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MASS_RECLASS_ITF.BOOK FA_BOOK_CONTROLS
FA_MASS_RETIREMENTS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MASS_REVALUATIONS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MASS_REVAL_REP_ITF.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MASS_TAX_ADJUSTMENTS.ADJUSTED_BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MASS_TAX_ADJUSTMENTS.CONTROL_BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MASS_TRANSFERS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MC_ADJUSTMENTS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MC_BOOKS_RATES.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MC_BOOK_CONTROLS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MC_CONVERSION_HISTORY.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MC_CONVERSION_RATES.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MC_DEFERRED_DEPRN.CORP_BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MC_DEFERRED_DEPRN.TAX_BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MC_DEPRN_DETAIL.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MC_DEPRN_PERIODS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MC_DEPRN_SUMMARY.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_PARALLEL_WORKERS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_PERIODIC_PRODUCTION.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_RETIREMENTS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_SHORT_TAX_RESERVES.TAX_BOOK FA_BOOK_CONTROLS
FA_TAX_INTERFACE.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_TRANSACTION_HEADERS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_TRANSACTION_INTERFACE.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_TRX_REFERENCES.BOOK_TYPE_CODE FA_BOOK_CONTROLS
IA_REQUEST_DETAILS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
IA_REQUEST_HEADERS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
JA_AU_BAL_CHG_APPLIED.BOOK_TYPE_CODE FA_BOOK_CONTROLS
JA_AU_BAL_CHG_INTERFACE.BOOK_TYPE_CODE FA_BOOK_CONTROLS
JA_AU_BAL_CHG_SOURCE.BOOK_TYPE_CODE FA_BOOK_CONTROLS
JA_AU_CAPITAL_VALUE.BOOK_TYPE_CODE FA_BOOK_CONTROLS
JA_AU_FA_BOOK_CONTROLS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
JL_CO_FA_ADJUSTMENTS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
JL_CO_FA_APPRAISAL_BOOKS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
JL_CO_FA_PURGE.BOOK_TYPE_CODE FA_BOOK_CONTROLS
PA_IMPLEMENTATIONS_ALL.BOOK_TYPE_CODE FA_BOOK_CONTROLS
PA_STANDARD_UNIT_COSTS.BOOK_TYPE_CODE FA_BOOK_CONTROLS

[top of page]

FA.FA_BOOK_CONTROLS does not reference any database object

FA.FA_BOOK_CONTROLS is referenced by following:

APPS
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_BOOK_CONTROLS_BAS
SYNONYM - FA_BOOK_CONTROLS_SEC
TRIGGER - IGI_MHC_FA_BOOK_CONTROLS_T1

[top of page]

Table: FA_BOOK_CONTROLS_HISTORY

Description: Tracks changes to book setup information in Oracle Assets
Primary Key: FA_BOOK_CONTROLS_HISTORY_PK
  1. BOOK_TYPE_CODE
  2. DATE_ACTIVE

[top of page]

FA.FA_BOOK_CONTROLS_HISTORY does not reference any database object

FA.FA_BOOK_CONTROLS_HISTORY is referenced by following:

APPS
SYNONYM - FA_BOOK_CONTROLS_HISTORY

[top of page]

Table: FA_BUDGET_DISTRIBUTION

Description: Capital budget information entered manually or uploaded from the FA_BUDGET_INTERFACE table
Primary Key: FA_BUDGET_DISTRIBUTION_PK
  1. BUDGET_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_BUDGET_DISTRIBUTION.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_BUDGET_DISTRIBUTION.CATEGORY_ID FA_CATEGORIES_B
FA_BUDGET_DISTRIBUTION.CODE_COMBINATION_ID GL_CODE_COMBINATIONS
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_CAPITAL_BUDGET.BUDGET_ID FA_BUDGET_DISTRIBUTION

[top of page]

FA.FA_BUDGET_DISTRIBUTION does not reference any database object

FA.FA_BUDGET_DISTRIBUTION is referenced by following:

APPS
SYNONYM - FA_BUDGET_DISTRIBUTION

[top of page]

Table: FA_BUDGET_INTERFACE

Description: Capital budget information to be uploaded into Oracle Assets
Primary Key: FA_BUDGET_INTERFACE_PK
  1. BOOK_TYPE_CODE
  2. CAT_SEGMENT1
  3. CAT_SEGMENT2
  4. CAT_SEGMENT3
  5. CAT_SEGMENT4
  6. CAT_SEGMENT5
  7. CAT_SEGMENT6
  8. CAT_SEGMENT7

[top of page]

FA.FA_BUDGET_INTERFACE does not reference any database object

FA.FA_BUDGET_INTERFACE is referenced by following:

APPS
SYNONYM - FA_BUDGET_INTERFACE

[top of page]

Table: FA_CALENDAR_PERIODS

Description: Detailed calendar information
Primary Key: FA_CALENDAR_PERIODS_PK
  1. CALENDAR_TYPE
  2. PERIOD_NUM
  3. START_DATE
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_CALENDAR_PERIODS.CALENDAR_TYPE FA_CALENDAR_TYPES

[top of page]

FA.FA_CALENDAR_PERIODS does not reference any database object

FA.FA_CALENDAR_PERIODS is referenced by following:

APPS
SYNONYM - FA_CALENDAR_PERIODS

[top of page]

Table: FA_CALENDAR_TYPES

Description: General calendar information
Primary Key: FA_CALENDAR_TYPES_PK
  1. CALENDAR_TYPE
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_BOOK_CONTROLS.DEPRN_CALENDAR FA_CALENDAR_TYPES
FA_BOOK_CONTROLS.PRORATE_CALENDAR FA_CALENDAR_TYPES
FA_CALENDAR_PERIODS.CALENDAR_TYPE FA_CALENDAR_TYPES

[top of page]

FA.FA_CALENDAR_TYPES does not reference any database object

FA.FA_CALENDAR_TYPES is referenced by following:

APPS
SYNONYM - FA_CALENDAR_TYPES

[top of page]

Table: FA_CAPITAL_BUDGET

Description: Budget assets used to run depreciation projections and reports
Primary Key: FA_CAPITAL_BUDGET_PK
  1. BUDGET_ID
  2. PERIOD_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_CAPITAL_BUDGET.BUDGET_ID FA_BUDGET_DISTRIBUTION
FA_CAPITAL_BUDGET.ASSET_ID FA_ADDITIONS_B
FA_CAPITAL_BUDGET.BOOK_HEADER_ID FA_BOOKS
FA_CAPITAL_BUDGET.TRANSFER_HEADER_ID FA_TRANSACTION_HEADERS
FA_CAPITAL_BUDGET.DISTRIBUTION_ID FA_DISTRIBUTION_HISTORY

[top of page]

FA.FA_CAPITAL_BUDGET does not reference any database object

FA.FA_CAPITAL_BUDGET is referenced by following:

APPS
SYNONYM - FA_CAPITAL_BUDGET

[top of page]

Table: FA_CAP_REP_ITF

Description: Interface table for Report eXchange reports

[top of page]

FA.FA_CAP_REP_ITF does not reference any database object

FA.FA_CAP_REP_ITF is referenced by following:

APPS
SYNONYM - FA_CAP_REP_ITF

[top of page]

Table: FA_CASH_GEN_UNITS

Description: FA_CASH_GEN_UNITS table stores the definition of cash generating units per asset book.

[top of page]

FA.FA_CASH_GEN_UNITS does not reference any database object

FA.FA_CASH_GEN_UNITS is referenced by following:

APPS
SYNONYM - FA_CASH_GEN_UNITS

[top of page]

Table: FA_CATEGORIES_B

Description: Default financial information for asset categories (base MLS table)
Primary Key: FA_CATEGORIES_B_PK
  1. CATEGORY_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_ADDITIONS_B.ASSET_CATEGORY_ID FA_CATEGORIES_B
FA_ASSET_HISTORY.CATEGORY_ID FA_CATEGORIES_B
FA_BUDGET_DISTRIBUTION.CATEGORY_ID FA_CATEGORIES_B
FA_CATEGORIES_B
FA_CATEGORY_BOOKS.CATEGORY_ID FA_CATEGORIES_B
FA_CATEGORY_BOOK_DEFAULTS.CATEGORY_ID FA_CATEGORIES_B
FA_MAINT_SCHEDULE_HDR.CATEGORY_ID FA_CATEGORIES_B
FA_MASS_ADDITIONS.ASSET_CATEGORY_ID FA_CATEGORIES_B
FA_CATEGORIES_B
FA_MASS_CHANGES.CATEGORY_ID FA_CATEGORIES_B
FA_MASS_RECLASS.FROM_CATEGORY_ID FA_CATEGORIES_B
FA_MASS_RECLASS.TO_CATEGORY_ID FA_CATEGORIES_B
FA_MASS_RETIREMENTS.CATEGORY_ID FA_CATEGORIES_B
FA_MASS_REVALUATION_RULES.CATEGORY_ID FA_CATEGORIES_B
FA_MASS_REVAL_REP_ITF.ASSET_CATEGORY_ID FA_CATEGORIES_B
FA_MASS_TRANSFERS.CATEGORY_ID FA_CATEGORIES_B
FA_PARALLEL_WORKERS.ASSET_CATEGORY_ID FA_CATEGORIES_B
JAI_FA_AST_BLOCK_DTLS.ASSET_CATEGORY_ID FA_CATEGORIES_B
MTL_SYSTEM_ITEMS_B.ASSET_CATEGORY_ID FA_CATEGORIES_B
PA_PROJECT_ASSETS_ALL.ASSET_CATEGORY_ID FA_CATEGORIES_B
PA_PROJECT_ASSET_LINES_ALL.ASSET_CATEGORY_ID FA_CATEGORIES_B
PA_STANDARD_UNIT_COSTS.ASSET_CATEGORY_ID FA_CATEGORIES_B

[top of page]

FA.FA_CATEGORIES_B does not reference any database object

FA.FA_CATEGORIES_B is referenced by following:

APPS
SYNONYM - FA_CATEGORIES_B

[top of page]

Table: FA_CATEGORIES_TL

Description: Default financial information for asset categories (base MLS table)Default financial information for asset categories (translated MLS table)
Primary Key: FA_CATEGORIES_TL_PK
  1. CATEGORY_ID
  2. LANGUAGE

[top of page]

FA.FA_CATEGORIES_TL does not reference any database object

FA.FA_CATEGORIES_TL is referenced by following:

APPS
SYNONYM - FA_CATEGORIES_TL

[top of page]

Table: FA_CATEGORY_ACCOUNTS_GT

Description:

[top of page]

FA.FA_CATEGORY_ACCOUNTS_GT does not reference any database object

FA.FA_CATEGORY_ACCOUNTS_GT is referenced by following:

APPS
SYNONYM - FA_CATEGORY_ACCOUNTS_GT

[top of page]

Table: FA_CATEGORY_BOOKS

Description: Default financial information for an asset category and depreciation book combination
Primary Key: FA_CATEGORY_BOOKS_PK
  1. CATEGORY_ID
  2. BOOK_TYPE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_CATEGORY_BOOKS.CATEGORY_ID FA_CATEGORIES_B
FA_CATEGORY_BOOKS.UNPLAN_EXPENSE_ACCOUNT_CCID GL_CODE_COMBINATIONS
FA_CATEGORY_BOOKS.DEPRN_EXPENSE_ACCOUNT_CCID GL_CODE_COMBINATIONS
FA_CATEGORY_BOOKS.BONUS_EXPENSE_ACCOUNT_CCID GL_CODE_COMBINATIONS
FA_CATEGORY_BOOKS.ALT_COST_ACCOUNT_CCID GL_CODE_COMBINATIONS
FA_CATEGORY_BOOKS.WRITE_OFF_ACCOUNT_CCID GL_CODE_COMBINATIONS
FA_CATEGORY_BOOKS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_CATEGORY_BOOKS.ASSET_COST_ACCOUNT_CCID GL_CODE_COMBINATIONS
FA_CATEGORY_BOOKS.ASSET_CLEARING_ACCOUNT_CCID GL_CODE_COMBINATIONS
FA_CATEGORY_BOOKS.RESERVE_ACCOUNT_CCID GL_CODE_COMBINATIONS
FA_CATEGORY_BOOKS.REVAL_RESERVE_ACCOUNT_CCID GL_CODE_COMBINATIONS
FA_CATEGORY_BOOKS.REVAL_AMORT_ACCOUNT_CCID GL_CODE_COMBINATIONS
FA_CATEGORY_BOOKS.WIP_CLEARING_ACCOUNT_CCID GL_CODE_COMBINATIONS
FA_CATEGORY_BOOKS.WIP_COST_ACCOUNT_CCID GL_CODE_COMBINATIONS

[top of page]

FA.FA_CATEGORY_BOOKS does not reference any database object

FA.FA_CATEGORY_BOOKS is referenced by following:

APPS
SYNONYM - FA_CATEGORY_BOOKS

[top of page]

Table: FA_CATEGORY_BOOK_DEFAULTS

Description: Default depreciation rules for asset category and book combination for a particular date placed in service range
Primary Key: FA_CATEGORY_BOOK_DEFAULTS_PK
  1. CATEGORY_ID
  2. BOOK_TYPE_CODE
  3. START_DPIS
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_CATEGORY_BOOK_DEFAULTS.CATEGORY_ID FA_CATEGORIES_B
FA_CATEGORY_BOOK_DEFAULTS.GROUP_ASSET_ID FA_ADDITIONS_B
FA_CATEGORY_BOOK_DEFAULTS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_CATEGORY_BOOK_DEFAULTS.DEPRN_METHOD
FA_CATEGORY_BOOK_DEFAULTS.LIFE_IN_MONTHS 		FA_METHODS
FA_CATEGORY_BOOK_DEFAULTS.PRORATE_CONVENTION_CODE FA_CONVENTION_TYPES
FA_CATEGORY_BOOK_DEFAULTS.CEILING_NAME FA_CEILING_TYPES
FA_CATEGORY_BOOK_DEFAULTS.PRICE_INDEX_NAME FA_PRICE_INDEXES
FA_CATEGORY_BOOK_DEFAULTS.STL_METHOD_CODE
FA_CATEGORY_BOOK_DEFAULTS.STL_LIFE_IN_MONTHS 		FA_METHODS
FA_CATEGORY_BOOK_DEFAULTS.RETIREMENT_PRORATE_CONVENTION FA_CONVENTION_TYPES

[top of page]

FA.FA_CATEGORY_BOOK_DEFAULTS does not reference any database object

FA.FA_CATEGORY_BOOK_DEFAULTS is referenced by following:

APPS
SYNONYM - FA_CATEGORY_BOOK_DEFAULTS

[top of page]

Table: FA_CEILINGS

Description: Seeded and user-defined ceilings for depreciation expense, investment tax credit cost basis, and depreciation cost basis
Primary Key: FA_CEILINGS_PK
  1. START_DATE
  2. YEAR_OF_LIFE
  3. CEILING_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_CEILINGS.CEILING_NAME FA_CEILING_TYPES

[top of page]

FA.FA_CEILINGS does not reference any database object

FA.FA_CEILINGS is referenced by following:

APPS
SYNONYM - FA_CEILINGS

[top of page]

Table: FA_CEILING_TYPES

Description: General ceiling information
Primary Key: FA_CEILING_TYPES_PK
  1. CEILING_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_CEILING_TYPES.CURRENCY_CODE FND_CURRENCIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_BOOKS.CEILING_NAME FA_CEILING_TYPES
FA_BOOKS_SUMMARY.CEILING_NAME FA_CEILING_TYPES
FA_CATEGORY_BOOK_DEFAULTS.CEILING_NAME FA_CEILING_TYPES
FA_CEILINGS.CEILING_NAME FA_CEILING_TYPES
FA_MASS_RECLASS_ITF.CEILING FA_CEILING_TYPES
FA_MC_BOOKS.CEILING_NAME FA_CEILING_TYPES
FA_TAX_INTERFACE.CEILING_NAME FA_CEILING_TYPES

[top of page]

FA.FA_CEILING_TYPES does not reference any database object

FA.FA_CEILING_TYPES is referenced by following:

APPS
SYNONYM - FA_CEILING_TYPES

[top of page]

Table: FA_CONVENTIONS

Description: Detailed prorate convention information
Primary Key: FA_CONVENTIONS_PK
  1. PRORATE_CONVENTION_CODE
  2. START_DATE
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_CONVENTIONS.PRORATE_CONVENTION_CODE FA_CONVENTION_TYPES

[top of page]

FA.FA_CONVENTIONS does not reference any database object

FA.FA_CONVENTIONS is referenced by following:

APPS
SYNONYM - FA_CONVENTIONS

[top of page]

Table: FA_CONVENTION_TYPES

Description: Names and descriptions for prorate conventions
Primary Key: FA_CONVENTION_TYPES_PK
  1. PRORATE_CONVENTION_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_ACE_BOOKS.PRORATE_CONVENTION_CODE FA_CONVENTION_TYPES
FA_BOOKS.PRORATE_CONVENTION_CODE FA_CONVENTION_TYPES
FA_CATEGORY_BOOK_DEFAULTS.PRORATE_CONVENTION_CODE FA_CONVENTION_TYPES
FA_CATEGORY_BOOK_DEFAULTS.RETIREMENT_PRORATE_CONVENTION FA_CONVENTION_TYPES
FA_CONVENTIONS.PRORATE_CONVENTION_CODE FA_CONVENTION_TYPES
FA_MASS_CHANGES.FROM_CONVENTION FA_CONVENTION_TYPES
FA_MASS_CHANGES.TO_CONVENTION FA_CONVENTION_TYPES
FA_MASS_CHANGES_ITF.FROM_CONVENTION FA_CONVENTION_TYPES
FA_MASS_CHANGES_ITF.TO_CONVENTION FA_CONVENTION_TYPES
FA_MASS_RECLASS_ITF.CONVENTION FA_CONVENTION_TYPES
FA_MC_BOOKS.PRORATE_CONVENTION_CODE FA_CONVENTION_TYPES
FA_MC_RETIREMENTS.RETIREMENT_PRORATE_CONVENTION FA_CONVENTION_TYPES
FA_RETIREMENTS.RETIREMENT_PRORATE_CONVENTION FA_CONVENTION_TYPES
FA_SHORT_TAX_RESERVES.PRORATE_CONVENTION_CODE FA_CONVENTION_TYPES
FA_TAX_INTERFACE.PRORATE_CONVENTION_CODE FA_CONVENTION_TYPES

[top of page]

FA.FA_CONVENTION_TYPES does not reference any database object

FA.FA_CONVENTION_TYPES is referenced by following:

APPS
SYNONYM - FA_CONVENTION_TYPES

[top of page]

Table: FA_COSTCLEAR_REP_ITF

Description: Interface table for Report eXchange reports

[top of page]

FA.FA_COSTCLEAR_REP_ITF does not reference any database object

FA.FA_COSTCLEAR_REP_ITF is referenced by following:

APPS
SYNONYM - FA_COSTCLEAR_REP_ITF

[top of page]

Table: FA_DEFERRED_DEPRN

Description: Deferred depreciation calculated for each distribution line
Primary Key: FA_DEFERRED_DEPRN_PK
  1. TAX_BOOK_TYPE_CODE
  2. EXPENSE_JE_LINE_NUM
Primary Key: FA_DEFERRED_DEPRN_UK1
  1. CORP_BOOK_TYPE_CODE
  2. TAX_BOOK_TYPE_CODE
  3. RESERVE_JE_LINE_NUM
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_DEFERRED_DEPRN.CORP_BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_DEFERRED_DEPRN.DEFERRED_DEPRN_EXPENSE_CCID GL_CODE_COMBINATIONS
FA_DEFERRED_DEPRN.DEFERRED_DEPRN_RESERVE_CCID GL_CODE_COMBINATIONS
FA_DEFERRED_DEPRN.TAX_BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_DEFERRED_DEPRN.ASSET_ID FA_ADDITIONS_B
FA_DEFERRED_DEPRN.DISTRIBUTION_ID FA_DISTRIBUTION_HISTORY
FA_DEFERRED_DEPRN.CORP_BOOK_TYPE_CODE
FA_DEFERRED_DEPRN.CORP_PERIOD_COUNTER 		FA_DEPRN_PERIODS
FA_DEFERRED_DEPRN.TAX_BOOK_TYPE_CODE
FA_DEFERRED_DEPRN.TAX_PERIOD_COUNTER 		FA_DEPRN_PERIODS
FA_DEFERRED_DEPRN.JE_HEADER_ID GL_JE_HEADERS
FA_DEFERRED_DEPRN.JE_HEADER_ID
FA_DEFERRED_DEPRN.EXPENSE_JE_LINE_NUM 		GL_JE_LINES
FA_DEFERRED_DEPRN.JE_HEADER_ID
FA_DEFERRED_DEPRN.RESERVE_JE_LINE_NUM 		GL_JE_LINES

[top of page]

FA.FA_DEFERRED_DEPRN does not reference any database object

FA.FA_DEFERRED_DEPRN is referenced by following:

APPS
SYNONYM - FA_DEFERRED_DEPRN

[top of page]

Table: FA_DEFERRED_DEPRN_EVENTS

Description: Information about deferred depreciation accounting events.

[top of page]

FA.FA_DEFERRED_DEPRN_EVENTS does not reference any database object

FA.FA_DEFERRED_DEPRN_EVENTS is referenced by following:

APPS
SYNONYM - FA_DEFERRED_DEPRN_EVENTS

[top of page]

Table: FA_DELETED_MASS_ADDITIONS

Description: Invoice information of mass additions you deleted from the FA_MASS_ADDITIONS table using the Delete Mass Additions form
Primary Key: FA_DELETED_MASS_ADDITIONS_PK
  1. MASS_ADDITION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_DELETED_MASS_ADDITIONS.MASS_ADDITION_ID FA_MASS_ADDITIONS
FA_DELETED_MASS_ADDITIONS.PAYABLES_CODE_COMBINATION_ID GL_CODE_COMBINATIONS
FA_DELETED_MASS_ADDITIONS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_DELETED_MASS_ADDITIONS.PROJECT_ID PA_PROJECTS_ALL
FA_DELETED_MASS_ADDITIONS.TASK_ID PA_TASKS
FA_DELETED_MASS_ADDITIONS.PROJECT_ASSET_LINE_ID PA_PROJECT_ASSET_LINES_ALL

[top of page]

FA.FA_DELETED_MASS_ADDITIONS does not reference any database object

FA.FA_DELETED_MASS_ADDITIONS is referenced by following:

APPS
SYNONYM - FA_DELETED_MASS_ADDITIONS

[top of page]

Table: FA_DEPRN_BASIS_RULES

Description: Depreciable Basis Rules
Primary Key: FA_DEPRN_BASIS_RULES_PK
  1. DEPRN_BASIS_RULE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_DEPRN_RULE_DETAILS.DEPRN_BASIS_RULE_ID FA_DEPRN_BASIS_RULES

[top of page]

FA.FA_DEPRN_BASIS_RULES does not reference any database object

FA.FA_DEPRN_BASIS_RULES is referenced by following:

APPS
SYNONYM - FA_DEPRN_BASIS_RULES

[top of page]

Table: FA_DEPRN_DETAIL

Description: Depreciation amounts charged to the depreciation expense account in each distribution line
Primary Key: FA_DEPRN_DETAIL_PK
  1. BOOK_TYPE_CODE
  2. ASSET_ID
  3. DISTRIBUTION_ID
  4. PERIOD_COUNTER
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_DEPRN_DETAIL.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_DEPRN_DETAIL.BOOK_TYPE_CODE
FA_DEPRN_DETAIL.ASSET_ID
FA_DEPRN_DETAIL.PERIOD_COUNTER 		FA_DEPRN_SUMMARY
FA_DEPRN_DETAIL.JE_HEADER_ID
FA_DEPRN_DETAIL.BONUS_DEPRN_EXP_JE_LINE_NUM 		GL_JE_LINES
FA_DEPRN_DETAIL.JE_HEADER_ID
FA_DEPRN_DETAIL.BONUS_DEPRN_RSV_JE_LINE_NUM 		GL_JE_LINES
FA_DEPRN_DETAIL.DEPRN_EXPENSE_CCID GL_CODE_COMBINATIONS
FA_DEPRN_DETAIL.DEPRN_RESERVE_CCID GL_CODE_COMBINATIONS
FA_DEPRN_DETAIL.BONUS_DEPRN_EXPENSE_CCID GL_CODE_COMBINATIONS
FA_DEPRN_DETAIL.BONUS_DEPRN_RESERVE_CCID GL_CODE_COMBINATIONS
FA_DEPRN_DETAIL.REVAL_AMORT_CCID GL_CODE_COMBINATIONS
FA_DEPRN_DETAIL.REVAL_RESERVE_CCID GL_CODE_COMBINATIONS
FA_DEPRN_DETAIL.ASSET_ID FA_ADDITIONS_B
FA_DEPRN_DETAIL.DISTRIBUTION_ID FA_DISTRIBUTION_HISTORY
FA_DEPRN_DETAIL.BOOK_TYPE_CODE
FA_DEPRN_DETAIL.PERIOD_COUNTER 		FA_DEPRN_PERIODS
FA_DEPRN_DETAIL.JE_HEADER_ID
FA_DEPRN_DETAIL.DEPRN_EXPENSE_JE_LINE_NUM 		GL_JE_LINES
FA_DEPRN_DETAIL.JE_HEADER_ID
FA_DEPRN_DETAIL.DEPRN_RESERVE_JE_LINE_NUM 		GL_JE_LINES
FA_DEPRN_DETAIL.JE_HEADER_ID
FA_DEPRN_DETAIL.REVAL_AMORT_JE_LINE_NUM 		GL_JE_LINES
FA_DEPRN_DETAIL.JE_HEADER_ID
FA_DEPRN_DETAIL.REVAL_RESERVE_JE_LINE_NUM 		GL_JE_LINES
FA_DEPRN_DETAIL.JE_HEADER_ID GL_JE_HEADERS

[top of page]

FA.FA_DEPRN_DETAIL does not reference any database object

FA.FA_DEPRN_DETAIL is referenced by following:

APPS
SYNONYM - FA_DEPRN_DETAIL

[top of page]

Table: FA_DEPRN_DETAIL_H

Description: Stores the depreciation information originally stored in FA_DEPRN_DETAIL for audit purposes.

[top of page]

FA.FA_DEPRN_DETAIL_H does not reference any database object

FA.FA_DEPRN_DETAIL_H is referenced by following:

APPS
SYNONYM - FA_DEPRN_DETAIL_H

[top of page]

Table: FA_DEPRN_EVENTS

Description: Information about depreciation accounting events.

[top of page]

FA.FA_DEPRN_EVENTS does not reference any database object

FA.FA_DEPRN_EVENTS is referenced by following:

APPS
SYNONYM - FA_DEPRN_EVENTS

[top of page]

Table: FA_DEPRN_OVERRIDE

Description: Table for Depreciation Override Feature.
Primary Key: FA_DEPRN_OVERRIDE_PK
  1. DEPRN_OVERRIDE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_DEPRN_OVERRIDE.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_DEPRN_OVERRIDE.ASSET_ID FA_ADDITIONS_B

[top of page]

FA.FA_DEPRN_OVERRIDE does not reference any database object

FA.FA_DEPRN_OVERRIDE is referenced by following:

APPS
SYNONYM - FA_DEPRN_OVERRIDE
TRIGGER - FA_DEPRN_OVERRIDE_BRIUD

[top of page]

Table: FA_DEPRN_PERIODS

Description: Information about each depreciation period
Primary Key: FA_DEPRN_PERIODS_PK
  1. BOOK_TYPE_CODE
  2. PERIOD_COUNTER
Primary Key: FA_DEPRN_PERIODS_UK1
  1. BOOK_TYPE_CODE
  2. FISCAL_YEAR
  3. PERIOD_NUM
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_DEPRN_PERIODS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_DEPRN_PERIODS.CIP_ADDITION_BATCH_ID GL_JE_BATCHES
FA_DEPRN_PERIODS.CIP_ADJUSTMENT_BATCH_ID GL_JE_BATCHES
FA_DEPRN_PERIODS.CIP_RECLASS_BATCH_ID GL_JE_BATCHES
FA_DEPRN_PERIODS.CIP_RETIREMENT_BATCH_ID GL_JE_BATCHES
FA_DEPRN_PERIODS.CIP_REVAL_BATCH_ID GL_JE_BATCHES
FA_DEPRN_PERIODS.CIP_TRANSFER_BATCH_ID GL_JE_BATCHES
FA_DEPRN_PERIODS.REVAL_BATCH_ID GL_JE_BATCHES
FA_DEPRN_PERIODS.DEPRN_ADJUSTMENT_BATCH_ID GL_JE_BATCHES
FA_DEPRN_PERIODS.DEPRECIATION_BATCH_ID GL_JE_BATCHES
FA_DEPRN_PERIODS.RETIREMENT_BATCH_ID GL_JE_BATCHES
FA_DEPRN_PERIODS.RECLASS_BATCH_ID GL_JE_BATCHES
FA_DEPRN_PERIODS.TRANSFER_BATCH_ID GL_JE_BATCHES
FA_DEPRN_PERIODS.BOOK_TYPE_CODE
FA_DEPRN_PERIODS.PERIOD_COUNTER 		FA_DEPRN_PERIODS
FA_DEPRN_PERIODS.ADDITION_BATCH_ID GL_JE_BATCHES
FA_DEPRN_PERIODS.ADJUSTMENT_BATCH_ID GL_JE_BATCHES
FA_DEPRN_PERIODS.DEFERRED_DEPRN_BATCH_ID GL_JE_BATCHES
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_ADJUSTMENTS.BOOK_TYPE_CODE
FA_ADJUSTMENTS.PERIOD_COUNTER_ADJUSTED 		FA_DEPRN_PERIODS
FA_ADJUSTMENTS.BOOK_TYPE_CODE
FA_ADJUSTMENTS.PERIOD_COUNTER_CREATED 		FA_DEPRN_PERIODS
FA_BOOKS.BOOK_TYPE_CODE
FA_BOOKS.PERIOD_COUNTER_FULLY_RESERVED 		FA_DEPRN_PERIODS
FA_BOOKS.BOOK_TYPE_CODE
FA_BOOKS.PERIOD_COUNTER_FULLY_RETIRED 		FA_DEPRN_PERIODS
FA_BOOKS.BOOK_TYPE_CODE
FA_BOOKS.PERIOD_COUNTER_CAPITALIZED 		FA_DEPRN_PERIODS
FA_BOOKS.BOOK_TYPE_CODE
FA_BOOKS.PERIOD_COUNTER_LIFE_COMPLETE 		FA_DEPRN_PERIODS
FA_BOOK_CONTROLS.BOOK_TYPE_CODE
FA_BOOK_CONTROLS.LAST_PURGE_PERIOD_COUNTER 		FA_DEPRN_PERIODS
FA_BOOK_CONTROLS.BOOK_TYPE_CODE
FA_BOOK_CONTROLS.INITIAL_PERIOD_COUNTER 		FA_DEPRN_PERIODS
FA_BOOK_CONTROLS.BOOK_TYPE_CODE
FA_BOOK_CONTROLS.LAST_PERIOD_COUNTER 		FA_DEPRN_PERIODS
FA_BOOK_CONTROLS.BOOK_TYPE_CODE
FA_BOOK_CONTROLS.LAST_MASS_COPY_PERIOD_COUNTER 		FA_DEPRN_PERIODS
FA_DEFERRED_DEPRN.CORP_BOOK_TYPE_CODE
FA_DEFERRED_DEPRN.CORP_PERIOD_COUNTER 		FA_DEPRN_PERIODS
FA_DEFERRED_DEPRN.TAX_BOOK_TYPE_CODE
FA_DEFERRED_DEPRN.TAX_PERIOD_COUNTER 		FA_DEPRN_PERIODS
FA_DEPRN_DETAIL.BOOK_TYPE_CODE
FA_DEPRN_DETAIL.PERIOD_COUNTER 		FA_DEPRN_PERIODS
FA_DEPRN_PERIODS.BOOK_TYPE_CODE
FA_DEPRN_PERIODS.PERIOD_COUNTER 		FA_DEPRN_PERIODS
FA_DEPRN_SUMMARY.BOOK_TYPE_CODE
FA_DEPRN_SUMMARY.PERIOD_COUNTER 		FA_DEPRN_PERIODS
FA_JOURNAL_ENTRIES.BOOK_TYPE_CODE
FA_JOURNAL_ENTRIES.PERIOD_COUNTER 		FA_DEPRN_PERIODS
FA_MC_ADJUSTMENTS.BOOK_TYPE_CODE
FA_MC_ADJUSTMENTS.PERIOD_COUNTER_CREATED 		FA_DEPRN_PERIODS
FA_MC_ADJUSTMENTS.BOOK_TYPE_CODE
FA_MC_ADJUSTMENTS.PERIOD_COUNTER_ADJUSTED 		FA_DEPRN_PERIODS
FA_MC_CONVERSION_HISTORY.BOOK_TYPE_CODE
FA_MC_CONVERSION_HISTORY.PERIOD_COUNTER_CONVERTED 		FA_DEPRN_PERIODS
FA_MC_CONVERSION_HISTORY.BOOK_TYPE_CODE
FA_MC_CONVERSION_HISTORY.PERIOD_COUNTER_SELECTED 		FA_DEPRN_PERIODS
FA_MC_CONVERSION_HISTORY.BOOK_TYPE_CODE
FA_MC_CONVERSION_HISTORY.PERIOD_COUNTER_START 		FA_DEPRN_PERIODS
FA_MC_CONVERSION_RATES.BOOK_TYPE_CODE
FA_MC_CONVERSION_RATES.LAST_PERIOD_COUNTER 		FA_DEPRN_PERIODS
FA_MC_DEPRN_DETAIL.BOOK_TYPE_CODE
FA_MC_DEPRN_DETAIL.PERIOD_COUNTER 		FA_DEPRN_PERIODS

[top of page]

FA.FA_DEPRN_PERIODS does not reference any database object

FA.FA_DEPRN_PERIODS is referenced by following:

APPS
SYNONYM - FA_DEPRN_PERIODS

[top of page]

Table: FA_DEPRN_REP_ITF

Description: Interface table for Report eXchange reports
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_DEPRN_REP_ITF.GROUP_ASSET_NUMBER FA_ADDITIONS_B

[top of page]

FA.FA_DEPRN_REP_ITF does not reference any database object

FA.FA_DEPRN_REP_ITF is referenced by following:

APPS
SYNONYM - FA_DEPRN_REP_ITF

[top of page]

Table: FA_DEPRN_RULE_DETAILS

Description: This table is to define the detail information of depreciable basis rule
Primary Key: FA_DEPRN_RULE_DETAILS_PK
  1. DEPRN_RULE_DETAIL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_DEPRN_RULE_DETAILS.DEPRN_BASIS_RULE_ID FA_DEPRN_BASIS_RULES

[top of page]

FA.FA_DEPRN_RULE_DETAILS does not reference any database object

FA.FA_DEPRN_RULE_DETAILS is referenced by following:

APPS
SYNONYM - FA_DEPRN_RULE_DETAILS

[top of page]

Table: FA_DEPRN_SUMMARY

Description: Depreciation information at the asset level
Primary Key: FA_DEPRN_SUMMARY_PK
  1. BOOK_TYPE_CODE
  2. ASSET_ID
  3. PERIOD_COUNTER
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_DEPRN_SUMMARY.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_DEPRN_SUMMARY.ASSET_ID FA_ADDITIONS_B
FA_DEPRN_SUMMARY.BOOK_TYPE_CODE
FA_DEPRN_SUMMARY.PERIOD_COUNTER 		FA_DEPRN_PERIODS
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_DEPRN_DETAIL.BOOK_TYPE_CODE
FA_DEPRN_DETAIL.ASSET_ID
FA_DEPRN_DETAIL.PERIOD_COUNTER 		FA_DEPRN_SUMMARY

[top of page]

FA.FA_DEPRN_SUMMARY does not reference any database object

FA.FA_DEPRN_SUMMARY is referenced by following:

APPS
SYNONYM - FA_DEPRN_SUMMARY

[top of page]

Table: FA_DEPRN_SUMMARY_H

Description: Stores the depreciation information originally stored in FA_DEPRN_SUMMARY for audit purposes.

[top of page]

FA.FA_DEPRN_SUMMARY_H does not reference any database object

FA.FA_DEPRN_SUMMARY_H is referenced by following:

APPS
SYNONYM - FA_DEPRN_SUMMARY_H

[top of page]

Table: FA_DEPRN_TAX_AUTHORITIES

Description:
Primary Key: FA_DEPRN_TAX_AUTHORITIES_PK
  1. CODE

[top of page]

FA.FA_DEPRN_TAX_AUTHORITIES does not reference any database object

FA.FA_DEPRN_TAX_AUTHORITIES is referenced by following:

APPS
SYNONYM - FA_DEPRN_TAX_AUTHORITIES

[top of page]

Table: FA_DEPRN_TAX_ENTITIES

Description:
Primary Key: FA_DEPRN_TAX_ENTITIES_PK
  1. LEGAL_ENTITY_NAME

[top of page]

FA.FA_DEPRN_TAX_ENTITIES does not reference any database object

FA.FA_DEPRN_TAX_ENTITIES is referenced by following:

APPS
SYNONYM - FA_DEPRN_TAX_ENTITIES

[top of page]

Table: FA_DEPRN_TAX_REP_ITF

Description: Depreciable Assets Tax Reports interim table

[top of page]

FA.FA_DEPRN_TAX_REP_ITF does not reference any database object

FA.FA_DEPRN_TAX_REP_ITF is referenced by following:

APPS
SYNONYM - FA_DEPRN_TAX_REP_ITF

[top of page]

Table: FA_DEPRN_TAX_REP_NBVS

Description: Table used for the Japanese Depreciable Asset Tax Report.
Primary Key: FA_DEPRN_TAX_REP_NBVS_PK
  1. DEPRN_TAX_REP_NBV_ID

[top of page]

FA.FA_DEPRN_TAX_REP_NBVS does not reference any database object

FA.FA_DEPRN_TAX_REP_NBVS is referenced by following:

APPS
SYNONYM - FA_DEPRN_TAX_REP_NBVS

[top of page]

Table: FA_DISTRIBUTION_ACCOUNTS

Description: Table to store account ccids for all distributions for a book
Primary Key: FA_DISTRIBUTION_ACCOUNTS_PK
  1. BOOK_TYPE_CODE
  2. DISTRIBUTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_DISTRIBUTION_ACCOUNTS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_DISTRIBUTION_ACCOUNTS.DEPRN_EXPENSE_ACCOUNT_CCID GL_CODE_COMBINATIONS
FA_DISTRIBUTION_ACCOUNTS.DEPRN_RESERVE_ACCOUNT_CCID GL_CODE_COMBINATIONS
FA_DISTRIBUTION_ACCOUNTS.NBV_RETIRED_GAIN_CCID GL_CODE_COMBINATIONS
FA_DISTRIBUTION_ACCOUNTS.NBV_RETIRED_LOSS_CCID GL_CODE_COMBINATIONS
FA_DISTRIBUTION_ACCOUNTS.PROCEEDS_SALE_CLEARING_CCID GL_CODE_COMBINATIONS
FA_DISTRIBUTION_ACCOUNTS.PROCEEDS_SALE_GAIN_CCID GL_CODE_COMBINATIONS
FA_DISTRIBUTION_ACCOUNTS.PROCEEDS_SALE_LOSS_CCID GL_CODE_COMBINATIONS
FA_DISTRIBUTION_ACCOUNTS.REVAL_RSV_GAIN_ACCOUNT_CCID GL_CODE_COMBINATIONS
FA_DISTRIBUTION_ACCOUNTS.REVAL_RSV_LOSS_ACCOUNT_CCID GL_CODE_COMBINATIONS
FA_DISTRIBUTION_ACCOUNTS.DEFERRED_EXP_ACCOUNT_CCID GL_CODE_COMBINATIONS
FA_DISTRIBUTION_ACCOUNTS.DISTRIBUTION_ID FA_DISTRIBUTION_HISTORY
FA_DISTRIBUTION_ACCOUNTS.DEFERRED_RSV_ACCOUNT_CCID GL_CODE_COMBINATIONS
FA_DISTRIBUTION_ACCOUNTS.DEPRN_ADJ_ACCOUNT_CCID GL_CODE_COMBINATIONS
FA_DISTRIBUTION_ACCOUNTS.REVAL_AMORT_ACCOUNT_CCID GL_CODE_COMBINATIONS
FA_DISTRIBUTION_ACCOUNTS.REVAL_RSV_ACCOUNT_CCID GL_CODE_COMBINATIONS
FA_DISTRIBUTION_ACCOUNTS.BONUS_EXP_ACCOUNT_CCID GL_CODE_COMBINATIONS
FA_DISTRIBUTION_ACCOUNTS.BONUS_RSV_ACCOUNT_CCID GL_CODE_COMBINATIONS
FA_DISTRIBUTION_ACCOUNTS.ASSET_CLEARING_ACCOUNT_CCID GL_CODE_COMBINATIONS
FA_DISTRIBUTION_ACCOUNTS.ASSET_COST_ACCOUNT_CCID GL_CODE_COMBINATIONS
FA_DISTRIBUTION_ACCOUNTS.CIP_CLEARING_ACCOUNT_CCID GL_CODE_COMBINATIONS
FA_DISTRIBUTION_ACCOUNTS.CIP_COST_ACCOUNT_CCID GL_CODE_COMBINATIONS
FA_DISTRIBUTION_ACCOUNTS.COST_REMOVAL_CLEARING_CCID GL_CODE_COMBINATIONS
FA_DISTRIBUTION_ACCOUNTS.COST_REMOVAL_GAIN_CCID GL_CODE_COMBINATIONS
FA_DISTRIBUTION_ACCOUNTS.COST_REMOVAL_LOSS_CCID GL_CODE_COMBINATIONS

[top of page]

FA.FA_DISTRIBUTION_ACCOUNTS does not reference any database object

FA.FA_DISTRIBUTION_ACCOUNTS is referenced by following:

APPS
SYNONYM - FA_DISTRIBUTION_ACCOUNTS

[top of page]

Table: FA_DISTRIBUTION_DEFAULTS

Description: Distribution set information
Primary Key: FA_DISTRIBUTION_DEFAULTS_PK
  1. DIST_DEFAULT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_DISTRIBUTION_DEFAULTS.DEPRN_EXPENSE_CCID GL_CODE_COMBINATIONS
FA_DISTRIBUTION_DEFAULTS.DIST_SET_ID FA_DISTRIBUTION_SETS
FA_DISTRIBUTION_DEFAULTS.LOCATION_ID FA_LOCATIONS

[top of page]

FA.FA_DISTRIBUTION_DEFAULTS does not reference any database object

FA.FA_DISTRIBUTION_DEFAULTS is referenced by following:

APPS
SYNONYM - FA_DISTRIBUTION_DEFAULTS

[top of page]

Table: FA_DISTRIBUTION_HISTORY

Description: Employee, location, and Accounting Flexfield values assigned to each asset
Primary Key: FA_DISTRIBUTION_HISTORY_PK
  1. DISTRIBUTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_DISTRIBUTION_HISTORY.ASSET_ID FA_ADDITIONS_B
FA_DISTRIBUTION_HISTORY.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_DISTRIBUTION_HISTORY.CODE_COMBINATION_ID GL_CODE_COMBINATIONS
FA_DISTRIBUTION_HISTORY.LOCATION_ID FA_LOCATIONS
FA_DISTRIBUTION_HISTORY.TRANSACTION_HEADER_ID_IN FA_TRANSACTION_HEADERS
FA_DISTRIBUTION_HISTORY.TRANSACTION_HEADER_ID_OUT FA_TRANSACTION_HEADERS
FA_DISTRIBUTION_HISTORY.RETIREMENT_ID FA_RETIREMENTS
FA_DISTRIBUTION_HISTORY.TRANSACTION_HEADER_ID_IN FA_BOOKS
Foreign Keys to this table:
Foreign Key Column Foreign Table
CUN_NON_SERIALIZED_UNITS.FA_DISTRIBUTION_ID FA_DISTRIBUTION_HISTORY
CUN_SERIALIZED_UNITS.FA_DISTRIBUTION_ID FA_DISTRIBUTION_HISTORY
FA_ADJUSTMENTS.DISTRIBUTION_ID FA_DISTRIBUTION_HISTORY
FA_CAPITAL_BUDGET.DISTRIBUTION_ID FA_DISTRIBUTION_HISTORY
FA_DEFERRED_DEPRN.DISTRIBUTION_ID FA_DISTRIBUTION_HISTORY
FA_DEPRN_DETAIL.DISTRIBUTION_ID FA_DISTRIBUTION_HISTORY
FA_DISTRIBUTION_ACCOUNTS.DISTRIBUTION_ID FA_DISTRIBUTION_HISTORY
FA_MASS_EXT_RETIREMENTS.DISTRIBUTION_ID FA_DISTRIBUTION_HISTORY
FA_MC_ADJUSTMENTS.DISTRIBUTION_ID FA_DISTRIBUTION_HISTORY
FA_MC_DEFERRED_DEPRN.DISTRIBUTION_ID FA_DISTRIBUTION_HISTORY
FA_MC_DEPRN_DETAIL.DISTRIBUTION_ID FA_DISTRIBUTION_HISTORY
FA_TRANSFER_DETAILS.DISTRIBUTION_ID FA_DISTRIBUTION_HISTORY
IA_REQUEST_DETAILS.FROM_DISTRIBUTION_ID FA_DISTRIBUTION_HISTORY
IA_REQUEST_DETAILS.TO_DISTRIBUTION_ID FA_DISTRIBUTION_HISTORY
JL_CO_FA_ADJUSTMENTS.DISTRIBUTION_ID FA_DISTRIBUTION_HISTORY
JL_ZZ_FA_RETIREMNT_ADJS.DISTRIBUTION_ID FA_DISTRIBUTION_HISTORY

[top of page]

FA.FA_DISTRIBUTION_HISTORY does not reference any database object

FA.FA_DISTRIBUTION_HISTORY is referenced by following:

APPS
SYNONYM - FA_DISTRIBUTION_HISTORY

[top of page]

Table: FA_DISTRIBUTION_SETS

Description: Header information for distribution sets
Primary Key: FA_DISTRIBUTION_SETS_PK
  1. DIST_SET_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_DISTRIBUTION_SETS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_DISTRIBUTION_DEFAULTS.DIST_SET_ID FA_DISTRIBUTION_SETS

[top of page]

FA.FA_DISTRIBUTION_SETS does not reference any database object

FA.FA_DISTRIBUTION_SETS is referenced by following:

APPS
SYNONYM - FA_DISTRIBUTION_SETS

[top of page]

Table: FA_EXCLUDE_HIERARCHY_LEVELS

Description: Which hierarchy levels should be excluded from an inheritance rule.

[top of page]

FA.FA_EXCLUDE_HIERARCHY_LEVELS does not reference any database object

FA.FA_EXCLUDE_HIERARCHY_LEVELS is referenced by following:

APPS
SYNONYM - FA_EXCLUDE_HIERARCHY_LEVELS

[top of page]

Table: FA_EXT_INV_RETIREMENTS

Description: External invoice retirements. Identifies the source line(s) to be retired by a mass external retirement.

[top of page]

FA.FA_EXT_INV_RETIREMENTS does not reference any database object

FA.FA_EXT_INV_RETIREMENTS is referenced by following:

APPS
SYNONYM - FA_EXT_INV_RETIREMENTS

[top of page]

Table: FA_FISCAL_YEAR

Description: Range of dates for all fiscal years
Primary Key: FA_FISCAL_YEAR_PK
  1. FISCAL_YEAR
  2. FISCAL_YEAR_NAME
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_BOOK_CONTROLS.CURRENT_FISCAL_YEAR
FA_BOOK_CONTROLS.FISCAL_YEAR_NAME 		FA_FISCAL_YEAR

[top of page]

FA.FA_FISCAL_YEAR does not reference any database object

FA.FA_FISCAL_YEAR is referenced by following:

APPS
SYNONYM - FA_FISCAL_YEAR

[top of page]

Table: FA_FLAT_RATES

Description: Annual depreciation rates for all flat-rate methods
Primary Key: FA_FLAT_RATES_PK
  1. METHOD_ID
  2. BASIC_RATE
  3. ADJUSTED_RATE
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_FLAT_RATES.METHOD_ID FA_METHODS

[top of page]

FA.FA_FLAT_RATES does not reference any database object

FA.FA_FLAT_RATES is referenced by following:

APPS
SYNONYM - FA_FLAT_RATES

[top of page]

Table: FA_FORMULAS

Description: Depreciation rates for formula-based methods
Primary Key: FA_FORMULAS_PK
  1. METHOD_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_FORMULAS.METHOD_ID FA_METHODS

[top of page]

FA.FA_FORMULAS does not reference any database object

FA.FA_FORMULAS is referenced by following:

APPS
SYNONYM - FA_FORMULAS

[top of page]

Table: FA_GROUP_ASSETS

Description: Contains group asset definitions - flexfield and general descriptive information.
Primary Key: FA_GROUP_ASSETS_U1
  1. GROUP_ASSET_ID

[top of page]

FA.FA_GROUP_ASSETS does not reference any database object

FA.FA_GROUP_ASSETS is referenced by following:

APPS
SYNONYM - FA_GROUP_ASSETS

[top of page]

Table: FA_GROUP_ASSET_DEFAULT

Description: Defines accounts to be used for a group asset within a particular book. e.g. Expense account, reserve account etc.
Primary Key: FA_GROUP_ASSET_DEFAULT_U1
  1. GROUP_ASSET_ID
  2. BOOK_TYPE_CODE

[top of page]

FA.FA_GROUP_ASSET_DEFAULT does not reference any database object

FA.FA_GROUP_ASSET_DEFAULT is referenced by following:

APPS
SYNONYM - FA_GROUP_ASSET_DEFAULT

[top of page]

Table: FA_GROUP_ASSET_RULES

Description: Defines the depreciation rules to be followed when depreciating a group asset within a particular book. This is also a history table.
Primary Key: FA_GROUP_ASSET_RULES_U1
  1. GROUP_ASSET_ID
  2. BOOK_TYPE_CODE
  3. DATE_EFFECTIVE

[top of page]

FA.FA_GROUP_ASSET_RULES does not reference any database object

FA.FA_GROUP_ASSET_RULES is referenced by following:

APPS
SYNONYM - FA_GROUP_ASSET_RULES

[top of page]

Table: FA_GROUP_DEPRN_DETAIL

Description: Redundant - mirrors FA_DEPRN_DETAIL and exists purely to store information returned by the depreciation process. Would usually store depreciation charged to expense accounts identified in the distribution list of an asset - since group ass
Primary Key: FA_GROUP_DEPRN_DETAIL_U1
  1. GROUP_ASSET_ID
  2. BOOK_TYPE_CODE
  3. PERIOD_COUNTER

[top of page]

FA.FA_GROUP_DEPRN_DETAIL does not reference any database object

FA.FA_GROUP_DEPRN_DETAIL is referenced by following:

APPS
SYNONYM - FA_GROUP_DEPRN_DETAIL

[top of page]

Table: FA_GROUP_DEPRN_RATES

Description: Contains the depreciation rates to be used when calculating the reserve amount to be transferred with an asset which is being moved out of a group.
Primary Key: FA_GROUP_DEPRN_RATES_U1
  1. BOOK_TYPE_CODE
  2. CATEGORY_ID
  3. EFFECTIVE_FROM_DATE
  4. EFFECTIVE_TO_DATE

[top of page]

FA.FA_GROUP_DEPRN_RATES does not reference any database object

FA.FA_GROUP_DEPRN_RATES is referenced by following:

APPS
SYNONYM - FA_GROUP_DEPRN_RATES

[top of page]

Table: FA_GROUP_DEPRN_SUMMARY

Description: Stores information about depreciation taken on a group asset, in a particular book in a particular period. This is a history table.
Primary Key: FA_GROUP_DEPRN_SUMMARY_U1
  1. BOOK_TYPE_CODE
  2. GROUP_ASSET_ID
  3. PERIOD_COUNTER

[top of page]

FA.FA_GROUP_DEPRN_SUMMARY does not reference any database object

FA.FA_GROUP_DEPRN_SUMMARY is referenced by following:

APPS
SYNONYM - FA_GROUP_DEPRN_SUMMARY

[top of page]

Table: FA_GROUP_REP_ITF

Description:

[top of page]

FA.FA_GROUP_REP_ITF does not reference any database object

FA.FA_GROUP_REP_ITF is referenced by following:

APPS
SYNONYM - FA_GROUP_REP_ITF

[top of page]

Table: FA_HIERARCHY_CONTROLS

Description: For a hierarchy purpose (root node) defines the rules that apply to the hierarchy. e.g. Maximum allowed number of levels, mandatory attributes etc.

[top of page]

FA.FA_HIERARCHY_CONTROLS does not reference any database object

FA.FA_HIERARCHY_CONTROLS is referenced by following:

APPS
SYNONYM - FA_HIERARCHY_CONTROLS

[top of page]

Table: FA_HIERARCHY_DISTRIBUTIONS

Description: Stores distribution sets (expense account, location and employee) associated with a hierarchy node that may be inherited by other nodes.

[top of page]

FA.FA_HIERARCHY_DISTRIBUTIONS does not reference any database object

FA.FA_HIERARCHY_DISTRIBUTIONS is referenced by following:

APPS
SYNONYM - FA_HIERARCHY_DISTRIBUTIONS

[top of page]

Table: FA_HIERARCHY_RULE_DETAILS

Description: Specific rules for a rule set, detailing how attributes are derived and where they are derived from.

[top of page]

FA.FA_HIERARCHY_RULE_DETAILS does not reference any database object

FA.FA_HIERARCHY_RULE_DETAILS is referenced by following:

APPS
SYNONYM - FA_HIERARCHY_RULE_DETAILS

[top of page]

Table: FA_HIERARCHY_RULE_SET

Description: Header information for a rule set that defines how attributes are inherited in the hierarchy.

[top of page]

FA.FA_HIERARCHY_RULE_SET does not reference any database object

FA.FA_HIERARCHY_RULE_SET is referenced by following:

APPS
SYNONYM - FA_HIERARCHY_RULE_SET

[top of page]

Table: FA_HR_RETIREMENT_DETAILS

Description: Individual retirements made as a result of a mass retirement on an asset hierarchy.

[top of page]

FA.FA_HR_RETIREMENT_DETAILS does not reference any database object

FA.FA_HR_RETIREMENT_DETAILS is referenced by following:

APPS
SYNONYM - FA_HR_RETIREMENT_DETAILS

[top of page]

Table: FA_HR_RETIREMENT_HEADERS

Description: Header information for mass retirement of assets in a hierarchy. Contains the retirement selection parameters defined by the user.

[top of page]

FA.FA_HR_RETIREMENT_HEADERS does not reference any database object

FA.FA_HR_RETIREMENT_HEADERS is referenced by following:

APPS
SYNONYM - FA_HR_RETIREMENT_HEADERS

[top of page]

Table: FA_IMPAIRMENTS

Description: FA_IMPAIRMENTS table stores the Impairment Transaction information.

[top of page]

FA.FA_IMPAIRMENTS does not reference any database object

FA.FA_IMPAIRMENTS is referenced by following:

APPS
SYNONYM - FA_IMPAIRMENTS

[top of page]

Table: FA_INS_LINES

Description: Stores policy line information
Primary Key: FA_INS_LINES_PK
  1. ASSET_POLICY_ID
  2. POLICY_LINE
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_INS_LINES.ASSET_POLICY_ID FA_INS_POLICIES
FA_INS_LINES.VENDOR_ID PO_VENDORS
FA_INS_LINES.ASSET_ID FA_ADDITIONS_B

[top of page]

FA.FA_INS_LINES does not reference any database object

FA.FA_INS_LINES is referenced by following:

APPS
SYNONYM - FA_INS_LINES

[top of page]

Table: FA_INS_MST_POLS

Description: Master policy table for insurance
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_INS_MST_POLS.ASSET_POLICY_ID FA_INS_POLICIES

[top of page]

FA.FA_INS_MST_POLS does not reference any database object

FA.FA_INS_MST_POLS is referenced by following:

APPS
SYNONYM - FA_INS_MST_POLS

[top of page]

Table: FA_INS_POLICIES

Description: Contains asset insurance policy information
Primary Key: FA_INS_POLICIES_PK
  1. ASSET_POLICY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_INS_POLICIES.LAST_INDEXATION_ID FA_INS_VALUES
FA_INS_POLICIES.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_INS_POLICIES.ASSET_ID FA_ADDITIONS_B
FA_INS_POLICIES.VENDOR_ID PO_VENDORS
FA_INS_POLICIES.VENDOR_SITE_ID PO_VENDOR_SITES_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_INS_LINES.ASSET_POLICY_ID FA_INS_POLICIES
FA_INS_MST_POLS.ASSET_POLICY_ID FA_INS_POLICIES
FA_INS_VALUES.ASSET_POLICY_ID FA_INS_POLICIES

[top of page]

FA.FA_INS_POLICIES does not reference any database object

FA.FA_INS_POLICIES is referenced by following:

APPS
SYNONYM - FA_INS_POLICIES

[top of page]

Table: FA_INS_VALUES

Description: Stores insurance indexation details
Primary Key: FA_INS_VALUES_PK
  1. INDEXATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_INS_VALUES.ASSET_POLICY_ID FA_INS_POLICIES
FA_INS_VALUES.REQUEST_ID FND_CONCURRENT_REQUESTS
FA_INS_VALUES.ASSET_ID FA_ADDITIONS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_INS_POLICIES.LAST_INDEXATION_ID FA_INS_VALUES

[top of page]

FA.FA_INS_VALUES does not reference any database object

FA.FA_INS_VALUES is referenced by following:

APPS
SYNONYM - FA_INS_VALUES

[top of page]

Table: FA_INVENTORY

Description: Physical Inventory entry
Primary Key: FA_INVENTORY_PK
  1. INVENTORY_NAME
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_INV_INTERFACE.INVENTORY_NAME FA_INVENTORY

[top of page]

FA.FA_INVENTORY does not reference any database object

FA.FA_INVENTORY is referenced by following:

APPS
SYNONYM - FA_INVENTORY

[top of page]

Table: FA_INVMISS_REP_ITF

Description: Interface table for Report eXchange reports

[top of page]

FA.FA_INVMISS_REP_ITF does not reference any database object

FA.FA_INVMISS_REP_ITF is referenced by following:

APPS
SYNONYM - FA_INVMISS_REP_ITF

[top of page]

Table: FA_INVOICE_TRANSACTIONS

Description: Information about transactions made to invoice lines within Oracle Assets
Primary Key: FA_INVOICE_TRANSACTIONS_PK
  1. INVOICE_TRANSACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_INVOICE_TRANSACTIONS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_ASSET_INVOICES.INVOICE_TRANSACTION_ID_OUT FA_INVOICE_TRANSACTIONS
FA_ASSET_INVOICES.INVOICE_TRANSACTION_ID_IN FA_INVOICE_TRANSACTIONS
FA_MC_ASSET_INVOICES.INVOICE_TRANSACTION_ID_OUT FA_INVOICE_TRANSACTIONS
FA_MC_ASSET_INVOICES.INVOICE_TRANSACTION_ID_IN FA_INVOICE_TRANSACTIONS
FA_MC_BOOKS_RATES.INVOICE_TRANSACTION_ID FA_INVOICE_TRANSACTIONS
FA_TRANSACTION_HEADERS.INVOICE_TRANSACTION_ID FA_INVOICE_TRANSACTIONS
FA_TRX_REFERENCES.INVOICE_TRANSACTION_ID FA_INVOICE_TRANSACTIONS

[top of page]

FA.FA_INVOICE_TRANSACTIONS does not reference any database object

FA.FA_INVOICE_TRANSACTIONS is referenced by following:

APPS
SYNONYM - FA_INVOICE_TRANSACTIONS

[top of page]

Table: FA_INV_COMPARE_REP_ITF

Description: Interface table for Report eXchange reports

[top of page]

FA.FA_INV_COMPARE_REP_ITF does not reference any database object

FA.FA_INV_COMPARE_REP_ITF is referenced by following:

APPS
SYNONYM - FA_INV_COMPARE_REP_ITF

[top of page]

Table: FA_INV_INTERFACE

Description: Open Interface table to Physical Inventory
Primary Key: FA_INV_INTERFACE_PK
  1. INVENTORY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_INV_INTERFACE.INVENTORY_NAME FA_INVENTORY

[top of page]

FA.FA_INV_INTERFACE does not reference any database object

FA.FA_INV_INTERFACE is referenced by following:

APPS
SYNONYM - FA_INV_INTERFACE

[top of page]

Table: FA_ITC_RATES

Description: Investment tax credit (ITC) rate information
Primary Key: FA_ITC_RATES_PK
  1. ITC_AMOUNT_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_BOOKS.ITC_AMOUNT_ID FA_ITC_RATES
FA_MC_BOOKS.ITC_AMOUNT_ID FA_ITC_RATES
FA_TAX_INTERFACE.ITC_AMOUNT_ID FA_ITC_RATES

[top of page]

FA.FA_ITC_RATES does not reference any database object

FA.FA_ITC_RATES is referenced by following:

APPS
SYNONYM - FA_ITC_RATES

[top of page]

Table: FA_ITC_RECAPTURE_RATES

Description: Percentage of Investment Tax Credit (ITC) to recapture for early retirements
Primary Key: FA_ITC_RECAPTURE_RATES_PK
  1. ITC_RECAPTURE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_MC_RETIREMENTS.ITC_RECAPTURE_ID FA_ITC_RECAPTURE_RATES
FA_RETIREMENTS.ITC_RECAPTURE_ID FA_ITC_RECAPTURE_RATES

[top of page]

FA.FA_ITC_RECAPTURE_RATES does not reference any database object

FA.FA_ITC_RECAPTURE_RATES is referenced by following:

APPS
SYNONYM - FA_ITC_RECAPTURE_RATES

[top of page]

Table: FA_ITF_IMPAIRMENTS

Description: FA_ITF_IMPAIRMENTS table gets populated for any candidate assets to be impaired per the impairment transaction stored in FA_IMPAIRMENTS table.

[top of page]

FA.FA_ITF_IMPAIRMENTS does not reference any database object

FA.FA_ITF_IMPAIRMENTS is referenced by following:

APPS
SYNONYM - FA_ITF_IMPAIRMENTS

[top of page]

Table: FA_JOURNAL_ENTRIES

Description: Journal Entry Information
Primary Key: FA_JOURNAL_ENTRIES_PK
  1. CJE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_JOURNAL_ENTRIES.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
FA_JOURNAL_ENTRIES.BOOK_TYPE_CODE
FA_JOURNAL_ENTRIES.PERIOD_COUNTER 		FA_DEPRN_PERIODS

[top of page]

FA.FA_JOURNAL_ENTRIES does not reference any database object

FA.FA_JOURNAL_ENTRIES is referenced by following:

APPS
SYNONYM - FA_JOURNAL_ENTRIES

[top of page]

Table: FA_LEASES

Description: Lease information for leased assets
Primary Key: FA_LEASES_PK
  1. LEASE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_LEASES.LESSOR_ID PO_VENDORS
FA_LEASES.PAYMENT_SCHEDULE_ID FA_LEASE_SCHEDULES
FA_LEASES.CURRENCY_CODE FND_CURRENCIES
FA_LEASES.LESSOR_SITE_ID PO_VENDOR_SITES_ALL
FA_LEASES.DIST_CODE_COMBINATION_ID GL_CODE_COMBINATIONS
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_ADDITIONS_B.LEASE_ID FA_LEASES
FA_LEASE_PAYMENT_ITEMS.LEASE_ID FA_LEASES

[top of page]

FA.FA_LEASES does not reference any database object

FA.FA_LEASES is referenced by following:

APPS
SYNONYM - FA_LEASES

[top of page]

Table: FA_LEASE_PAYMENTS

Description: Payment schedule detail information
Primary Key: FA_LEASE_PAYMENTS_PK
  1. PAYMENT_SCHEDULE_ID
  2. PAYMENT_LINE_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_LEASE_PAYMENTS.PAYMENT_SCHEDULE_ID FA_LEASE_SCHEDULES

[top of page]

FA.FA_LEASE_PAYMENTS does not reference any database object

FA.FA_LEASE_PAYMENTS is referenced by following:

APPS
SYNONYM - FA_LEASE_PAYMENTS

[top of page]

Table: FA_LEASE_PAYMENT_ITEMS

Description: This table stores all the payment items of leases in Oracle Assets
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_LEASE_PAYMENT_ITEMS.LEASE_ID FA_LEASES

[top of page]

FA.FA_LEASE_PAYMENT_ITEMS does not reference any database object

FA.FA_LEASE_PAYMENT_ITEMS is referenced by following:

APPS
SYNONYM - FA_LEASE_PAYMENT_ITEMS

[top of page]

Table: FA_LEASE_SCHEDULES

Description: Payment schedule information
Primary Key: FA_LEASE_SCHEDULES_PK
  1. PAYMENT_SCHEDULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_LEASE_SCHEDULES.CURRENCY_CODE FND_CURRENCIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_LEASES.PAYMENT_SCHEDULE_ID FA_LEASE_SCHEDULES
FA_LEASE_PAYMENTS.PAYMENT_SCHEDULE_ID FA_LEASE_SCHEDULES

[top of page]

FA.FA_LEASE_SCHEDULES does not reference any database object

FA.FA_LEASE_SCHEDULES is referenced by following:

APPS
SYNONYM - FA_LEASE_SCHEDULES

[top of page]

Table: FA_LIFE_DERIVATION_INFO

Description: This table stores how Life was derived on on Asset from the Inheritance Rules. Stores the Type and tName of the Entity from where the life was derived. This table is populated through a trigger on FA_TRANSACTION_HEADER table

[top of page]

FA.FA_LIFE_DERIVATION_INFO does not reference any database object

FA.FA_LIFE_DERIVATION_INFO is referenced by following:

APPS
SYNONYM - FA_LIFE_DERIVATION_INFO

[top of page]

Table: FA_LOCATIONS

Description: Location flexfield segment value combinations
Primary Key: FA_LOCATIONS_PK
  1. LOCATION_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSI_A_LOCATIONS.FA_LOCATION_ID FA_LOCATIONS
CSI_I_ASSETS.FA_LOCATION_ID FA_LOCATIONS
CUN_LOCATIONS.FA_LOCATION_ID FA_LOCATIONS
FA_DISTRIBUTION_DEFAULTS.LOCATION_ID FA_LOCATIONS
FA_DISTRIBUTION_HISTORY.LOCATION_ID FA_LOCATIONS
FA_MAINT_SCHEDULE_HDR.LOCATION_ID FA_LOCATIONS
FA_MASSADD_DISTRIBUTIONS.LOCATION_ID FA_LOCATIONS
FA_MASS_ADDITIONS.LOCATION_ID FA_LOCATIONS
FA_LOCATIONS
FA_MASS_EXT_RETIREMENTS.LOCATION_ID FA_LOCATIONS
FA_MASS_RECLASS.LOCATION_ID FA_LOCATIONS
FA_MASS_RETIREMENTS.LOCATION_ID FA_LOCATIONS
FA_MASS_TRANSFERS.FROM_LOCATION_ID FA_LOCATIONS
FA_MASS_TRANSFERS.TO_LOCATION_ID FA_LOCATIONS
IA_REQUEST_DETAILS.TO_LOCATION_ID FA_LOCATIONS

[top of page]

FA.FA_LOCATIONS does not reference any database object

FA.FA_LOCATIONS is referenced by following:

APPS
SYNONYM - FA_LOCATIONS

[top of page]

Table: FA_LOOKUPS_B

Description: Seeded and user-defined values for QuickCodes (base MLS table)
Primary Key: FA_LOOKUPS_B_PK
  1. LOOKUP_TYPE
  2. LOOKUP_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_LOOKUPS_B.LOOKUP_TYPE FA_LOOKUP_TYPES_B

[top of page]

FA.FA_LOOKUPS_B does not reference any database object

FA.FA_LOOKUPS_B is referenced by following:

APPS
SYNONYM - FA_LOOKUPS_B

[top of page]

Table: FA_LOOKUPS_TL

Description: Seeded and user-defined values for QuickCodes (translated MLS table)
Primary Key: FA_LOOKUPS_TL_PK
  1. LOOKUP_TYPE
  2. LOOKUP_CODE
  3. LANGUAGE

[top of page]

FA.FA_LOOKUPS_TL does not reference any database object

FA.FA_LOOKUPS_TL is referenced by following:

APPS
SYNONYM - FA_LOOKUPS_TL

[top of page]

Table: FA_LOOKUP_TYPES_B

Description: Information about QuickCodes (base MLS table)
Primary Key: FA_LOOKUP_TYPES_B_PK
  1. LOOKUP_TYPE
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_LOOKUPS_B.LOOKUP_TYPE FA_LOOKUP_TYPES_B

[top of page]

FA.FA_LOOKUP_TYPES_B does not reference any database object

FA.FA_LOOKUP_TYPES_B is referenced by following:

APPS
SYNONYM - FA_LOOKUP_TYPES_B

[top of page]

Table: FA_LOOKUP_TYPES_TL

Description: Information about QuickCodes (translated MLS table)
Primary Key: FA_LOOKUP_TYPES_TL_PK
  1. LOOKUP_TYPE
  2. LANGUAGE

[top of page]

FA.FA_LOOKUP_TYPES_TL does not reference any database object

FA.FA_LOOKUP_TYPES_TL is referenced by following:

APPS
SYNONYM - FA_LOOKUP_TYPES_TL

[top of page]

Table: FA_MAINT_EVENTS

Description: Stores scheduled events
Primary Key: FA_MAINT_EVENTS_PK
  1. ASSET_EVENT_ID
  2. ASSET_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_MAINT_EVENTS.ASSET_ID FA_ADDITIONS_B
FA_MAINT_EVENTS.VENDOR_ID PO_VENDORS
FA_MAINT_EVENTS.BOOK_TYPE_CODE FA_BOOK_CONTROLS

[top of page]

FA.FA_MAINT_EVENTS does not reference any database object

FA.FA_MAINT_EVENTS is referenced by following:

APPS
SYNONYM - FA_MAINT_EVENTS

[top of page]

Table: FA_MAINT_REP_ITF

Description: Interface table for Report eXchange reports

[top of page]

FA.FA_MAINT_REP_ITF does not reference any database object

FA.FA_MAINT_REP_ITF is referenced by following:

APPS
SYNONYM - FA_MAINT_REP_ITF

[top of page]

Table: FA_MAINT_SCHEDULE_DTL

Description: Stores detail information for scheduling
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_MAINT_SCHEDULE_DTL.VENDOR_ID PO_VENDORS

[top of page]

FA.FA_MAINT_SCHEDULE_DTL does not reference any database object

FA.FA_MAINT_SCHEDULE_DTL is referenced by following:

APPS
SYNONYM - FA_MAINT_SCHEDULE_DTL

[top of page]

Table: FA_MAINT_SCHEDULE_HDR

Description: Stores information about maintenance scheduling requests
Primary Key: FA_MAINT_SCHEDULE_HDR_PK
  1. SCHEDULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_MAINT_SCHEDULE_HDR.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MAINT_SCHEDULE_HDR.FROM_ASSET_NUMBER FA_ADDITIONS_B
FA_MAINT_SCHEDULE_HDR.TO_ASSET_NUMBER FA_ADDITIONS_B
FA_MAINT_SCHEDULE_HDR.CATEGORY_ID FA_CATEGORIES_B
FA_MAINT_SCHEDULE_HDR.LOCATION_ID FA_LOCATIONS
FA_MAINT_SCHEDULE_HDR.CURRENCY_CODE FND_CURRENCIES
FA_MAINT_SCHEDULE_HDR.CONCURRENT_REQUEST_ID FND_CONCURRENT_REQUESTS

[top of page]

FA.FA_MAINT_SCHEDULE_HDR does not reference any database object

FA.FA_MAINT_SCHEDULE_HDR is referenced by following:

APPS
SYNONYM - FA_MAINT_SCHEDULE_HDR

[top of page]

Table: FA_MASSADD_DISTRIBUTIONS

Description: Distribution information for each mass addition line
Primary Key: FA_MASSADD_DISTRIBUTIONS_PK
  1. MASSADD_DIST_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_MASSADD_DISTRIBUTIONS.MASS_ADDITION_ID FA_MASS_ADDITIONS
FA_MASSADD_DISTRIBUTIONS.LOCATION_ID FA_LOCATIONS
FA_MASSADD_DISTRIBUTIONS.DEPRN_EXPENSE_CCID GL_CODE_COMBINATIONS

[top of page]

FA.FA_MASSADD_DISTRIBUTIONS does not reference any database object

FA.FA_MASSADD_DISTRIBUTIONS is referenced by following:

APPS
SYNONYM - FA_MASSADD_DISTRIBUTIONS

[top of page]

Table: FA_MASSADD_REP_ITF

Description: Interface table for Report eXchange reports
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_MASSADD_REP_ITF.GROUP_ASSET_NUMBER FA_ADDITIONS_B
FA_MASSADD_REP_ITF.PO_DISTRIBUTION_ID PO_DISTRIBUTIONS_ALL

[top of page]

FA.FA_MASSADD_REP_ITF does not reference any database object

FA.FA_MASSADD_REP_ITF is referenced by following:

APPS
SYNONYM - FA_MASSADD_REP_ITF

[top of page]

Table: FA_MASS_ADDITIONS

Description: Information about assets that you want to automatically add to Oracle Assets from another system
Primary Key: FA_MASS_ADDITIONS_PK
  1. MASS_ADDITION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_MASS_ADDITIONS.ADD_TO_ASSET_ID FA_ADDITIONS_B
FA_MASS_ADDITIONS.PO_VENDOR_ID PO_VENDORS
FA_MASS_ADDITIONS.POST_BATCH_ID FND_CONCURRENT_REQUESTS
FA_MASS_ADDITIONS.INVOICE_ID
FA_MASS_ADDITIONS.AP_DISTRIBUTION_LINE_NUMBER 		AP_INVOICE_DISTRIBUTIONS_ALL
FA_MASS_ADDITIONS.INVOICE_ID AP_INVOICES_ALL
FA_MASS_ADDITIONS.ASSET_NUMBER FA_ADDITIONS_B
FA_MASS_ADDITIONS.PARENT_ASSET_ID FA_ADDITIONS_B
FA_MASS_ADDITIONS.PARENT_MASS_ADDITION_ID FA_MASS_ADDITIONS
FA_MASS_ADDITIONS.ASSET_KEY_CCID FA_ASSET_KEYWORDS
FA_MASS_ADDITIONS.PROJECT_ID PA_PROJECTS_ALL
FA_MASS_ADDITIONS.ASSET_CATEGORY_ID FA_CATEGORIES_B
FA_MASS_ADDITIONS.TASK_ID PA_TASKS
FA_MASS_ADDITIONS.PROJECT_ASSET_LINE_ID PA_PROJECT_ASSET_LINES_ALL
FA_MASS_ADDITIONS.PO_DISTRIBUTION_ID PO_DISTRIBUTIONS_ALL
FA_MASS_ADDITIONS.REQUEST_ID FND_CONCURRENT_REQUESTS
FA_MASS_ADDITIONS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MASS_ADDITIONS.PAYABLES_CODE_COMBINATION_ID GL_CODE_COMBINATIONS
FA_MASS_ADDITIONS.EXPENSE_CODE_COMBINATION_ID GL_CODE_COMBINATIONS
FA_MASS_ADDITIONS.LOCATION_ID FA_LOCATIONS
FA_MASS_ADDITIONS.CREATE_BATCH_ID FND_CONCURRENT_REQUESTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_ASSET_INVOICES.PARENT_MASS_ADDITION_ID FA_MASS_ADDITIONS
FA_ASSET_INVOICES.MERGE_PARENT_MASS_ADDITIONS_ID FA_MASS_ADDITIONS
FA_ASSET_INVOICES.SPLIT_PARENT_MASS_ADDITIONS_ID FA_MASS_ADDITIONS
FA_DELETED_MASS_ADDITIONS.MASS_ADDITION_ID FA_MASS_ADDITIONS
FA_MASSADD_DISTRIBUTIONS.MASS_ADDITION_ID FA_MASS_ADDITIONS
FA_MASS_ADDITIONS.PARENT_MASS_ADDITION_ID FA_MASS_ADDITIONS
FA_MC_MASS_RATES.MASS_ADDITION_ID FA_MASS_ADDITIONS
FA_MC_MASS_RATES.PARENT_MASS_ADDITION_ID FA_MASS_ADDITIONS
JAI_FA_MASS_ADDITIONS.MASS_ADDITION_ID FA_MASS_ADDITIONS

[top of page]

FA.FA_MASS_ADDITIONS does not reference any database object

FA.FA_MASS_ADDITIONS is referenced by following:

APPS
SYNONYM - FA_MASS_ADDITIONS
TRIGGER - FA_MASS_ADDITIONS_BRI
TRIGGER - FA_MASS_ADDITIONS_BRU
TRIGGER - FA_MASS_ADDITIONS_DELETE_DIST
TRIGGER - FA_MASS_ADDITIONS_INSERT_DIST
TRIGGER - FA_MASS_ADDITIONS_INSERT_NAME
TRIGGER - FA_MASS_ADDITIONS_UPDATE_DIST
TRIGGER - JAI_FA_MA_ARIUD_T1
TRIGGER - JAI_FA_MA_BRIUD_T1

[top of page]

Table: FA_MASS_ADDITIONS_GT

Description:

[top of page]

FA.FA_MASS_ADDITIONS_GT does not reference any database object

FA.FA_MASS_ADDITIONS_GT is referenced by following:

APPS
SYNONYM - FA_MASS_ADDITIONS_GT

[top of page]

Table: FA_MASS_CHANGES

Description: Mass change request information
Primary Key: FA_MASS_CHANGES_PK
  1. MASS_CHANGE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_MASS_CHANGES.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MASS_CHANGES.FROM_GROUP_ASSET_ID FA_ADDITIONS_B
FA_MASS_CHANGES.TO_GROUP_ASSET_ID FA_ADDITIONS_B
FA_MASS_CHANGES.FROM_ASSET_NUMBER FA_ADDITIONS_B
FA_MASS_CHANGES.TO_ASSET_NUMBER FA_ADDITIONS_B
FA_MASS_CHANGES.FROM_CONVENTION FA_CONVENTION_TYPES
FA_MASS_CHANGES.TO_CONVENTION FA_CONVENTION_TYPES
FA_MASS_CHANGES.FROM_METHOD_CODE
FA_MASS_CHANGES.FROM_LIFE_IN_MONTHS 		FA_METHODS
FA_MASS_CHANGES.TO_METHOD_CODE
FA_MASS_CHANGES.TO_LIFE_IN_MONTHS 		FA_METHODS
FA_MASS_CHANGES.CONCURRENT_REQUEST_ID FND_CONCURRENT_REQUESTS
FA_MASS_CHANGES.CATEGORY_ID FA_CATEGORIES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_MASS_CHANGES_ITF.MASS_CHANGE_ID FA_MASS_CHANGES

[top of page]

FA.FA_MASS_CHANGES does not reference any database object

FA.FA_MASS_CHANGES is referenced by following:

APPS
SYNONYM - FA_MASS_CHANGES

[top of page]

Table: FA_MASS_CHANGES_ITF

Description: Interface table for Report eXchange reports
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_MASS_CHANGES_ITF.MASS_CHANGE_ID FA_MASS_CHANGES
FA_MASS_CHANGES_ITF.TO_BONUS_RULE FA_BONUS_RULES
FA_MASS_CHANGES_ITF.FROM_GROUP_ASSET_NUMBER FA_ADDITIONS_B
FA_MASS_CHANGES_ITF.TO_GROUP_ASSET_NUMBER FA_ADDITIONS_B
FA_MASS_CHANGES_ITF.ASSET_ID FA_ADDITIONS_B
FA_MASS_CHANGES_ITF.ASSET_NUMBER FA_ADDITIONS_B
FA_MASS_CHANGES_ITF.BOOK FA_BOOK_CONTROLS
FA_MASS_CHANGES_ITF.FROM_CONVENTION FA_CONVENTION_TYPES
FA_MASS_CHANGES_ITF.TO_CONVENTION FA_CONVENTION_TYPES
FA_MASS_CHANGES_ITF.FROM_BONUS_RULE FA_BONUS_RULES

[top of page]

FA.FA_MASS_CHANGES_ITF does not reference any database object

FA.FA_MASS_CHANGES_ITF is referenced by following:

APPS
SYNONYM - FA_MASS_CHANGES_ITF

[top of page]

Table: FA_MASS_EXTERNAL_TRANSFERS

Description: Interface Table for Mass External Transfers
Primary Key: FA_MASS_EXTERNAL_TRANSFERS_U1
  1. MASS_EXTERNAL_TRANSFER_ID

[top of page]

FA.FA_MASS_EXTERNAL_TRANSFERS does not reference any database object

FA.FA_MASS_EXTERNAL_TRANSFERS is referenced by following:

APPS
SYNONYM - FA_MASS_EXTERNAL_TRANSFERS

[top of page]

Table: FA_MASS_EXT_RETIREMENTS

Description: Mass external retirements interface table.
Primary Key: FA_MASS_EXT_RETIRE_U1
  1. MASS_EXTERNAL_RETIRE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_MASS_EXT_RETIREMENTS.DISTRIBUTION_ID FA_DISTRIBUTION_HISTORY
FA_MASS_EXT_RETIREMENTS.CODE_COMBINATION_ID GL_CODE_COMBINATIONS
FA_MASS_EXT_RETIREMENTS.LOCATION_ID FA_LOCATIONS
FA_MASS_EXT_RETIREMENTS.REQUEST_ID FND_CONCURRENT_REQUESTS

[top of page]

FA.FA_MASS_EXT_RETIREMENTS does not reference any database object

FA.FA_MASS_EXT_RETIREMENTS is referenced by following:

APPS
SYNONYM - FA_MASS_EXT_RETIREMENTS

[top of page]

Table: FA_MASS_EXT_RET_EXCEPTS

Description: Mass external retirements interface - exceptions.

[top of page]

FA.FA_MASS_EXT_RET_EXCEPTS does not reference any database object

FA.FA_MASS_EXT_RET_EXCEPTS is referenced by following:

APPS
SYNONYM - FA_MASS_EXT_RET_EXCEPTS

[top of page]

Table: FA_MASS_RECLASS

Description: Mass reclass request information
Primary Key: FA_MASS_RECLASS_PK
  1. MASS_RECLASS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_MASS_RECLASS.FROM_ASSET_NUMBER FA_ADDITIONS_B
FA_MASS_RECLASS.TO_ASSET_NUMBER FA_ADDITIONS_B
FA_MASS_RECLASS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MASS_RECLASS.LOCATION_ID FA_LOCATIONS
FA_MASS_RECLASS.CONCURRENT_REQUEST_ID FND_CONCURRENT_REQUESTS
FA_MASS_RECLASS.FROM_CATEGORY_ID FA_CATEGORIES_B
FA_MASS_RECLASS.TO_CATEGORY_ID FA_CATEGORIES_B
FA_MASS_RECLASS.ASSET_KEY_ID FA_ASSET_KEYWORDS
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_MASS_RECLASS_ITF.MASS_RECLASS_ID FA_MASS_RECLASS

[top of page]

FA.FA_MASS_RECLASS does not reference any database object

FA.FA_MASS_RECLASS is referenced by following:

APPS
SYNONYM - FA_MASS_RECLASS

[top of page]

Table: FA_MASS_RECLASS_ITF

Description: Interface table for Report eXchange reports
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_MASS_RECLASS_ITF.ASSET_ID FA_ADDITIONS_B
FA_MASS_RECLASS_ITF.ASSET_NUMBER FA_ADDITIONS_B
FA_MASS_RECLASS_ITF.BOOK FA_BOOK_CONTROLS
FA_MASS_RECLASS_ITF.REQUEST_ID FND_CONCURRENT_REQUESTS
FA_MASS_RECLASS_ITF.CONVENTION FA_CONVENTION_TYPES
FA_MASS_RECLASS_ITF.CEILING FA_CEILING_TYPES
FA_MASS_RECLASS_ITF.MASS_RECLASS_ID FA_MASS_RECLASS
FA_MASS_RECLASS_ITF.METHOD FA_METHODS

[top of page]

FA.FA_MASS_RECLASS_ITF does not reference any database object

FA.FA_MASS_RECLASS_ITF is referenced by following:

APPS
SYNONYM - FA_MASS_RECLASS_ITF

[top of page]

Table: FA_MASS_RETIREMENTS

Description: FA_MASS_RETIREMENT contains information about your mass retirement and mass reinstatement processes.
Primary Key: FA_MASS_RETIREMENTS_PK
  1. MASS_RETIREMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_MASS_RETIREMENTS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MASS_RETIREMENTS.PROJECT_ID PA_PROJECTS_ALL
FA_MASS_RETIREMENTS.TASK_ID PA_TASKS
FA_MASS_RETIREMENTS.RETIRE_REQUEST_ID FND_CONCURRENT_REQUESTS
FA_MASS_RETIREMENTS.REINSTATE_REQUEST_ID FND_CONCURRENT_REQUESTS
FA_MASS_RETIREMENTS.LOCATION_ID FA_LOCATIONS
FA_MASS_RETIREMENTS.CATEGORY_ID FA_CATEGORIES_B
FA_MASS_RETIREMENTS.FROM_ASSET_NUMBER FA_ADDITIONS_B
FA_MASS_RETIREMENTS.TO_ASSET_NUMBER FA_ADDITIONS_B
FA_MASS_RETIREMENTS.CREATE_REQUEST_ID FND_CONCURRENT_REQUESTS

[top of page]

FA.FA_MASS_RETIREMENTS does not reference any database object

FA.FA_MASS_RETIREMENTS is referenced by following:

APPS
SYNONYM - FA_MASS_RETIREMENTS

[top of page]

Table: FA_MASS_RET_EXCEPTS

Description: Information about assets that could not be retired as part of a mass retirement transaction

[top of page]

FA.FA_MASS_RET_EXCEPTS does not reference any database object

FA.FA_MASS_RET_EXCEPTS is referenced by following:

APPS
SYNONYM - FA_MASS_RET_EXCEPTS

[top of page]

Table: FA_MASS_REVALUATIONS

Description: Mass revaluation request status information
Primary Key: FA_MASS_REVALUATIONS_PK
  1. MASS_REVAL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_MASS_REVALUATIONS.LAST_REQUEST_ID FND_CONCURRENT_REQUESTS
FA_MASS_REVALUATIONS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_MASS_REVALUATION_RULES.MASS_REVAL_ID FA_MASS_REVALUATIONS
FA_MASS_REVAL_REP_ITF.MASS_REVAL_ID FA_MASS_REVALUATIONS

[top of page]

FA.FA_MASS_REVALUATIONS does not reference any database object

FA.FA_MASS_REVALUATIONS is referenced by following:

APPS
SYNONYM - FA_MASS_REVALUATIONS

[top of page]

Table: FA_MASS_REVALUATION_RULES

Description: Mass revaluation request rule information
Primary Key: FA_MASS_REVALUATION_RULES_PK
  1. MASS_REVAL_ID
  2. CATEGORY_ID
  3. ASSET_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_MASS_REVALUATION_RULES.CATEGORY_ID FA_CATEGORIES_B
FA_MASS_REVALUATION_RULES.ASSET_ID FA_ADDITIONS_B
FA_MASS_REVALUATION_RULES.MASS_REVAL_ID FA_MASS_REVALUATIONS

[top of page]

FA.FA_MASS_REVALUATION_RULES does not reference any database object

FA.FA_MASS_REVALUATION_RULES is referenced by following:

APPS
SYNONYM - FA_MASS_REVALUATION_RULES

[top of page]

Table: FA_MASS_REVAL_REP_ITF

Description: Interface table for Mass Revaluation reports
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_MASS_REVAL_REP_ITF.REQUEST_ID FND_CONCURRENT_REQUESTS
FA_MASS_REVAL_REP_ITF.MASS_REVAL_ID FA_MASS_REVALUATIONS
FA_MASS_REVAL_REP_ITF.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MASS_REVAL_REP_ITF.ASSET_ID FA_ADDITIONS_B
FA_MASS_REVAL_REP_ITF.ASSET_NUMBER FA_ADDITIONS_B
FA_MASS_REVAL_REP_ITF.ASSET_CATEGORY_ID FA_CATEGORIES_B

[top of page]

FA.FA_MASS_REVAL_REP_ITF does not reference any database object

FA.FA_MASS_REVAL_REP_ITF is referenced by following:

APPS
SYNONYM - FA_MASS_REVAL_REP_ITF

[top of page]

Table: FA_MASS_TAX_ADJUSTMENTS

Description: Mass depreciation adjustment request information
Primary Key: FA_MASS_TAX_ADJUSTMENTS_PK
  1. MASS_TAX_ADJUSTMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_MASS_TAX_ADJUSTMENTS.ADJUSTED_BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MASS_TAX_ADJUSTMENTS.CONTROL_BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MASS_TAX_ADJUSTMENTS.LAST_REQUEST_ID FND_CONCURRENT_REQUESTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_MASS_TAX_ADJ_REP_T.MASS_TAX_ADJ_ID FA_MASS_TAX_ADJUSTMENTS

[top of page]

FA.FA_MASS_TAX_ADJUSTMENTS does not reference any database object

FA.FA_MASS_TAX_ADJUSTMENTS is referenced by following:

APPS
SYNONYM - FA_MASS_TAX_ADJUSTMENTS

[top of page]

Table: FA_MASS_TAX_ADJ_REP_T

Description: Interface table for Mass Tax Reserve Adjustment Review reports
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_MASS_TAX_ADJ_REP_T.MASS_TAX_ADJ_ID FA_MASS_TAX_ADJUSTMENTS
FA_MASS_TAX_ADJ_REP_T.REQUEST_ID FND_CONCURRENT_REQUESTS
FA_MASS_TAX_ADJ_REP_T.ASSET_ID FA_ADDITIONS_B
FA_MASS_TAX_ADJ_REP_T.ASSET_NUMBER FA_ADDITIONS_B

[top of page]

FA.FA_MASS_TAX_ADJ_REP_T does not reference any database object

FA.FA_MASS_TAX_ADJ_REP_T is referenced by following:

APPS
SYNONYM - FA_MASS_TAX_ADJ_REP_T

[top of page]

Table: FA_MASS_TRANSFERS

Description: Mass transfer request information
Primary Key: FA_MASS_TRANSFERS_PK
  1. MASS_TRANSFER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_MASS_TRANSFERS.CONCURRENT_REQUEST_ID FND_CONCURRENT_REQUESTS
FA_MASS_TRANSFERS.FROM_LOCATION_ID FA_LOCATIONS
FA_MASS_TRANSFERS.TO_LOCATION_ID FA_LOCATIONS
FA_MASS_TRANSFERS.FROM_GL_CCID GL_CODE_COMBINATIONS
FA_MASS_TRANSFERS.TO_GL_CCID GL_CODE_COMBINATIONS
FA_MASS_TRANSFERS.CATEGORY_ID FA_CATEGORIES_B
FA_MASS_TRANSFERS.BOOK_TYPE_CODE FA_BOOK_CONTROLS

[top of page]

FA.FA_MASS_TRANSFERS does not reference any database object

FA.FA_MASS_TRANSFERS is referenced by following:

APPS
SYNONYM - FA_MASS_TRANSFERS

[top of page]

Table: FA_MASS_UPDATE_BATCH_DETAILS

Description: The individual asset changes made as a result of a mass update.

[top of page]

FA.FA_MASS_UPDATE_BATCH_DETAILS does not reference any database object

FA.FA_MASS_UPDATE_BATCH_DETAILS is referenced by following:

APPS
SYNONYM - FA_MASS_UPDATE_BATCH_DETAILS

[top of page]

Table: FA_MASS_UPDATE_BATCH_HEADERS

Description: Contains header information for a mass update. Describes the parameters and selection criteria for the update.

[top of page]

FA.FA_MASS_UPDATE_BATCH_HEADERS does not reference any database object

FA.FA_MASS_UPDATE_BATCH_HEADERS is referenced by following:

APPS
SYNONYM - FA_MASS_UPDATE_BATCH_HEADERS

[top of page]

Table: FA_MC_ADJUSTMENTS

Description: Stores information to create adjustment journal entries in the reporting currency
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_MC_ADJUSTMENTS.TRANSACTION_HEADER_ID FA_TRANSACTION_HEADERS
FA_MC_ADJUSTMENTS.ASSET_ID FA_ADDITIONS_B
FA_MC_ADJUSTMENTS.DISTRIBUTION_ID FA_DISTRIBUTION_HISTORY
FA_MC_ADJUSTMENTS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MC_ADJUSTMENTS.CODE_COMBINATION_ID GL_CODE_COMBINATIONS
FA_MC_ADJUSTMENTS.JE_HEADER_ID
FA_MC_ADJUSTMENTS.JE_LINE_NUM 		GL_JE_LINES
FA_MC_ADJUSTMENTS.BOOK_TYPE_CODE
FA_MC_ADJUSTMENTS.PERIOD_COUNTER_CREATED 		FA_DEPRN_PERIODS
FA_MC_ADJUSTMENTS.BOOK_TYPE_CODE
FA_MC_ADJUSTMENTS.PERIOD_COUNTER_ADJUSTED 		FA_DEPRN_PERIODS

[top of page]

FA.FA_MC_ADJUSTMENTS does not reference any database object

FA.FA_MC_ADJUSTMENTS is referenced by following:

APPS
SYNONYM - FA_MC_ADJUSTMENTS

[top of page]

Table: FA_MC_ASSET_INVOICES

Description: Accounts payable and purchasing information for each asset, in the reporting currency
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_MC_ASSET_INVOICES.ASSET_ID FA_ADDITIONS_B
FA_MC_ASSET_INVOICES.INVOICE_TRANSACTION_ID_OUT FA_INVOICE_TRANSACTIONS
FA_MC_ASSET_INVOICES.PROJECT_ID PA_PROJECTS_ALL
FA_MC_ASSET_INVOICES.TASK_ID PA_TASKS
FA_MC_ASSET_INVOICES.PROJECT_ASSET_LINE_ID PA_PROJECT_ASSET_LINES_ALL
FA_MC_ASSET_INVOICES.PO_DISTRIBUTION_ID PO_DISTRIBUTIONS_ALL
FA_MC_ASSET_INVOICES.INVOICE_TRANSACTION_ID_IN FA_INVOICE_TRANSACTIONS
FA_MC_ASSET_INVOICES.PO_VENDOR_ID PO_VENDORS
FA_MC_ASSET_INVOICES.PO_NUMBER PO_HEADERS_ALL
FA_MC_ASSET_INVOICES.PAYABLES_CODE_COMBINATION_ID GL_CODE_COMBINATIONS
FA_MC_ASSET_INVOICES.CREATE_BATCH_ID FND_CONCURRENT_REQUESTS
FA_MC_ASSET_INVOICES.POST_BATCH_ID FND_CONCURRENT_REQUESTS
FA_MC_ASSET_INVOICES.INVOICE_ID AP_INVOICES_ALL
FA_MC_ASSET_INVOICES.INVOICE_ID
FA_MC_ASSET_INVOICES.AP_DISTRIBUTION_LINE_NUMBER 		AP_INVOICE_DISTRIBUTIONS_ALL

[top of page]

FA.FA_MC_ASSET_INVOICES does not reference any database object

FA.FA_MC_ASSET_INVOICES is referenced by following:

APPS
SYNONYM - FA_MC_ASSET_INVOICES

[top of page]

Table: FA_MC_BOOKS

Description: Financial information for each asset in the reporting currency
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_MC_BOOKS.BOOK_TYPE_CODE
FA_MC_BOOKS.SET_OF_BOOKS_ID 		FA_MC_BOOK_CONTROLS
FA_MC_BOOKS.CEILING_NAME FA_CEILING_TYPES
FA_MC_BOOKS.BOOK_TYPE_CODE
FA_MC_BOOKS.PERIOD_COUNTER_CAPITALIZED
FA_MC_BOOKS.SET_OF_BOOKS_ID 		FA_MC_DEPRN_PERIODS
FA_MC_BOOKS.BOOK_TYPE_CODE
FA_MC_BOOKS.PERIOD_COUNTER_FULLY_RETIRED
FA_MC_BOOKS.SET_OF_BOOKS_ID 		FA_MC_DEPRN_PERIODS
FA_MC_BOOKS.PRORATE_CONVENTION_CODE FA_CONVENTION_TYPES
FA_MC_BOOKS.DEPRN_METHOD_CODE
FA_MC_BOOKS.LIFE_IN_MONTHS 		FA_METHODS
FA_MC_BOOKS.SUPER_GROUP_ID FA_SUPER_GROUPS
FA_MC_BOOKS.ASSET_ID FA_ADDITIONS_B
FA_MC_BOOKS.TRANSACTION_HEADER_ID_IN FA_TRANSACTION_HEADERS
FA_MC_BOOKS.TRANSACTION_HEADER_ID_OUT FA_TRANSACTION_HEADERS
FA_MC_BOOKS.BOOK_TYPE_CODE
FA_MC_BOOKS.PERIOD_COUNTER_FULLY_RESERVED
FA_MC_BOOKS.SET_OF_BOOKS_ID 		FA_MC_DEPRN_PERIODS
FA_MC_BOOKS.BOOK_TYPE_CODE
FA_MC_BOOKS.PERIOD_COUNTER_LIFE_COMPLETE
FA_MC_BOOKS.SET_OF_BOOKS_ID 		FA_MC_DEPRN_PERIODS
FA_MC_BOOKS.ITC_AMOUNT_ID FA_ITC_RATES
FA_MC_BOOKS.RETIREMENT_ID
FA_MC_BOOKS.SET_OF_BOOKS_ID 		FA_MC_RETIREMENTS
FA_MC_BOOKS.BONUS_RULE FA_BONUS_RULES

[top of page]

FA.FA_MC_BOOKS does not reference any database object

FA.FA_MC_BOOKS is referenced by following:

APPS
SYNONYM - FA_MC_BOOKS

[top of page]

Table: FA_MC_BOOKS_GROUPS

Description:

[top of page]

FA.FA_MC_BOOKS_GROUPS does not reference any database object

FA.FA_MC_BOOKS_GROUPS is referenced by following:

APPS
SYNONYM - FA_MC_BOOKS_GROUPS

[top of page]

Table: FA_MC_BOOKS_RATES

Description: Exchange rate information
Primary Key: FA_MC_BOOKS_RATES_U1
  1. SET_OF_BOOKS_ID
  2. TRANSACTION_HEADER_ID
  3. INVOICE_TRANSACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_MC_BOOKS_RATES.ASSET_ID FA_ADDITIONS_B
FA_MC_BOOKS_RATES.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MC_BOOKS_RATES.TRANSACTION_HEADER_ID FA_TRANSACTION_HEADERS
FA_MC_BOOKS_RATES.INVOICE_TRANSACTION_ID FA_INVOICE_TRANSACTIONS
FA_MC_BOOKS_RATES.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I

[top of page]

FA.FA_MC_BOOKS_RATES does not reference any database object

FA.FA_MC_BOOKS_RATES is referenced by following:

APPS
SYNONYM - FA_MC_BOOKS_RATES

[top of page]

Table: FA_MC_BOOKS_SUMMARY

Description: This table stores financial and depreciation information at the asset level.

[top of page]

FA.FA_MC_BOOKS_SUMMARY does not reference any database object

FA.FA_MC_BOOKS_SUMMARY is referenced by following:

APPS
SYNONYM - FA_MC_BOOKS_SUMMARY

[top of page]

Table: FA_MC_BOOK_CONTROLS

Description: Control information that affects all assets in a reporting depreciation book
Primary Key: FA_MC_BOOK_CONTROLS_PK
  1. BOOK_TYPE_CODE
  2. SET_OF_BOOKS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_MC_BOOK_CONTROLS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MC_BOOK_CONTROLS.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
FA_MC_BOOK_CONTROLS.PRIMARY_SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
FA_MC_BOOK_CONTROLS.CURRENCY_CODE FND_CURRENCIES
FA_MC_BOOK_CONTROLS.PRIMARY_CURRENCY_CODE FND_CURRENCIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_MC_BOOKS.BOOK_TYPE_CODE
FA_MC_BOOKS.SET_OF_BOOKS_ID 		FA_MC_BOOK_CONTROLS
FA_MC_RETIREMENTS.BOOK_TYPE_CODE
FA_MC_RETIREMENTS.SET_OF_BOOKS_ID 		FA_MC_BOOK_CONTROLS

[top of page]

FA.FA_MC_BOOK_CONTROLS does not reference any database object

FA.FA_MC_BOOK_CONTROLS is referenced by following:

APPS
SYNONYM - FA_MC_BOOK_CONTROLS

[top of page]

Table: FA_MC_CONVERSION_HISTORY

Description: Table to store the conversion history of primary to reporting books
Primary Key: FA_MC_CONVERSION_HISTORY_PK
  1. SET_OF_BOOKS_ID
  2. BOOK_TYPE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_MC_CONVERSION_HISTORY.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MC_CONVERSION_HISTORY.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
FA_MC_CONVERSION_HISTORY.BOOK_TYPE_CODE
FA_MC_CONVERSION_HISTORY.PERIOD_COUNTER_CONVERTED 		FA_DEPRN_PERIODS
FA_MC_CONVERSION_HISTORY.BOOK_TYPE_CODE
FA_MC_CONVERSION_HISTORY.PERIOD_COUNTER_SELECTED 		FA_DEPRN_PERIODS
FA_MC_CONVERSION_HISTORY.BOOK_TYPE_CODE
FA_MC_CONVERSION_HISTORY.PERIOD_COUNTER_START 		FA_DEPRN_PERIODS

[top of page]

FA.FA_MC_CONVERSION_HISTORY does not reference any database object

FA.FA_MC_CONVERSION_HISTORY is referenced by following:

APPS
SYNONYM - FA_MC_CONVERSION_HISTORY

[top of page]

Table: FA_MC_CONVERSION_RATES

Description: Table to store the exchange rate information to convert assets from primary to reporting book
Primary Key: FA_MC_CONVERSION_RATES_PK
  1. ASSET_ID
  2. SET_OF_BOOKS_ID
  3. BOOK_TYPE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_MC_CONVERSION_RATES.ASSET_ID FA_ADDITIONS_B
FA_MC_CONVERSION_RATES.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MC_CONVERSION_RATES.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
FA_MC_CONVERSION_RATES.BOOK_TYPE_CODE
FA_MC_CONVERSION_RATES.LAST_PERIOD_COUNTER 		FA_DEPRN_PERIODS

[top of page]

FA.FA_MC_CONVERSION_RATES does not reference any database object

FA.FA_MC_CONVERSION_RATES is referenced by following:

APPS
SYNONYM - FA_MC_CONVERSION_RATES

[top of page]

Table: FA_MC_DEFERRED_DEPRN

Description: Deferred depreciation calculated for each distribution line in the reporting currency
Primary Key: FA_MC_DEFERRED_DEPRN_PK
  1. ASSET_ID
  2. TAX_BOOK_TYPE_CODE
  3. TAX_PERIOD_COUNTER
  4. DISTRIBUTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_MC_DEFERRED_DEPRN.CORP_BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MC_DEFERRED_DEPRN.DEFERRED_DEPRN_EXPENSE_CCID GL_CODE_COMBINATIONS
FA_MC_DEFERRED_DEPRN.DEFERRED_DEPRN_RESERVE_CCID GL_CODE_COMBINATIONS
FA_MC_DEFERRED_DEPRN.TAX_BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MC_DEFERRED_DEPRN.ASSET_ID FA_ADDITIONS_B
FA_MC_DEFERRED_DEPRN.DISTRIBUTION_ID FA_DISTRIBUTION_HISTORY
FA_MC_DEFERRED_DEPRN.JE_HEADER_ID GL_JE_HEADERS
FA_MC_DEFERRED_DEPRN.JE_HEADER_ID
FA_MC_DEFERRED_DEPRN.EXPENSE_JE_LINE_NUM 		GL_JE_LINES
FA_MC_DEFERRED_DEPRN.JE_HEADER_ID
FA_MC_DEFERRED_DEPRN.RESERVE_JE_LINE_NUM 		GL_JE_LINES

[top of page]

FA.FA_MC_DEFERRED_DEPRN does not reference any database object

FA.FA_MC_DEFERRED_DEPRN is referenced by following:

APPS
SYNONYM - FA_MC_DEFERRED_DEPRN

[top of page]

Table: FA_MC_DEPRN_DETAIL

Description: Depreciation amounts in the reporting currency, charged to the depreciation expense account in each distribution line
Primary Key: FA_MC_DEPRN_DETAIL_PK
  1. BOOK_TYPE_CODE
  2. ASSET_ID
  3. PERIOD_COUNTER
  4. DISTRIBUTION_ID
  5. SET_OF_BOOKS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_MC_DEPRN_DETAIL.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MC_DEPRN_DETAIL.DEPRN_EXPENSE_CCID GL_CODE_COMBINATIONS
FA_MC_DEPRN_DETAIL.DEPRN_RESERVE_CCID GL_CODE_COMBINATIONS
FA_MC_DEPRN_DETAIL.BONUS_DEPRN_EXPENSE_CCID GL_CODE_COMBINATIONS
FA_MC_DEPRN_DETAIL.BONUS_DEPRN_RESERVE_CCID GL_CODE_COMBINATIONS
FA_MC_DEPRN_DETAIL.REVAL_AMORT_CCID GL_CODE_COMBINATIONS
FA_MC_DEPRN_DETAIL.REVAL_RESERVE_CCID GL_CODE_COMBINATIONS
FA_MC_DEPRN_DETAIL.ASSET_ID FA_ADDITIONS_B
FA_MC_DEPRN_DETAIL.DISTRIBUTION_ID FA_DISTRIBUTION_HISTORY
FA_MC_DEPRN_DETAIL.BOOK_TYPE_CODE
FA_MC_DEPRN_DETAIL.PERIOD_COUNTER 		FA_DEPRN_PERIODS
FA_MC_DEPRN_DETAIL.JE_HEADER_ID
FA_MC_DEPRN_DETAIL.DEPRN_EXPENSE_JE_LINE_NUM 		GL_JE_LINES
FA_MC_DEPRN_DETAIL.JE_HEADER_ID
FA_MC_DEPRN_DETAIL.DEPRN_RESERVE_JE_LINE_NUM 		GL_JE_LINES
FA_MC_DEPRN_DETAIL.JE_HEADER_ID
FA_MC_DEPRN_DETAIL.REVAL_AMORT_JE_LINE_NUM 		GL_JE_LINES
FA_MC_DEPRN_DETAIL.JE_HEADER_ID
FA_MC_DEPRN_DETAIL.REVAL_RESERVE_JE_LINE_NUM 		GL_JE_LINES
FA_MC_DEPRN_DETAIL.JE_HEADER_ID GL_JE_HEADERS

[top of page]

FA.FA_MC_DEPRN_DETAIL does not reference any database object

FA.FA_MC_DEPRN_DETAIL is referenced by following:

APPS
SYNONYM - FA_MC_DEPRN_DETAIL

[top of page]

Table: FA_MC_DEPRN_DETAIL_H

Description: Stores the depreciation information originally stored in FA_MC_DEPRN_DETAIL for audit purposes.

[top of page]

FA.FA_MC_DEPRN_DETAIL_H does not reference any database object

FA.FA_MC_DEPRN_DETAIL_H is referenced by following:

APPS
SYNONYM - FA_MC_DEPRN_DETAIL_H

[top of page]

Table: FA_MC_DEPRN_PERIODS

Description: Information about each depreciation period
Primary Key: FA_MC_DEPRN_PERIODS_PK
  1. BOOK_TYPE_CODE
  2. PERIOD_COUNTER
  3. SET_OF_BOOKS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_MC_DEPRN_PERIODS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MC_DEPRN_PERIODS.CIP_REVAL_BATCH_ID GL_JE_BATCHES
FA_MC_DEPRN_PERIODS.CIP_TRANSFER_BATCH_ID GL_JE_BATCHES
FA_MC_DEPRN_PERIODS.DEFERRED_DEPRN_BATCH_ID GL_JE_BATCHES
FA_MC_DEPRN_PERIODS.DEPRECIATION_BATCH_ID GL_JE_BATCHES
FA_MC_DEPRN_PERIODS.DEPRN_ADJUSTMENT_BATCH_ID GL_JE_BATCHES
FA_MC_DEPRN_PERIODS.RECLASS_BATCH_ID GL_JE_BATCHES
FA_MC_DEPRN_PERIODS.RETIREMENT_BATCH_ID GL_JE_BATCHES
FA_MC_DEPRN_PERIODS.REVAL_BATCH_ID GL_JE_BATCHES
FA_MC_DEPRN_PERIODS.TRANSFER_BATCH_ID GL_JE_BATCHES
FA_MC_DEPRN_PERIODS.ADDITION_BATCH_ID GL_JE_BATCHES
FA_MC_DEPRN_PERIODS.ADJUSTMENT_BATCH_ID GL_JE_BATCHES
FA_MC_DEPRN_PERIODS.CIP_ADDITION_BATCH_ID GL_JE_BATCHES
FA_MC_DEPRN_PERIODS.CIP_ADJUSTMENT_BATCH_ID GL_JE_BATCHES
FA_MC_DEPRN_PERIODS.CIP_RECLASS_BATCH_ID GL_JE_BATCHES
FA_MC_DEPRN_PERIODS.CIP_RETIREMENT_BATCH_ID GL_JE_BATCHES
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_MC_BOOKS.BOOK_TYPE_CODE
FA_MC_BOOKS.PERIOD_COUNTER_CAPITALIZED
FA_MC_BOOKS.SET_OF_BOOKS_ID 		FA_MC_DEPRN_PERIODS
FA_MC_BOOKS.BOOK_TYPE_CODE
FA_MC_BOOKS.PERIOD_COUNTER_FULLY_RETIRED
FA_MC_BOOKS.SET_OF_BOOKS_ID 		FA_MC_DEPRN_PERIODS
FA_MC_BOOKS.BOOK_TYPE_CODE
FA_MC_BOOKS.PERIOD_COUNTER_FULLY_RESERVED
FA_MC_BOOKS.SET_OF_BOOKS_ID 		FA_MC_DEPRN_PERIODS
FA_MC_BOOKS.BOOK_TYPE_CODE
FA_MC_BOOKS.PERIOD_COUNTER_LIFE_COMPLETE
FA_MC_BOOKS.SET_OF_BOOKS_ID 		FA_MC_DEPRN_PERIODS

[top of page]

FA.FA_MC_DEPRN_PERIODS does not reference any database object

FA.FA_MC_DEPRN_PERIODS is referenced by following:

APPS
SYNONYM - FA_MC_DEPRN_PERIODS

[top of page]

Table: FA_MC_DEPRN_SUMMARY

Description: Depreciation information at the asset level
Primary Key: FA_MC_DEPRN_SUMMARY_PK
  1. BOOK_TYPE_CODE
  2. ASSET_ID
  3. PERIOD_COUNTER
  4. SET_OF_BOOKS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_MC_DEPRN_SUMMARY.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_MC_DEPRN_SUMMARY.ASSET_ID FA_ADDITIONS_B

[top of page]

FA.FA_MC_DEPRN_SUMMARY does not reference any database object

FA.FA_MC_DEPRN_SUMMARY is referenced by following:

APPS
SYNONYM - FA_MC_DEPRN_SUMMARY

[top of page]

Table: FA_MC_DEPRN_SUMMARY_H

Description: Stores the depreciation information originally stored in FA_MC_DEPRN_SUMMARY for audit purposes.

[top of page]

FA.FA_MC_DEPRN_SUMMARY_H does not reference any database object

FA.FA_MC_DEPRN_SUMMARY_H is referenced by following:

APPS
SYNONYM - FA_MC_DEPRN_SUMMARY_H

[top of page]

Table: FA_MC_GROUP_DEPRN_DETAIL

Description:

[top of page]

FA.FA_MC_GROUP_DEPRN_DETAIL does not reference any database object

FA.FA_MC_GROUP_DEPRN_DETAIL is referenced by following:

APPS
SYNONYM - FA_MC_GROUP_DEPRN_DETAIL

[top of page]

Table: FA_MC_GROUP_DEPRN_SUMMARY

Description:

[top of page]

FA.FA_MC_GROUP_DEPRN_SUMMARY does not reference any database object

FA.FA_MC_GROUP_DEPRN_SUMMARY is referenced by following:

APPS
SYNONYM - FA_MC_GROUP_DEPRN_SUMMARY

[top of page]

Table: FA_MC_IMPAIRMENTS

Description:

[top of page]

FA.FA_MC_IMPAIRMENTS does not reference any database object

FA.FA_MC_IMPAIRMENTS is referenced by following:

APPS
SYNONYM - FA_MC_IMPAIRMENTS

[top of page]

Table: FA_MC_ITF_IMPAIRMENTS

Description:

[top of page]

FA.FA_MC_ITF_IMPAIRMENTS does not reference any database object

FA.FA_MC_ITF_IMPAIRMENTS is referenced by following:

APPS
SYNONYM - FA_MC_ITF_IMPAIRMENTS

[top of page]

Table: FA_MC_MASS_RATES

Description: Exchange rate information for mass additions process
Primary Key: FA_MC_MASS_RATES_PK
  1. MASS_ADDITION_ID
  2. SET_OF_BOOKS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_MC_MASS_RATES.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
FA_MC_MASS_RATES.MASS_ADDITION_ID FA_MASS_ADDITIONS
FA_MC_MASS_RATES.PARENT_MASS_ADDITION_ID FA_MASS_ADDITIONS

[top of page]

FA.FA_MC_MASS_RATES does not reference any database object

FA.FA_MC_MASS_RATES is referenced by following:

APPS
SYNONYM - FA_MC_MASS_RATES

[top of page]

Table: FA_MC_RETIREMENTS

Description: Currency and financial information about retirements in each reporting book
Primary Key: FA_MC_RETIREMENTS_PK
  1. RETIREMENT_ID
  2. SET_OF_BOOKS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_MC_RETIREMENTS.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
FA_MC_RETIREMENTS.BOOK_TYPE_CODE
FA_MC_RETIREMENTS.SET_OF_BOOKS_ID 		FA_MC_BOOK_CONTROLS
FA_MC_RETIREMENTS.ASSET_ID FA_ADDITIONS_B
FA_MC_RETIREMENTS.TRANSACTION_HEADER_ID_IN FA_TRANSACTION_HEADERS
FA_MC_RETIREMENTS.TRANSACTION_HEADER_ID_OUT FA_TRANSACTION_HEADERS
FA_MC_RETIREMENTS.ITC_RECAPTURE_ID FA_ITC_RECAPTURE_RATES
FA_MC_RETIREMENTS.RETIREMENT_PRORATE_CONVENTION FA_CONVENTION_TYPES
FA_MC_RETIREMENTS.TRADE_IN_ASSET_ID FA_ADDITIONS_B
FA_MC_RETIREMENTS.STL_METHOD_CODE
FA_MC_RETIREMENTS.STL_LIFE_IN_MONTHS 		FA_METHODS
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_MC_BOOKS.RETIREMENT_ID
FA_MC_BOOKS.SET_OF_BOOKS_ID 		FA_MC_RETIREMENTS

[top of page]

FA.FA_MC_RETIREMENTS does not reference any database object

FA.FA_MC_RETIREMENTS is referenced by following:

APPS
SYNONYM - FA_MC_RETIREMENTS

[top of page]

Table: FA_METHODS

Description: Depreciation method information
Primary Key: FA_METHODS_PK
  1. METHOD_ID
Primary Key: FA_METHODS_UK1
  1. METHOD_CODE
  2. LIFE_IN_MONTHS
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_ACE_BOOKS.DEPRN_METHOD_CODE
FA_ACE_BOOKS.LIFE_IN_MONTHS 		FA_METHODS
FA_BOOKS.DEPRN_METHOD_CODE
FA_BOOKS.LIFE_IN_MONTHS 		FA_METHODS
FA_CATEGORY_BOOK_DEFAULTS.DEPRN_METHOD
FA_CATEGORY_BOOK_DEFAULTS.LIFE_IN_MONTHS 		FA_METHODS
FA_CATEGORY_BOOK_DEFAULTS.STL_METHOD_CODE
FA_CATEGORY_BOOK_DEFAULTS.STL_LIFE_IN_MONTHS 		FA_METHODS
FA_FLAT_RATES.METHOD_ID FA_METHODS
FA_FORMULAS.METHOD_ID FA_METHODS
FA_MASS_CHANGES.FROM_METHOD_CODE
FA_MASS_CHANGES.FROM_LIFE_IN_MONTHS 		FA_METHODS
FA_MASS_CHANGES.TO_METHOD_CODE
FA_MASS_CHANGES.TO_LIFE_IN_MONTHS 		FA_METHODS
FA_MASS_RECLASS_ITF.METHOD FA_METHODS
FA_MC_BOOKS.DEPRN_METHOD_CODE
FA_MC_BOOKS.LIFE_IN_MONTHS 		FA_METHODS
FA_MC_RETIREMENTS.STL_METHOD_CODE
FA_MC_RETIREMENTS.STL_LIFE_IN_MONTHS 		FA_METHODS
FA_RATES.METHOD_ID FA_METHODS
FA_RESERVE_LEDGER.METHOD_CODE
FA_RESERVE_LEDGER.LIFE 		FA_METHODS
FA_RETIREMENTS.STL_METHOD_CODE
FA_RETIREMENTS.STL_LIFE_IN_MONTHS 		FA_METHODS
FA_TAX_INTERFACE.DEPRN_METHOD_CODE
FA_TAX_INTERFACE.LIFE_IN_MONTHS 		FA_METHODS

[top of page]

FA.FA_METHODS does not reference any database object

FA.FA_METHODS is referenced by following:

APPS
SYNONYM - FA_METHODS

[top of page]

Table: FA_PARALLEL_WORKERS

Description: Used to control concurrent execution of post mass additions program.
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_PARALLEL_WORKERS.ASSET_ID FA_ADDITIONS_B
FA_PARALLEL_WORKERS.REQUEST_ID FND_CONCURRENT_REQUESTS
FA_PARALLEL_WORKERS.ASSET_CATEGORY_ID FA_CATEGORIES_B
FA_PARALLEL_WORKERS.PARENT_ASSET_ID FA_ADDITIONS_B
FA_PARALLEL_WORKERS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_PARALLEL_WORKERS.CORP_TRANSACTION_HEADER_ID FA_TRANSACTION_HEADERS
FA_PARALLEL_WORKERS.TAX_TRANSACTION_HEADER_ID FA_TRANSACTION_HEADERS
FA_PARALLEL_WORKERS.TRANSACTION_TYPE_CODE FA_TRANSACTION_HEADERS
FA_PARALLEL_WORKERS.OLD_GROUP_ASSET_ID FA_ADDITIONS_B
FA_PARALLEL_WORKERS.NEW_GROUP_ASSET_ID FA_ADDITIONS_B

[top of page]

FA.FA_PARALLEL_WORKERS does not reference any database object

FA.FA_PARALLEL_WORKERS is referenced by following:

APPS
SYNONYM - FA_PARALLEL_WORKERS

[top of page]

Table: FA_PERIODIC_PRODUCTION

Description: Production information for units of production assets entered manually or uploaded from FA_PRODUCTION_INTERFACE
Primary Key: FA_PERIODIC_PRODUCTION_PK
  1. ASSET_ID
  2. BOOK_TYPE_CODE
  3. START_DATE
  4. END_DATE
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_PERIODIC_PRODUCTION.ASSET_ID FA_ADDITIONS_B
FA_PERIODIC_PRODUCTION.BOOK_TYPE_CODE FA_BOOK_CONTROLS

[top of page]

FA.FA_PERIODIC_PRODUCTION does not reference any database object

FA.FA_PERIODIC_PRODUCTION is referenced by following:

APPS
SYNONYM - FA_PERIODIC_PRODUCTION

[top of page]

Table: FA_PERIOD_MAPS

Description: Static information about period mapping; used by the Budget-To-Actual Report
Primary Key: FA_PERIOD_MAPS_PK
  1. YEAR_LAST_PERIOD

[top of page]

FA.FA_PERIOD_MAPS does not reference any database object

FA.FA_PERIOD_MAPS is referenced by following:

APPS
SYNONYM - FA_PERIOD_MAPS

[top of page]

Table: FA_PLSQL_DEBUG

Description: For debugging purposes in plsql.

[top of page]

FA.FA_PLSQL_DEBUG does not reference any database object

FA.FA_PLSQL_DEBUG is referenced by following:

APPS
SYNONYM - FA_PLSQL_DEBUG

[top of page]

Table: FA_PRICE_INDEXES

Description: General price index information
Primary Key: FA_PRICE_INDEXES_PK
  1. PRICE_INDEX_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_CATEGORY_BOOK_DEFAULTS.PRICE_INDEX_NAME FA_PRICE_INDEXES
FA_PRICE_INDEX_VALUES.PRICE_INDEX_ID FA_PRICE_INDEXES

[top of page]

FA.FA_PRICE_INDEXES does not reference any database object

FA.FA_PRICE_INDEXES is referenced by following:

APPS
SYNONYM - FA_PRICE_INDEXES

[top of page]

Table: FA_PRICE_INDEX_VALUES

Description: Price index values of each price index
Primary Key: FA_PRICE_INDEX_VALUES_PK
  1. PRICE_INDEX_ID
  2. FROM_DATE
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_PRICE_INDEX_VALUES.PRICE_INDEX_ID FA_PRICE_INDEXES

[top of page]

FA.FA_PRICE_INDEX_VALUES does not reference any database object

FA.FA_PRICE_INDEX_VALUES is referenced by following:

APPS
SYNONYM - FA_PRICE_INDEX_VALUES

[top of page]

Table: FA_PRODUCTION_INTERFACE

Description: Production information to be uploaded into Oracle Assets
Primary Key: FA_PRODUCTION_INTERFACE_PK
  1. ASSET_NUMBER
  2. START_DATE
  3. END_DATE

[top of page]

FA.FA_PRODUCTION_INTERFACE does not reference any database object

FA.FA_PRODUCTION_INTERFACE is referenced by following:

APPS
SYNONYM - FA_PRODUCTION_INTERFACE

[top of page]

Table: FA_PROJECT_REP_ITF

Description: Interface table for Report eXchange reports

[top of page]

FA.FA_PROJECT_REP_ITF does not reference any database object

FA.FA_PROJECT_REP_ITF is referenced by following:

APPS
SYNONYM - FA_PROJECT_REP_ITF

[top of page]

Table: FA_PROPTAX_REP_ITF

Description: Interface table for Report eXchange reports

[top of page]

FA.FA_PROPTAX_REP_ITF does not reference any database object

FA.FA_PROPTAX_REP_ITF is referenced by following:

APPS
SYNONYM - FA_PROPTAX_REP_ITF

[top of page]

Table: FA_RATES

Description: Annual depreciation rates for life-based depreciation methods
Primary Key: FA_RATES_PK
  1. METHOD_ID
  2. YEAR
  3. PERIOD_PLACED_IN_SERVICE
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_RATES.METHOD_ID FA_METHODS

[top of page]

FA.FA_RATES does not reference any database object

FA.FA_RATES is referenced by following:

APPS
SYNONYM - FA_RATES

[top of page]

Table: FA_RECLASS_REP_ITF

Description: Interface table for Report eXchange reports

[top of page]

FA.FA_RECLASS_REP_ITF does not reference any database object

FA.FA_RECLASS_REP_ITF is referenced by following:

APPS
SYNONYM - FA_RECLASS_REP_ITF

[top of page]

Table: FA_RESERVE_LEDGER

Description: Temporary storage area for the reserve ledger reports
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_RESERVE_LEDGER.ASSET_ID FA_ADDITIONS_B
FA_RESERVE_LEDGER.DH_CCID GL_CODE_COMBINATIONS
FA_RESERVE_LEDGER.METHOD_CODE
FA_RESERVE_LEDGER.LIFE 		FA_METHODS

[top of page]

FA.FA_RESERVE_LEDGER does not reference any database object

FA.FA_RESERVE_LEDGER is referenced by following:

APPS
SYNONYM - FA_RESERVE_LEDGER

[top of page]

Table: FA_RETIREMENTS

Description: Information about asset retirements and reinstatements
Primary Key: FA_RETIREMENTS_PK
  1. RETIREMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_RETIREMENTS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_RETIREMENTS.ASSET_ID FA_ADDITIONS_B
FA_RETIREMENTS.TRANSACTION_HEADER_ID_IN FA_TRANSACTION_HEADERS
FA_RETIREMENTS.TRANSACTION_HEADER_ID_OUT FA_TRANSACTION_HEADERS
FA_RETIREMENTS.ITC_RECAPTURE_ID FA_ITC_RECAPTURE_RATES
FA_RETIREMENTS.RETIREMENT_PRORATE_CONVENTION FA_CONVENTION_TYPES
FA_RETIREMENTS.TRADE_IN_ASSET_ID FA_ADDITIONS_B
FA_RETIREMENTS.STL_METHOD_CODE
FA_RETIREMENTS.STL_LIFE_IN_MONTHS 		FA_METHODS
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_BOOKS.RETIREMENT_ID FA_RETIREMENTS
FA_DISTRIBUTION_HISTORY.RETIREMENT_ID FA_RETIREMENTS
JA_AU_BAL_CHG_SOURCE.RETIREMENT_ID FA_RETIREMENTS
JL_ZZ_FA_RETIREMNT_ADJS.RETIREMENT_ID FA_RETIREMENTS

[top of page]

FA.FA_RETIREMENTS does not reference any database object

FA.FA_RETIREMENTS is referenced by following:

APPS
SYNONYM - FA_RETIREMENTS
SYNONYM - FA_RETIREMENTS_BAS

[top of page]

Table: FA_RETIRE_REP_ITF

Description: Interface table for Report eXchange reports
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_RETIRE_REP_ITF.GROUP_ASSET_NUMBER FA_ADDITIONS_B

[top of page]

FA.FA_RETIRE_REP_ITF does not reference any database object

FA.FA_RETIRE_REP_ITF is referenced by following:

APPS
SYNONYM - FA_RETIRE_REP_ITF

[top of page]

Table: FA_RX_ATTRSETS_B

Description: Stores attribute set information for RX reports (base MLS table)
Primary Key: FA_RX_ATTRSETS_B_PK
  1. REPORT_ID
  2. ATTRIBUTE_SET
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_RX_ATTRSETS_B.REPORT_ID FA_RX_REPORTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_RX_ATTRSETS_TL.REPORT_ID
FA_RX_ATTRSETS_TL.ATTRIBUTE_SET 		FA_RX_ATTRSETS_B
FA_RX_REP_COLUMNS_B.REPORT_ID
FA_RX_REP_COLUMNS_B.ATTRIBUTE_SET 		FA_RX_ATTRSETS_B
FA_RX_SECURITY.REPORT_ID
FA_RX_SECURITY.ATTRIBUTE_SET 		FA_RX_ATTRSETS_B

[top of page]

FA.FA_RX_ATTRSETS_B does not reference any database object

FA.FA_RX_ATTRSETS_B is referenced by following:

APPS
SYNONYM - FA_RX_ATTRSETS_B

[top of page]

Table: FA_RX_ATTRSETS_TL

Description: Stores Attribute Set information for RX reports (translated MLS table)
Primary Key: FA_RX_ATTRSETS_TL_PK
  1. REPORT_ID
  2. ATTRIBUTE_SET
  3. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_RX_ATTRSETS_TL.REPORT_ID
FA_RX_ATTRSETS_TL.ATTRIBUTE_SET 		FA_RX_ATTRSETS_B

[top of page]

FA.FA_RX_ATTRSETS_TL does not reference any database object

FA.FA_RX_ATTRSETS_TL is referenced by following:

APPS
SYNONYM - FA_RX_ATTRSETS_TL

[top of page]

Table: FA_RX_DYNAMIC_COLUMNS

Description: Stores information about dynamic columns for RX reports
Primary Key: FA_RX_DYNAMIC_COLUMNS_PK
  1. REQUEST_ID
  2. ATTRIBUTE_NAME

[top of page]

FA.FA_RX_DYNAMIC_COLUMNS does not reference any database object

FA.FA_RX_DYNAMIC_COLUMNS is referenced by following:

APPS
SYNONYM - FA_RX_DYNAMIC_COLUMNS

[top of page]

Table: FA_RX_LOV

Description: Stores information about creating the LOV's for RX reports.
Primary Key: FA_RX_LOV_PK
  1. LOV_ID

[top of page]

FA.FA_RX_LOV does not reference any database object

FA.FA_RX_LOV is referenced by following:

APPS
SYNONYM - FA_RX_LOV

[top of page]

Table: FA_RX_MULTIFORMAT_REPS

Description: Stores information about Multiple format reports for use with RXi

[top of page]

FA.FA_RX_MULTIFORMAT_REPS does not reference any database object

FA.FA_RX_MULTIFORMAT_REPS is referenced by following:

APPS
SYNONYM - FA_RX_MULTIFORMAT_REPS

[top of page]

Table: FA_RX_REPORTS

Description: Stores Report eXchange report definitions
Primary Key: FA_RX_REPORTS_PK
  1. REPORT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_RX_REPORTS.APPLICATION_ID FND_APPLICATION
FA_RX_REPORTS.APPLICATION_ID
FA_RX_REPORTS.CONCURRENT_PROGRAM_ID 		FND_CONCURRENT_PROGRAMS
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_RX_ATTRSETS_B.REPORT_ID FA_RX_REPORTS
FA_RX_REP_PARAMETERS.REPORT_ID FA_RX_REPORTS

[top of page]

FA.FA_RX_REPORTS does not reference any database object

FA.FA_RX_REPORTS is referenced by following:

APPS
SYNONYM - FA_RX_REPORTS

[top of page]

Table: FA_RX_REP_COLUMNS_B

Description: Stores attribute definitions for Report eXchange report attributes (base MLS table)
Primary Key: FA_RX_REP_COLUMNS_B_PK
  1. REPORT_ID
  2. COLUMN_NAME
  3. ATTRIBUTE_SET
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_RX_REP_COLUMNS_B.REPORT_ID
FA_RX_REP_COLUMNS_B.ATTRIBUTE_SET 		FA_RX_ATTRSETS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_RX_REP_COLUMNS_TL.REPORT_ID
FA_RX_REP_COLUMNS_TL.COLUMN_NAME
FA_RX_REP_COLUMNS_TL.ATTRIBUTE_SET 		FA_RX_REP_COLUMNS_B
FA_RX_SUMMARY_TL.REPORT_ID
FA_RX_SUMMARY_TL.COLUMN_NAME
FA_RX_SUMMARY_TL.ATTRIBUTE_SET 		FA_RX_REP_COLUMNS_B

[top of page]

FA.FA_RX_REP_COLUMNS_B does not reference any database object

FA.FA_RX_REP_COLUMNS_B is referenced by following:

APPS
SYNONYM - FA_RX_REP_COLUMNS_B

[top of page]

Table: FA_RX_REP_COLUMNS_TL

Description: Stores attribute definitions for Report eXchange report attributes (translated MLS table)
Primary Key: FA_RX_REP_COLUMNS_TL_PK
  1. REPORT_ID
  2. ATTRIBUTE_SET
  3. COLUMN_NAME
  4. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_RX_REP_COLUMNS_TL.REPORT_ID
FA_RX_REP_COLUMNS_TL.COLUMN_NAME
FA_RX_REP_COLUMNS_TL.ATTRIBUTE_SET 		FA_RX_REP_COLUMNS_B

[top of page]

FA.FA_RX_REP_COLUMNS_TL does not reference any database object

FA.FA_RX_REP_COLUMNS_TL is referenced by following:

APPS
SYNONYM - FA_RX_REP_COLUMNS_TL

[top of page]

Table: FA_RX_REP_PARAMETERS

Description: Stores parameter definitions for Report eXchange reports
Primary Key: FA_RX_REP_PARAMETERS_PK
  1. REPORT_ID
  2. NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_RX_REP_PARAMETERS.REPORT_ID FA_RX_REPORTS

[top of page]

FA.FA_RX_REP_PARAMETERS does not reference any database object

FA.FA_RX_REP_PARAMETERS is referenced by following:

APPS
SYNONYM - FA_RX_REP_PARAMETERS

[top of page]

Table: FA_RX_SECURITY

Description: Stores security assignments for Report eXchange Attribute sets
Primary Key: FA_RX_SECURITY_PK
  1. REPORT_ID
  2. ATTRIBUTE_SET
  3. RESPONSIBILITY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_RX_SECURITY.REPORT_ID
FA_RX_SECURITY.ATTRIBUTE_SET 		FA_RX_ATTRSETS_B

[top of page]

FA.FA_RX_SECURITY does not reference any database object

FA.FA_RX_SECURITY is referenced by following:

APPS
SYNONYM - FA_RX_SECURITY

[top of page]

Table: FA_RX_SUMMARY_TL

Description: Stores summary definitions for Report eXchange report attributes (base MLS table)
Primary Key: FA_RX_SUMMARY_TL_PK
  1. REPORT_ID
  2. ATTRIBUTE_SET
  3. COLUMN_NAME
  4. SUMMARY_FUNCTION
  5. LANGUAGE
  6. PRINT_LEVEL
  7. RESET_LEVEL
  8. COMPUTE_LEVEL
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_RX_SUMMARY_TL.REPORT_ID
FA_RX_SUMMARY_TL.COLUMN_NAME
FA_RX_SUMMARY_TL.ATTRIBUTE_SET 		FA_RX_REP_COLUMNS_B

[top of page]

FA.FA_RX_SUMMARY_TL does not reference any database object

FA.FA_RX_SUMMARY_TL is referenced by following:

APPS
SYNONYM - FA_RX_SUMMARY_TL

[top of page]

Table: FA_SHORT_TAX_RESERVES

Description: Stores accumulated depreciation amounts for assets added in short tax years in their tax books
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_SHORT_TAX_RESERVES.ASSET_NUMBER FA_ADDITIONS_B
FA_SHORT_TAX_RESERVES.TAX_BOOK FA_BOOK_CONTROLS
FA_SHORT_TAX_RESERVES.PRORATE_CONVENTION_CODE FA_CONVENTION_TYPES

[top of page]

FA.FA_SHORT_TAX_RESERVES does not reference any database object

FA.FA_SHORT_TAX_RESERVES is referenced by following:

APPS
SYNONYM - FA_SHORT_TAX_RESERVES

[top of page]

Table: FA_SUPER_GROUPS

Description: Contains super group definitions - flexfield and general descriptive information.
Primary Key: FA_SUPER_GROUPS_U1
  1. SUPER_GROUP_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_BOOKS.SUPER_GROUP_ID FA_SUPER_GROUPS
FA_BOOKS_SUMMARY.SUPER_GROUP_ID FA_SUPER_GROUPS
FA_MC_BOOKS.SUPER_GROUP_ID FA_SUPER_GROUPS

[top of page]

FA.FA_SUPER_GROUPS does not reference any database object

FA.FA_SUPER_GROUPS is referenced by following:

APPS
SYNONYM - FA_SUPER_GROUPS

[top of page]

Table: FA_SUPER_GROUP_RULES

Description: Defines the depreciation rules to be followed when depreciating asset groups that are members of the super group.
Primary Key: FA_SUPER_GROUP_RULES_U1
  1. SUPER_GROUP_ID
  2. BOOK_TYPE_CODE
  3. DATE_EFFECTIVE

[top of page]

FA.FA_SUPER_GROUP_RULES does not reference any database object

FA.FA_SUPER_GROUP_RULES is referenced by following:

APPS
SYNONYM - FA_SUPER_GROUP_RULES

[top of page]

Table: FA_SYSTEM_CONTROLS

Description: System-wide controls that affect all assets
Primary Key: FA_SYSTEM_CONTROLS_PK
  1. COMPANY_NAME

[top of page]

FA.FA_SYSTEM_CONTROLS does not reference any database object

FA.FA_SYSTEM_CONTROLS is referenced by following:

APPS
SYNONYM - FA_SYSTEM_CONTROLS

[top of page]

Table: FA_TAX_INTERFACE

Description: Tax Book Interface table
Primary Key: FA_TAX_INTERFACE_PK
  1. ASSET_NUMBER
  2. BOOK_TYPE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_TAX_INTERFACE.ASSET_NUMBER FA_ADDITIONS_B
FA_TAX_INTERFACE.GROUP_ASSET_ID FA_ADDITIONS_B
FA_TAX_INTERFACE.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_TAX_INTERFACE.CEILING_NAME FA_CEILING_TYPES
FA_TAX_INTERFACE.DEPRN_METHOD_CODE
FA_TAX_INTERFACE.LIFE_IN_MONTHS 		FA_METHODS
FA_TAX_INTERFACE.ITC_AMOUNT_ID FA_ITC_RATES
FA_TAX_INTERFACE.PRORATE_CONVENTION_CODE FA_CONVENTION_TYPES
FA_TAX_INTERFACE.TAX_REQUEST_ID FND_CONCURRENT_REQUESTS

[top of page]

FA.FA_TAX_INTERFACE does not reference any database object

FA.FA_TAX_INTERFACE is referenced by following:

APPS
SYNONYM - FA_TAX_INTERFACE

[top of page]

Table: FA_TAX_REPORT

Description: FA_TAX_REPORT is temporary storage table for TAX PREFERENCE REPORT.

[top of page]

FA.FA_TAX_REPORT does not reference any database object

FA.FA_TAX_REPORT is referenced by following:

APPS
SYNONYM - FA_TAX_REPORT

[top of page]

Table: FA_TRANSACTION_HEADERS

Description: Information about all transactions performed within Oracle Assets
Primary Key: FA_TRANSACTION_HEADERS_PK
  1. TRANSACTION_HEADER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_TRANSACTION_HEADERS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_TRANSACTION_HEADERS.ASSET_ID FA_ADDITIONS_B
FA_TRANSACTION_HEADERS.INVOICE_TRANSACTION_ID FA_INVOICE_TRANSACTIONS
FA_TRANSACTION_HEADERS.SOURCE_TRANSACTION_HEADER_ID FA_TRANSACTION_HEADERS
FA_TRANSACTION_HEADERS.MEMBER_TRANSACTION_HEADER_ID FA_TRANSACTION_HEADERS
FA_TRANSACTION_HEADERS.TRX_REFERENCE_ID FA_TRX_REFERENCES
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_ADJUSTMENTS.TRANSACTION_HEADER_ID FA_TRANSACTION_HEADERS
FA_ASSET_HISTORY.TRANSACTION_HEADER_ID_IN FA_TRANSACTION_HEADERS
FA_ASSET_HISTORY.TRANSACTION_HEADER_ID_OUT FA_TRANSACTION_HEADERS
FA_BOOKS.TRANSACTION_HEADER_ID_IN FA_TRANSACTION_HEADERS
FA_BOOKS.TRANSACTION_HEADER_ID_OUT FA_TRANSACTION_HEADERS
FA_CAPITAL_BUDGET.TRANSFER_HEADER_ID FA_TRANSACTION_HEADERS
FA_DISTRIBUTION_HISTORY.TRANSACTION_HEADER_ID_IN FA_TRANSACTION_HEADERS
FA_DISTRIBUTION_HISTORY.TRANSACTION_HEADER_ID_OUT FA_TRANSACTION_HEADERS
FA_MC_ADJUSTMENTS.TRANSACTION_HEADER_ID FA_TRANSACTION_HEADERS
FA_MC_BOOKS.TRANSACTION_HEADER_ID_IN FA_TRANSACTION_HEADERS
FA_MC_BOOKS.TRANSACTION_HEADER_ID_OUT FA_TRANSACTION_HEADERS
FA_MC_BOOKS_RATES.TRANSACTION_HEADER_ID FA_TRANSACTION_HEADERS
FA_MC_RETIREMENTS.TRANSACTION_HEADER_ID_IN FA_TRANSACTION_HEADERS
FA_MC_RETIREMENTS.TRANSACTION_HEADER_ID_OUT FA_TRANSACTION_HEADERS
FA_PARALLEL_WORKERS.CORP_TRANSACTION_HEADER_ID FA_TRANSACTION_HEADERS
FA_PARALLEL_WORKERS.TAX_TRANSACTION_HEADER_ID FA_TRANSACTION_HEADERS
FA_PARALLEL_WORKERS.TRANSACTION_TYPE_CODE FA_TRANSACTION_HEADERS
FA_RETIREMENTS.TRANSACTION_HEADER_ID_IN FA_TRANSACTION_HEADERS
FA_RETIREMENTS.TRANSACTION_HEADER_ID_OUT FA_TRANSACTION_HEADERS
FA_TRANSACTION_HEADERS.SOURCE_TRANSACTION_HEADER_ID FA_TRANSACTION_HEADERS
FA_TRANSACTION_HEADERS.MEMBER_TRANSACTION_HEADER_ID FA_TRANSACTION_HEADERS
FA_TRANSFER_DETAILS.TRANSFER_HEADER_ID FA_TRANSACTION_HEADERS
FA_TRX_REFERENCES.SRC_TRANSACTION_HEADER_ID FA_TRANSACTION_HEADERS
FA_TRX_REFERENCES.DEST_TRANSACTION_HEADER_ID FA_TRANSACTION_HEADERS
FA_TRX_REFERENCES.MEMBER_TRANSACTION_HEADER_ID FA_TRANSACTION_HEADERS
OKL_EXT_FA_LINE_SOURCES_B.FA_TRANSACTION_ID FA_TRANSACTION_HEADERS
PA_PROJECT_ASSET_LINES_ALL.RET_ADJUSTMENT_TXN_ID FA_TRANSACTION_HEADERS

[top of page]

FA.FA_TRANSACTION_HEADERS does not reference any database object

FA.FA_TRANSACTION_HEADERS is referenced by following:

APPS
TRIGGER - FA_CUA_TRANSACTION_HEADERS_BRI
TRIGGER - FA_CUA_TRX_HEADERS_ARI2
SYNONYM - FA_TRANSACTION_HEADERS

[top of page]

Table: FA_TRANSACTION_INTERFACE

Description: Interface table for uploading transactions to Assets
Primary Key: FA_TRANSACTION_INTERFACE_PK
  1. TRANSACTION_INTERFACE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_TRANSACTION_INTERFACE.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_TRANSACTION_INTERFACE.CONCURRENT_REQUEST_ID FND_CONCURRENT_REQUESTS

[top of page]

FA.FA_TRANSACTION_INTERFACE does not reference any database object

FA.FA_TRANSACTION_INTERFACE is referenced by following:

APPS
SYNONYM - FA_TRANSACTION_INTERFACE

[top of page]

Table: FA_TRANSFER_DETAILS

Description: Information that defines the historic relationship between active FA_BOOKS and FA_DISTRIBUTION_HISTORY rows
Primary Key: FA_TRANSFER_DETAILS_PK
  1. TRANSFER_HEADER_ID
  2. DISTRIBUTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_TRANSFER_DETAILS.DISTRIBUTION_ID FA_DISTRIBUTION_HISTORY
FA_TRANSFER_DETAILS.BOOK_HEADER_ID FA_BOOKS
FA_TRANSFER_DETAILS.TRANSFER_HEADER_ID FA_TRANSACTION_HEADERS

[top of page]

FA.FA_TRANSFER_DETAILS does not reference any database object

FA.FA_TRANSFER_DETAILS is referenced by following:

APPS
SYNONYM - FA_TRANSFER_DETAILS

[top of page]

Table: FA_TRANSFER_REP_ITF

Description: Interface table for Report eXchange reports

[top of page]

FA.FA_TRANSFER_REP_ITF does not reference any database object

FA.FA_TRANSFER_REP_ITF is referenced by following:

APPS
SYNONYM - FA_TRANSFER_REP_ITF

[top of page]

Table: FA_TRX_REFERENCES

Description: Information about inter-asset transactions performed within Oracle Assets
Primary Key: FA_TRX_REFERENCES_PK
  1. TRX_REFERENCE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_TRX_REFERENCES.BOOK_TYPE_CODE FA_BOOK_CONTROLS
FA_TRX_REFERENCES.SRC_ASSET_ID FA_ADDITIONS_B
FA_TRX_REFERENCES.SRC_TRANSACTION_HEADER_ID FA_TRANSACTION_HEADERS
FA_TRX_REFERENCES.DEST_ASSET_ID FA_ADDITIONS_B
FA_TRX_REFERENCES.DEST_TRANSACTION_HEADER_ID FA_TRANSACTION_HEADERS
FA_TRX_REFERENCES.MEMBER_ASSET_ID FA_ADDITIONS_B
FA_TRX_REFERENCES.MEMBER_TRANSACTION_HEADER_ID FA_TRANSACTION_HEADERS
FA_TRX_REFERENCES.INVOICE_TRANSACTION_ID FA_INVOICE_TRANSACTIONS
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_TRANSACTION_HEADERS.TRX_REFERENCE_ID FA_TRX_REFERENCES

[top of page]

FA.FA_TRX_REFERENCES does not reference any database object

FA.FA_TRX_REFERENCES is referenced by following:

APPS
SYNONYM - FA_TRX_REFERENCES

[top of page]

Table: FA_WARRANTIES

Description: Warranty information
Primary Key: FA_WARRANTIES_PK
  1. WARRANTY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_WARRANTIES.PO_VENDOR_ID PO_VENDORS
FA_WARRANTIES.CURRENCY_CODE FND_CURRENCIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
FA_ADD_WARRANTIES.WARRANTY_ID FA_WARRANTIES

[top of page]

FA.FA_WARRANTIES does not reference any database object

FA.FA_WARRANTIES is referenced by following:

APPS
SYNONYM - FA_WARRANTIES

[top of page]

Table: FA_WHATIF_ITF

Description: Interface table for What-If Depreciation Analysis Report
Foreign Keys from this table:
Foreign Key Column Foreign Table
FA_WHATIF_ITF.CURRENCY_CODE FND_CURRENCIES

[top of page]

FA.FA_WHATIF_ITF does not reference any database object

FA.FA_WHATIF_ITF is referenced by following:

APPS
SYNONYM - FA_WHATIF_ITF

[top of page]

Table: FA_WORKER_JOBS

Description: This table is used for internal processesing only

[top of page]

FA.FA_WORKER_JOBS does not reference any database object

FA.FA_WORKER_JOBS is referenced by following:

APPS
SYNONYM - FA_WORKER_JOBS

[top of page]

Table: FA_XLA_EXT_HEADERS_B_GT

Description:

[top of page]

FA.FA_XLA_EXT_HEADERS_B_GT does not reference any database object

FA.FA_XLA_EXT_HEADERS_B_GT is referenced by following:

APPS
SYNONYM - FA_XLA_EXT_HEADERS_B_GT

[top of page]

Table: FA_XLA_EXT_LINES_B_GT

Description:

[top of page]

FA.FA_XLA_EXT_LINES_B_GT does not reference any database object

FA.FA_XLA_EXT_LINES_B_GT is referenced by following:

APPS
SYNONYM - FA_XLA_EXT_LINES_B_GT

[top of page]

Table: FA_XLA_EXT_LINES_STG_GT

Description:

[top of page]

FA.FA_XLA_EXT_LINES_STG_GT does not reference any database object

FA.FA_XLA_EXT_LINES_STG_GT is referenced by following:

APPS
SYNONYM - FA_XLA_EXT_LINES_STG_GT

[top of page]

Table: FA_XLA_EXT_LINES_TL_GT

Description:

[top of page]

FA.FA_XLA_EXT_LINES_TL_GT does not reference any database object

FA.FA_XLA_EXT_LINES_TL_GT is referenced by following:

APPS
SYNONYM - FA_XLA_EXT_LINES_TL_GT

[top of page]

View: FABV_ACCT_PRDS

[top of page]

APPS.FABV_ACCT_PRDS references the following:

APPS
SYNONYM - FA_DEPRN_PERIODS

APPS.FABV_ACCT_PRDS is not referenced by any database object

[top of page]

View: FABV_ASSETS

[top of page]

APPS.FABV_ASSETS references the following:

APPS
SYNONYM - FA_ADDITIONS
SYNONYM - FA_ASSET_KEYWORDS
SYNONYM - FA_BOOKS
SYNONYM - FA_DISTRIBUTION_HISTORY

APPS.FABV_ASSETS is not referenced by any database object

[top of page]

View: FABV_ASSET_ASSIGNS

[top of page]

APPS.FABV_ASSET_ASSIGNS references the following:

APPS
SYNONYM - FA_DISTRIBUTION_HISTORY

APPS.FABV_ASSET_ASSIGNS is not referenced by any database object

[top of page]

View: FABV_ASSET_BKS

[top of page]

APPS.FABV_ASSET_BKS references the following:

APPS
SYNONYM - FA_BOOKS

APPS.FABV_ASSET_BKS is not referenced by any database object

[top of page]

View: FABV_ASSET_CATS

[top of page]

APPS.FABV_ASSET_CATS references the following:

APPS
SYNONYM - FA_CATEGORIES

APPS.FABV_ASSET_CATS is not referenced by any database object

[top of page]

View: FABV_ASSET_LEASES

[top of page]

APPS.FABV_ASSET_LEASES references the following:

APPS
SYNONYM - FA_LEASES

APPS.FABV_ASSET_LEASES is not referenced by any database object

[top of page]

View: FABV_ASSET_LOCS

[top of page]

APPS.FABV_ASSET_LOCS references the following:

APPS
SYNONYM - FA_LOCATIONS

APPS.FABV_ASSET_LOCS is not referenced by any database object

[top of page]

View: FABV_BOOKS

[top of page]

APPS.FABV_BOOKS references the following:

APPS
SYNONYM - FA_BOOK_CONTROLS

APPS.FABV_BOOKS is not referenced by any database object

[top of page]

View: FABV_DEPRECIATIONS

[top of page]

APPS.FABV_DEPRECIATIONS references the following:

APPS
SYNONYM - FA_DEPRN_DETAIL

APPS.FABV_DEPRECIATIONS is not referenced by any database object

[top of page]

View: FABV_SRC_LNS

[top of page]

APPS.FABV_SRC_LNS references the following:

APPS
SYNONYM - FA_ASSET_INVOICES

APPS.FABV_SRC_LNS is not referenced by any database object

[top of page]

View: FABV_TRANS_HDRS

[top of page]

APPS.FABV_TRANS_HDRS references the following:

APPS
SYNONYM - FA_ADJUSTMENTS
SYNONYM - FA_TRANSACTION_HEADERS

APPS.FABV_TRANS_HDRS is not referenced by any database object

[top of page]

View: FABV_TRANS_LINES

[top of page]

APPS.FABV_TRANS_LINES references the following:

APPS
SYNONYM - FA_ADJUSTMENTS

APPS.FABV_TRANS_LINES is not referenced by any database object

[top of page]

View: FAFV_ACCT_PRDS

[top of page]

APPS.FAFV_ACCT_PRDS references the following:

APPS
SYNONYM - FA_DEPRN_PERIODS

APPS.FAFV_ACCT_PRDS is not referenced by any database object

[top of page]

View: FAFV_ASSETS

[top of page]

APPS.FAFV_ASSETS references the following:

APPS
SYNONYM - FA_ADDITIONS
SYNONYM - FA_ASSET_KEYWORDS
SYNONYM - FA_BOOKS
SYNONYM - FA_CATEGORIES
SYNONYM - FA_DISTRIBUTION_HISTORY
SYNONYM - FA_LEASES

APPS.FAFV_ASSETS is not referenced by any database object

[top of page]

View: FAFV_ASSET_ASSIGNS

[top of page]

APPS.FAFV_ASSET_ASSIGNS references the following:

APPS
SYNONYM - FA_DISTRIBUTION_HISTORY
VIEW - FA_EMPLOYEES
SYNONYM - GL_CODE_COMBINATIONS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY

APPS.FAFV_ASSET_ASSIGNS is not referenced by any database object

[top of page]

View: FAFV_ASSET_BKS

[top of page]

APPS.FAFV_ASSET_BKS references the following:

APPS
SYNONYM - FA_ADDITIONS
SYNONYM - FA_BOOKS
SYNONYM - FA_DEPRN_PERIODS

APPS.FAFV_ASSET_BKS is not referenced by any database object

[top of page]

View: FAFV_ASSET_CATS

[top of page]

APPS.FAFV_ASSET_CATS references the following:

APPS
SYNONYM - FA_CATEGORIES

APPS.FAFV_ASSET_CATS is not referenced by any database object

[top of page]

View: FAFV_ASSET_LEASES

[top of page]

APPS.FAFV_ASSET_LEASES references the following:

APPS
SYNONYM - FA_LEASES
VIEW - FND_CURRENCIES_VL
VIEW - PO_VENDORS

APPS.FAFV_ASSET_LEASES is not referenced by any database object

[top of page]

View: FAFV_ASSET_LOCS

[top of page]

APPS.FAFV_ASSET_LOCS references the following:

APPS
SYNONYM - FA_LOCATIONS

APPS.FAFV_ASSET_LOCS is not referenced by any database object

[top of page]

View: FAFV_BOOKS

[top of page]

APPS.FAFV_BOOKS references the following:

APPS
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_DEPRN_PERIODS
VIEW - GL_SETS_OF_BOOKS

APPS.FAFV_BOOKS is not referenced by any database object

[top of page]

View: FAFV_DEPRECIATIONS

[top of page]

APPS.FAFV_DEPRECIATIONS references the following:

APPS
SYNONYM - FA_ADDITIONS
SYNONYM - FA_BOOKS
SYNONYM - FA_DEPRN_DETAIL
SYNONYM - FA_DEPRN_PERIODS
SYNONYM - FA_DISTRIBUTION_HISTORY
SYNONYM - GL_CODE_COMBINATIONS

APPS.FAFV_DEPRECIATIONS is not referenced by any database object

[top of page]

View: FAFV_SRC_LNS

[top of page]

APPS.FAFV_SRC_LNS references the following:

APPS
SYNONYM - FA_ADDITIONS
SYNONYM - FA_ASSET_INVOICES
SYNONYM - PA_PROJECTS
SYNONYM - PA_TASKS
VIEW - PO_VENDORS

APPS.FAFV_SRC_LNS is not referenced by any database object

[top of page]

View: FAFV_TRANS_HDRS

[top of page]

APPS.FAFV_TRANS_HDRS references the following:

APPS
SYNONYM - FA_ADDITIONS
SYNONYM - FA_ADJUSTMENTS
SYNONYM - FA_TRANSACTION_HEADERS

APPS.FAFV_TRANS_HDRS is not referenced by any database object

[top of page]

View: FAFV_TRANS_LINES

[top of page]

APPS.FAFV_TRANS_LINES references the following:

APPS
SYNONYM - FA_ADJUSTMENTS
SYNONYM - FA_DEPRN_PERIODS
SYNONYM - GL_CODE_COMBINATIONS
SYNONYM - XLA_AE_LINES
SYNONYM - XLA_DISTRIBUTION_LINKS

APPS.FAFV_TRANS_LINES is not referenced by any database object

[top of page]

View: FA_ADDITIONS_ASSET_V

[top of page]

APPS.FA_ADDITIONS_ASSET_V references the following:

APPS
SYNONYM - FA_ADDITIONS
SYNONYM - FA_BOOKS
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_CATEGORIES
SYNONYM - FA_GROUP_ASSETS
SYNONYM - FA_LEASES
VIEW - PO_VENDORS

APPS.FA_ADDITIONS_ASSET_V is not referenced by any database object

[top of page]

View: FA_ADDITIONS_NON_SEC_VL

[top of page]

APPS.FA_ADDITIONS_NON_SEC_VL references the following:

APPS
SYNONYM - FA_ADDITIONS_B
SYNONYM - FA_ADDITIONS_TL
APPS.FA_ADDITIONS_NON_SEC_VL is referenced by following:

APPS
VIEW - FA_FUTURE_MASS_ADDITIONS_V
VIEW - FA_MASS_ADDITIONS_V

[top of page]

View: FA_ADDITIONS_V

[top of page]

APPS.FA_ADDITIONS_V references the following:

APPS
SYNONYM - FA_ADDITIONS_B
SYNONYM - FA_ADDITIONS_TL
SYNONYM - FA_CATEGORIES_B
SYNONYM - FA_LEASES
SYNONYM - FA_LOOKUPS_B
SYNONYM - FA_LOOKUPS_TL
VIEW - PO_VENDORS
APPS.FA_ADDITIONS_V is referenced by following:

APPS
VIEW - OKL_BPD_RECEIPT_APPLIC_UV
VIEW - OKL_BPD_RECEIPT_ASSET_UV
PACKAGE - OKL_UPDT_CASH_DTLS

[top of page]

View: FA_ADDITIONS_VL

[top of page]

APPS.FA_ADDITIONS_VL references the following:

APPS
SYNONYM - FA_ADDITIONS_B
SYNONYM - FA_ADDITIONS_TL
APPS.FA_ADDITIONS_VL is referenced by following:

APPS
PACKAGE BODY - CSI_ASSET_PVT
SYNONYM - FA_ADDITIONS
PACKAGE BODY - FA_UTIL_PVT

[top of page]

View: FA_ADDITIONS_WEB_V

[top of page]

APPS.FA_ADDITIONS_WEB_V references the following:

APPS
SYNONYM - FA_ADDITIONS
VIEW - FA_ASSET_KEYWORDS_KFV
SYNONYM - FA_CATEGORIES_B
VIEW - FA_CATEGORIES_B_KFV
SYNONYM - FA_LEASES
SYNONYM - FA_LOOKUPS
VIEW - PO_VENDORS

APPS.FA_ADDITIONS_WEB_V is not referenced by any database object

[top of page]

View: FA_ADD_INVOICE_WEB_V

[top of page]

APPS.FA_ADD_INVOICE_WEB_V references the following:

APPS
SYNONYM - FA_ADDITIONS
SYNONYM - FA_ASSET_INVOICES
VIEW - FA_ASSET_KEYWORDS_KFV
SYNONYM - FA_CATEGORIES_B
VIEW - FA_CATEGORIES_B_KFV
PACKAGE - FND_CURRENCY
VIEW - PO_VENDORS

APPS.FA_ADD_INVOICE_WEB_V is not referenced by any database object

[top of page]

View: FA_ADJUSTMENTS_MRC_V

[top of page]

APPS.FA_ADJUSTMENTS_MRC_V references the following:

APPS
SYNONYM - FA_MC_ADJUSTMENTS
APPS.FA_ADJUSTMENTS_MRC_V is referenced by following:

APPS
PACKAGE BODY - FARX_AL
PACKAGE BODY - FA_ADDITION_PVT
PACKAGE BODY - FA_ADJUSTMENTS_PKG
PACKAGE BODY - FA_ADJUSTMENT_PUB
PACKAGE BODY - FA_ADJUSTMENT_PVT
VIEW - FA_AEL_SL_MRC_V
PACKAGE BODY - FA_AMORT_PKG
PACKAGE BODY - FA_AMORT_PVT
PACKAGE BODY - FA_ASSET_CALC_PVT
PACKAGE BODY - FA_CALC_DEPRN_BASIS2_PKG
PACKAGE BODY - FA_CIP_PVT
PACKAGE BODY - FA_DEFERRED_DEPRN_PKG
PACKAGE BODY - FA_DEPRN_ROLLBACK_PVT
PACKAGE BODY - FA_FASCOSTD_XMLP_PKG
PACKAGE BODY - FA_FASCOSTS_XMLP_PKG
PACKAGE BODY - FA_FASRSVED_XMLP_PKG
PACKAGE BODY - FA_FASRSVES_XMLP_PKG
PACKAGE BODY - FA_GAINLOSS_DPR_PKG
PACKAGE BODY - FA_GAINLOSS_UND_PKG
PACKAGE BODY - FA_GAINLOSS_UPD_PKG
PACKAGE BODY - FA_GROUP_RECLASS2_PVT
PACKAGE BODY - FA_INS_ADJUST_PKG
PACKAGE BODY - FA_POLISH_PVT
PACKAGE BODY - FA_PROCESS_GROUPS_PKG
PACKAGE BODY - FA_QUERY_BALANCES_PKG
PACKAGE BODY - FA_RETIREMENT_PVT
PACKAGE BODY - FA_TRACK_MEMBER_PVT
PACKAGE BODY - FA_TRANSFER_PVT
PACKAGE BODY - JL_JLMXFGLR_XMLP_PKG
PACKAGE BODY - JL_JLMXFISR_XMLP_PKG
PACKAGE BODY - JL_JLZZFIJR_XMLP_PKG
PACKAGE BODY - JL_ZZ_FA_FUNCTIONS_PKG

[top of page]

View: FA_AEL_GL_V

[top of page]

APPS.FA_AEL_GL_V references the following:

APPS
SYNONYM - FA_ADDITIONS
SYNONYM - FA_ADJUSTMENTS
SYNONYM - FA_ASSET_HISTORY
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_LOOKUPS
SYNONYM - FA_LOOKUPS_TL
SYNONYM - FA_MC_ADJUSTMENTS
SYNONYM - FA_MC_BOOK_CONTROLS
SYNONYM - FA_SYSTEM_CONTROLS
SYNONYM - FA_TRANSACTION_HEADERS
VIEW - GL_SETS_OF_BOOKS
APPS.FA_AEL_GL_V is referenced by following:

APPS
VIEW - XLA_FA_AEL_GL_V

[top of page]

View: FA_AEL_SL_MRC_V

[top of page]

APPS.FA_AEL_SL_MRC_V references the following:

APPS
SYNONYM - FA_ADDITIONS
VIEW - FA_ADJUSTMENTS_MRC_V
SYNONYM - FA_ASSET_HISTORY
VIEW - FA_BOOK_CONTROLS_MRC_V
SYNONYM - FA_INQUIRY_TRX_GT
SYNONYM - FA_LOOKUPS
SYNONYM - FA_SYSTEM_CONTROLS
SYNONYM - FA_TRANSACTION_HEADERS
VIEW - GL_SETS_OF_BOOKS
APPS.FA_AEL_SL_MRC_V is referenced by following:

APPS
VIEW - XLA_FA_AEL_SL_MRC_V

[top of page]

View: FA_AEL_SL_V

[top of page]

APPS.FA_AEL_SL_V references the following:

APPS
SYNONYM - FA_ADDITIONS
SYNONYM - FA_ADJUSTMENTS
SYNONYM - FA_ASSET_HISTORY
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_INQUIRY_TRX_GT
SYNONYM - FA_LOOKUPS
SYNONYM - FA_SYSTEM_CONTROLS
SYNONYM - FA_TRANSACTION_HEADERS
VIEW - GL_SETS_OF_BOOKS
APPS.FA_AEL_SL_V is referenced by following:

APPS
VIEW - XLA_FA_AEL_SL_V

[top of page]

View: FA_ASSET_DISTRIBUTION_V

[top of page]

APPS.FA_ASSET_DISTRIBUTION_V references the following:

APPS
SYNONYM - FA_ADDITIONS
SYNONYM - FA_BOOKS
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_CATEGORIES_B
SYNONYM - FA_CATEGORY_BOOKS
SYNONYM - FA_DISTRIBUTION_HISTORY
VIEW - FA_EMPLOYEES
SYNONYM - FA_LOCATIONS
SYNONYM - GL_CODE_COMBINATIONS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY

APPS.FA_ASSET_DISTRIBUTION_V is not referenced by any database object

[top of page]

View: FA_ASSET_HIERARCHY_PURPOSE_V

[top of page]

APPS.FA_ASSET_HIERARCHY_PURPOSE_V references the following:

APPS
SYNONYM - FA_ASSET_HIERARCHY_PURPOSE
SYNONYM - FA_HIERARCHY_RULE_SET

APPS.FA_ASSET_HIERARCHY_PURPOSE_V is not referenced by any database object

[top of page]

View: FA_ASSET_HIERARCHY_V

[top of page]

APPS.FA_ASSET_HIERARCHY_V references the following:

APPS
SYNONYM - FA_ADDITIONS
SYNONYM - FA_ASSET_HIERARCHY
SYNONYM - FA_ASSET_HIERARCHY_PURPOSE
SYNONYM - FA_BOOKS
SYNONYM - FA_HIERARCHY_RULE_SET

APPS.FA_ASSET_HIERARCHY_V is not referenced by any database object

[top of page]

View: FA_ASSET_HIERARCHY_VALUES_V

[top of page]

APPS.FA_ASSET_HIERARCHY_VALUES_V references the following:

APPS
SYNONYM - FA_ADDITIONS
SYNONYM - FA_ASSET_HIERARCHY
SYNONYM - FA_ASSET_HIERARCHY_VALUES
SYNONYM - FA_BOOKS
PACKAGE - FA_CUA_HIERARCHY_PKG
SYNONYM - FA_LEASES

APPS.FA_ASSET_HIERARCHY_VALUES_V is not referenced by any database object

[top of page]

View: FA_ASSET_HISTORY_V

[top of page]

APPS.FA_ASSET_HISTORY_V references the following:

APPS
SYNONYM - FA_ADDITIONS
SYNONYM - FA_ASSET_HISTORY
SYNONYM - FA_LOOKUPS
SYNONYM - FA_TRANSACTION_HEADERS

APPS.FA_ASSET_HISTORY_V is not referenced by any database object

[top of page]

View: FA_ASSET_HIST_WEB_V

[top of page]

APPS.FA_ASSET_HIST_WEB_V references the following:

APPS
SYNONYM - FA_ADDITIONS
SYNONYM - FA_ASSET_HISTORY
VIEW - FA_CATEGORIES_B_KFV
SYNONYM - FA_LOOKUPS
SYNONYM - FA_TRANSACTION_HEADERS

APPS.FA_ASSET_HIST_WEB_V is not referenced by any database object

[top of page]

View: FA_ASSET_HRCHY_DETAILS_V

[top of page]

APPS.FA_ASSET_HRCHY_DETAILS_V references the following:

APPS
SYNONYM - FA_ADDITIONS
SYNONYM - FA_ASSET_HIERARCHY

APPS.FA_ASSET_HRCHY_DETAILS_V is not referenced by any database object

[top of page]

View: FA_ASSET_INVOICES_MRC_V

[top of page]

APPS.FA_ASSET_INVOICES_MRC_V references the following:

APPS
SYNONYM - FA_MC_ASSET_INVOICES
APPS.FA_ASSET_INVOICES_MRC_V is referenced by following:

APPS
PACKAGE BODY - FA_ADDITION_PVT
PACKAGE BODY - FA_ASSET_INVOICES_PKG
PACKAGE BODY - FA_INVOICE_PVT
PACKAGE BODY - FA_UTIL_PVT

[top of page]

View: FA_ASSET_INVOICES_V

[top of page]

APPS.FA_ASSET_INVOICES_V references the following:

APPS
SYNONYM - FA_ADDITIONS
SYNONYM - FA_ASSET_INVOICES
SYNONYM - FA_BOOKS
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_CATEGORIES_B
SYNONYM - FA_LOOKUPS
VIEW - PO_VENDORS

APPS.FA_ASSET_INVOICES_V is not referenced by any database object

[top of page]

View: FA_ASSET_V

[top of page]

APPS.FA_ASSET_V references the following:

APPS
SYNONYM - FA_ADDITIONS
SYNONYM - FA_BOOKS
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_CATEGORIES_B

APPS.FA_ASSET_V is not referenced by any database object

[top of page]

View: FA_BOOKS_BK_CNTRL_WEB_V

[top of page]

APPS.FA_BOOKS_BK_CNTRL_WEB_V references the following:

APPS
SYNONYM - FA_ADDITIONS_B
SYNONYM - FA_BOOKS
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_CATEGORY_BOOK_DEFAULTS
PACKAGE - FND_CURRENCY
VIEW - GL_SETS_OF_BOOKS

APPS.FA_BOOKS_BK_CNTRL_WEB_V is not referenced by any database object

[top of page]

View: FA_BOOKS_BOOK_CONTROLS_V

[top of page]

APPS.FA_BOOKS_BOOK_CONTROLS_V references the following:

APPS
SYNONYM - FA_BOOKS
SYNONYM - FA_BOOK_CONTROLS

APPS.FA_BOOKS_BOOK_CONTROLS_V is not referenced by any database object

[top of page]

View: FA_BOOKS_GROUPS_MRC_V

[top of page]

APPS.FA_BOOKS_GROUPS_MRC_V references the following:

APPS
SYNONYM - FA_MC_BOOKS_GROUPS
APPS.FA_BOOKS_GROUPS_MRC_V is referenced by following:

APPS
PACKAGE BODY - FA_FASCOSTD_XMLP_PKG
PACKAGE BODY - FA_FASCOSTS_XMLP_PKG
PACKAGE BODY - FA_FASRSVED_XMLP_PKG
PACKAGE BODY - FA_FASRSVES_XMLP_PKG

[top of page]

View: FA_BOOKS_GROUPS_V

[top of page]

APPS.FA_BOOKS_GROUPS_V references the following:

APPS
SYNONYM - FA_BOOKS_GROUPS
SYNONYM - FA_DEPRN_SUMMARY
SYNONYM - FA_GROUP_ASSETS
APPS.FA_BOOKS_GROUPS_V is referenced by following:

APPS
VIEW - FA_BOOKS_GROUPS_V1

[top of page]

View: FA_BOOKS_GROUPS_V1

[top of page]

APPS.FA_BOOKS_GROUPS_V1 references the following:

APPS
VIEW - FA_BOOKS_GROUPS_V
VIEW - FA_CURR_DEPRN_ADJ_V

APPS.FA_BOOKS_GROUPS_V1 is not referenced by any database object

[top of page]

View: FA_BOOKS_MRC_V

[top of page]

APPS.FA_BOOKS_MRC_V references the following:

APPS
SYNONYM - FA_MC_BOOKS
APPS.FA_BOOKS_MRC_V is referenced by following:

APPS
PACKAGE BODY - FA_AMORT_PKG
PACKAGE BODY - FA_AMORT_PVT
PACKAGE BODY - FA_ASSET_CALC_PVT
PACKAGE BODY - FA_ASSET_VAL_PVT
PACKAGE BODY - FA_BOOKS_PKG
PACKAGE BODY - FA_BOOK_CONTROLS_PKG
PACKAGE BODY - FA_CALC_DEPRN_BASIS1_PKG
PACKAGE BODY - FA_CALC_DEPRN_BASIS2_PKG
PACKAGE BODY - FA_CDE_PKG
PACKAGE BODY - FA_DEPRN_ROLLBACK_PVT
PACKAGE BODY - FA_FAS400_XMLP_PKG
PACKAGE BODY - FA_FAS401_XMLP_PKG
PACKAGE BODY - FA_FAS403_XMLP_PKG
PACKAGE BODY - FA_FAS480_XMLP_PKG
PACKAGE BODY - FA_FASCOSTD_XMLP_PKG
PACKAGE BODY - FA_FASCOSTS_XMLP_PKG
PACKAGE BODY - FA_FASRSVED_XMLP_PKG
PACKAGE BODY - FA_FASRSVES_XMLP_PKG
PACKAGE BODY - FA_GAINLOSS_DPR_PKG
PACKAGE BODY - FA_GAINLOSS_MIS_PKG
PACKAGE BODY - FA_GAINLOSS_RET_PKG
PACKAGE BODY - FA_GAINLOSS_UND_PKG
PACKAGE BODY - FA_INS_DETAIL_PKG
PACKAGE BODY - FA_MASS_DEPRN_BASIS_PKG
PACKAGE BODY - FA_POLISH_PVT
PACKAGE BODY - FA_PROCESS_GROUPS_PKG
PACKAGE BODY - FA_QUERY_BALANCES_PKG
PACKAGE BODY - FA_RES_LDG_PKG
PACKAGE BODY - FA_RETIREMENT_PVT
PACKAGE BODY - FA_RSVLDG_REP_INS_PKG
PACKAGE BODY - FA_TRACK_MEMBER_PVT
PACKAGE BODY - FA_TXRSV_PKG
PACKAGE BODY - FA_UTIL_PVT
PACKAGE BODY - FA_WHATIF_DEPRN_PKG
PACKAGE BODY - JL_JLMXFGLR_XMLP_PKG
PACKAGE BODY - JL_JLMXFISR_XMLP_PKG
PACKAGE BODY - JL_ZZ_FA_FUNCTIONS_PKG

[top of page]

View: FA_BOOKS_SUMMARY_MRC_V

[top of page]

APPS.FA_BOOKS_SUMMARY_MRC_V references the following:

APPS
SYNONYM - FA_MC_BOOKS_SUMMARY
APPS.FA_BOOKS_SUMMARY_MRC_V is referenced by following:

APPS
PACKAGE BODY - FA_AMORT_PVT
PACKAGE BODY - FA_BOOKS_SUMMARY_PKG
PACKAGE BODY - FA_CALC_DEPRN_BASIS1_PKG
PACKAGE BODY - FA_DEPRN_ROLLBACK_PVT
PACKAGE BODY - FA_POLISH_PVT
PACKAGE BODY - FA_RETIREMENT_PVT
PACKAGE BODY - FA_TERMINAL_GAIN_LOSS_PVT
PACKAGE BODY - FA_TRACK_MEMBER_PVT

[top of page]

View: FA_BOOKS_V

[top of page]

APPS.FA_BOOKS_V references the following:

APPS
SYNONYM - FA_BOOKS
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_METHODS

APPS.FA_BOOKS_V is not referenced by any database object

[top of page]

View: FA_BOOK_CONTROLS_MRC_V

[top of page]

APPS.FA_BOOK_CONTROLS_MRC_V references the following:

APPS
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_MC_BOOK_CONTROLS
APPS.FA_BOOK_CONTROLS_MRC_V is referenced by following:

APPS
PACKAGE BODY - FARX_AL
VIEW - FA_AEL_SL_MRC_V
PACKAGE BODY - FA_AMORT_PVT
PACKAGE BODY - FA_BEGIN_MASS_TRX_PKG
PACKAGE BODY - FA_BOOK_CONTROLS_PKG
PACKAGE BODY - FA_CACHE_PKG
PACKAGE BODY - FA_CALC_DEPRN_BASIS1_PKG
PACKAGE BODY - FA_CALC_DEPRN_BASIS2_PKG
PACKAGE BODY - FA_DEFERRED_DEPRN_PKG
PACKAGE BODY - FA_FAS400_XMLP_PKG
PACKAGE BODY - FA_FAS401_XMLP_PKG
PACKAGE BODY - FA_FAS402_XMLP_PKG
PACKAGE BODY - FA_FAS403_XMLP_PKG
PACKAGE BODY - FA_FAS480_XMLP_PKG
PACKAGE BODY - FA_FAS840_XMLP_PKG
PACKAGE BODY - FA_FASCC_XMLP_PKG
PACKAGE BODY - FA_FASCOSTD_XMLP_PKG
PACKAGE BODY - FA_FASCOSTS_XMLP_PKG
PACKAGE BODY - FA_FASRSVED_XMLP_PKG
PACKAGE BODY - FA_FASRSVES_XMLP_PKG
PACKAGE BODY - FA_GAINLOSS_MIS_PKG
PACKAGE BODY - FA_MASS_DEPRN_BASIS_PKG
PACKAGE BODY - FA_POLISH_PVT
PACKAGE BODY - FA_RES_LDG_PKG
PACKAGE BODY - FA_RSVLDG_REP_INS_PKG
PACKAGE BODY - FA_TERMINAL_GAIN_LOSS_PVT
PACKAGE BODY - JL_JLARFEFR_XMLP_PKG
PACKAGE BODY - JL_JLMXFGLR_XMLP_PKG
PACKAGE BODY - JL_JLMXFIMP_XMLP_PKG
PACKAGE BODY - JL_JLMXFISR_XMLP_PKG
PACKAGE BODY - JL_JLZZFIJR_XMLP_PKG
PACKAGE BODY - JL_ZZ_FA_FUNCTIONS_PKG

[top of page]

View: FA_CAPITALIZE_CIP_V

[top of page]

APPS.FA_CAPITALIZE_CIP_V references the following:

APPS
SYNONYM - FA_ADDITIONS_B
SYNONYM - FA_ADDITIONS_TL
SYNONYM - FA_ASSET_HISTORY
SYNONYM - FA_BOOKS
SYNONYM - FA_DEPRN_PERIODS
SYNONYM - FA_TRANSACTION_HEADERS

APPS.FA_CAPITALIZE_CIP_V is not referenced by any database object

[top of page]

View: FA_CATEGORIES_VL

[top of page]

APPS.FA_CATEGORIES_VL references the following:

APPS
SYNONYM - FA_CATEGORIES_B
SYNONYM - FA_CATEGORIES_TL
APPS.FA_CATEGORIES_VL is referenced by following:

APPS
SYNONYM - FA_CATEGORIES
PACKAGE BODY - OKL_AMH_PVT
VIEW - OKL_AM_AMORT_HOLD_SETUPS_UV
VIEW - OKL_AM_ASSET_DETAILS_CHR_UV
VIEW - OKL_AM_ASSET_DETAILS_UV
VIEW - OKL_AM_OFF_LEASE_TRX_UV
VIEW - OKL_AM_OFF_LSE_TRX_UPD_UV
PACKAGE BODY - OKL_AM_QUOTES_WF
VIEW - OKL_AM_SALVAGE_VALUE_WD_UV

[top of page]

View: FA_CHILD_ASSETS_V

[top of page]

APPS.FA_CHILD_ASSETS_V references the following:

APPS
SYNONYM - FA_ASSET_HIERARCHY

APPS.FA_CHILD_ASSETS_V is not referenced by any database object

[top of page]

View: FA_CURR_DEPRN_ADJ_V

[top of page]

APPS.FA_CURR_DEPRN_ADJ_V references the following:

APPS
SYNONYM - FA_ADJUSTMENTS
SYNONYM - FA_DEPRN_PERIODS
APPS.FA_CURR_DEPRN_ADJ_V is referenced by following:

APPS
VIEW - FA_BOOKS_GROUPS_V1

[top of page]

View: FA_DEFERRED_DEPRN_EVENTS_V

[top of page]

APPS.FA_DEFERRED_DEPRN_EVENTS_V references the following:

APPS
SYNONYM - FA_ADDITIONS_B
SYNONYM - FA_ADDITIONS_TL
SYNONYM - FA_DEFERRED_DEPRN_EVENTS
SYNONYM - FA_DEPRN_PERIODS

APPS.FA_DEFERRED_DEPRN_EVENTS_V is not referenced by any database object

[top of page]

View: FA_DEFERRED_DEPRN_MRC_V

[top of page]

APPS.FA_DEFERRED_DEPRN_MRC_V references the following:

APPS
SYNONYM - FA_MC_DEFERRED_DEPRN
APPS.FA_DEFERRED_DEPRN_MRC_V is referenced by following:

APPS
PACKAGE BODY - FA_DEFERRED_DEPRN_PKG

[top of page]

View: FA_DEPRN_DETAIL_H_MRC_V

[top of page]

APPS.FA_DEPRN_DETAIL_H_MRC_V references the following:

APPS
SYNONYM - FA_MC_DEPRN_DETAIL_H
APPS.FA_DEPRN_DETAIL_H_MRC_V is referenced by following:

APPS
PACKAGE BODY - FA_DEPRN_ROLLBACK_PVT

[top of page]

View: FA_DEPRN_DETAIL_MRC_V

[top of page]

APPS.FA_DEPRN_DETAIL_MRC_V references the following:

APPS
SYNONYM - FA_MC_DEPRN_DETAIL
APPS.FA_DEPRN_DETAIL_MRC_V is referenced by following:

APPS
PACKAGE BODY - FARX_AL
PACKAGE BODY - FA_ADJUSTMENT_PVT
PACKAGE BODY - FA_DEFERRED_DEPRN_PKG
PACKAGE BODY - FA_DEPRN_DETAIL_PKG
PACKAGE BODY - FA_DEPRN_ROLLBACK_PVT
PACKAGE BODY - FA_FAS400_XMLP_PKG
PACKAGE BODY - FA_FAS401_XMLP_PKG
PACKAGE BODY - FA_FAS403_XMLP_PKG
PACKAGE BODY - FA_FAS480_XMLP_PKG
PACKAGE BODY - FA_FASCOSTD_XMLP_PKG
PACKAGE BODY - FA_FASCOSTS_XMLP_PKG
PACKAGE BODY - FA_FASRSVED_XMLP_PKG
PACKAGE BODY - FA_FASRSVES_XMLP_PKG
PACKAGE BODY - FA_GAINLOSS_UPD_PKG
PACKAGE BODY - FA_INS_DETAIL_PKG
PACKAGE BODY - FA_QUERY_BALANCES_PKG
PACKAGE BODY - FA_RES_LDG_PKG
PACKAGE BODY - FA_RSVLDG_REP_INS_PKG
PACKAGE BODY - FA_TRACK_MEMBER_PVT
PACKAGE BODY - FA_TRANSFER_PVT
PACKAGE BODY - JL_JLMXFGLR_XMLP_PKG
PACKAGE BODY - JL_JLMXFISR_XMLP_PKG

[top of page]

View: FA_DEPRN_EVENTS_V

[top of page]

APPS.FA_DEPRN_EVENTS_V references the following:

APPS
SYNONYM - FA_ADDITIONS_B
SYNONYM - FA_ADDITIONS_TL
SYNONYM - FA_DEPRN_EVENTS
SYNONYM - FA_DEPRN_PERIODS
APPS.FA_DEPRN_EVENTS_V is referenced by following:

APPS
PACKAGE BODY - FA_DEPRN_ROLLBACK_PUB

[top of page]

View: FA_DEPRN_GROUPS_V

[top of page]

APPS.FA_DEPRN_GROUPS_V references the following:

APPS
SYNONYM - FA_DEPRN_PERIODS
SYNONYM - FA_DISTRIBUTION_HISTORY
SYNONYM - FA_GROUP_DEPRN_DETAIL
SYNONYM - FA_GROUP_DEPRN_SUMMARY

APPS.FA_DEPRN_GROUPS_V is not referenced by any database object

[top of page]

View: FA_DEPRN_GROUPS_V1

[top of page]

APPS.FA_DEPRN_GROUPS_V1 references the following:

APPS
SYNONYM - FA_BOOKS_GROUPS
SYNONYM - FA_DEPRN_PERIODS
SYNONYM - FA_DISTRIBUTION_HISTORY
SYNONYM - FA_GROUP_DEPRN_DETAIL
SYNONYM - FA_GROUP_DEPRN_SUMMARY

APPS.FA_DEPRN_GROUPS_V1 is not referenced by any database object

[top of page]

View: FA_DEPRN_OVERRIDE_V

[top of page]

APPS.FA_DEPRN_OVERRIDE_V references the following:

APPS
SYNONYM - FA_ADDITIONS
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_CALENDAR_PERIODS
SYNONYM - FA_DEPRN_OVERRIDE

APPS.FA_DEPRN_OVERRIDE_V is not referenced by any database object

[top of page]

View: FA_DEPRN_PERIODS_MRC_V

[top of page]

APPS.FA_DEPRN_PERIODS_MRC_V references the following:

APPS
SYNONYM - FA_MC_DEPRN_PERIODS
APPS.FA_DEPRN_PERIODS_MRC_V is referenced by following:

APPS
PACKAGE BODY - FARX_AL
PACKAGE BODY - FA_AMORT_PVT
PACKAGE BODY - FA_BASIS_OVERRIDE_INIT_PKG
PACKAGE BODY - FA_BOOK_CONTROLS_PKG
PACKAGE BODY - FA_CALC_DEPRN_BASIS1_PKG
PACKAGE BODY - FA_CALC_DEPRN_BASIS2_PKG
PACKAGE BODY - FA_DEFERRED_DEPRN_PKG
PACKAGE BODY - FA_DEPRN_ROLLBACK_PKG
PACKAGE BODY - FA_FAS400_XMLP_PKG
PACKAGE BODY - FA_FAS401_XMLP_PKG
PACKAGE BODY - FA_FAS402_XMLP_PKG
PACKAGE BODY - FA_FAS403_XMLP_PKG
PACKAGE BODY - FA_FAS420_XMLP_PKG
PACKAGE BODY - FA_FAS440_XMLP_PKG
PACKAGE BODY - FA_FAS480_XMLP_PKG
PACKAGE BODY - FA_FAS840_XMLP_PKG
PACKAGE BODY - FA_FASCC_XMLP_PKG
PACKAGE BODY - FA_FASCOSTD_XMLP_PKG
PACKAGE BODY - FA_FASCOSTS_XMLP_PKG
PACKAGE BODY - FA_FASRSVED_XMLP_PKG
PACKAGE BODY - FA_FASRSVES_XMLP_PKG
PACKAGE BODY - FA_MASS_DEPRN_BASIS_PKG
PACKAGE BODY - FA_POLISH_PVT
PACKAGE BODY - FA_RES_LDG_PKG
PACKAGE BODY - FA_RSVLDG_REP_INS_PKG
PACKAGE BODY - FA_TRACK_MEMBER_PVT
PACKAGE BODY - JL_JLARFEFR_XMLP_PKG
PACKAGE BODY - JL_JLMXFGLR_XMLP_PKG
PACKAGE BODY - JL_JLMXFIMP_XMLP_PKG
PACKAGE BODY - JL_JLMXFISR_XMLP_PKG
PACKAGE BODY - JL_JLZZFIJR_XMLP_PKG
PACKAGE BODY - JL_ZZ_FA_FUNCTIONS_PKG

[top of page]

View: FA_DEPRN_SUMMARY_H_MRC_V

[top of page]

APPS.FA_DEPRN_SUMMARY_H_MRC_V references the following:

APPS
SYNONYM - FA_MC_DEPRN_SUMMARY_H
APPS.FA_DEPRN_SUMMARY_H_MRC_V is referenced by following:

APPS
PACKAGE BODY - FA_DEPRN_ROLLBACK_PVT

[top of page]

View: FA_DEPRN_SUMMARY_MRC_V

[top of page]

APPS.FA_DEPRN_SUMMARY_MRC_V references the following:

APPS
SYNONYM - FA_MC_DEPRN_SUMMARY
APPS.FA_DEPRN_SUMMARY_MRC_V is referenced by following:

APPS
PACKAGE BODY - FA_AMORT_PKG
PACKAGE BODY - FA_AMORT_PVT
PACKAGE BODY - FA_CALC_DEPRN_BASIS2_PKG
PACKAGE BODY - FA_DEPRN_ROLLBACK_PUB
PACKAGE BODY - FA_DEPRN_ROLLBACK_PVT
PACKAGE BODY - FA_DEPRN_SUMMARY_PKG
PACKAGE BODY - FA_FAS400_XMLP_PKG
PACKAGE BODY - FA_FAS401_XMLP_PKG
PACKAGE BODY - FA_FAS403_XMLP_PKG
PACKAGE BODY - FA_FAS480_XMLP_PKG
PACKAGE BODY - FA_FASCOSTD_XMLP_PKG
PACKAGE BODY - FA_FASCOSTS_XMLP_PKG
PACKAGE BODY - FA_FASRSVED_XMLP_PKG
PACKAGE BODY - FA_FASRSVES_XMLP_PKG
PACKAGE BODY - FA_GAINLOSS_UND_PKG
PACKAGE BODY - FA_GAINLOSS_UPD_PKG
PACKAGE BODY - FA_INS_DETAIL_PKG
PACKAGE BODY - FA_MASS_DEPRN_BASIS_PKG
PACKAGE BODY - FA_POLISH_PVT
PACKAGE BODY - FA_QUERY_BALANCES_PKG
PACKAGE BODY - FA_RES_LDG_PKG
PACKAGE BODY - FA_RSVLDG_REP_INS_PKG
PACKAGE BODY - FA_TRACK_MEMBER_PVT
PACKAGE BODY - JL_JLMXFGLR_XMLP_PKG
PACKAGE BODY - JL_JLMXFISR_XMLP_PKG
PACKAGE BODY - JL_ZZ_FA_FUNCTIONS_PKG

[top of page]

View: FA_DEPRN_WEB_V

[top of page]

APPS.FA_DEPRN_WEB_V references the following:

APPS
SYNONYM - FA_ADDITIONS
SYNONYM - FA_ADJUSTMENTS
SYNONYM - FA_BOOK_CONTROLS
VIEW - FA_CATEGORIES_B_KFV
SYNONYM - FA_DEPRN_DETAIL
SYNONYM - FA_DEPRN_PERIODS
SYNONYM - FA_DISTRIBUTION_HISTORY
PACKAGE - FND_CURRENCY
VIEW - GL_CODE_COMBINATIONS_KFV
VIEW - GL_SETS_OF_BOOKS

APPS.FA_DEPRN_WEB_V is not referenced by any database object

[top of page]

View: FA_DISTRIBUTION_HISTORY_V

[top of page]

APPS.FA_DISTRIBUTION_HISTORY_V references the following:

APPS
SYNONYM - FA_DISTRIBUTION_HISTORY
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - PER_PEOPLE_X
SYNONYM - PER_PERIODS_OF_SERVICE

APPS.FA_DISTRIBUTION_HISTORY_V is not referenced by any database object

[top of page]

View: FA_DISTRIBUTION_HIST_WEB_V

[top of page]

APPS.FA_DISTRIBUTION_HIST_WEB_V references the following:

APPS
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_DISTRIBUTION_HISTORY
VIEW - FA_LOCATIONS_KFV
SYNONYM - FA_SYSTEM_CONTROLS
VIEW - GL_CODE_COMBINATIONS_KFV
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - PER_PEOPLE_X
SYNONYM - PER_PERIODS_OF_SERVICE

APPS.FA_DISTRIBUTION_HIST_WEB_V is not referenced by any database object

[top of page]

View: FA_DISTRIBUTION_INQUIRY_V

[top of page]

APPS.FA_DISTRIBUTION_INQUIRY_V references the following:

APPS
SYNONYM - FA_ADDITIONS_B
SYNONYM - FA_DISTRIBUTION_HISTORY
SYNONYM - FA_TRANSACTION_HEADERS

APPS.FA_DISTRIBUTION_INQUIRY_V is not referenced by any database object

[top of page]

View: FA_DISTRIBUTION_INQ_WEB_V

[top of page]

APPS.FA_DISTRIBUTION_INQ_WEB_V references the following:

APPS
SYNONYM - FA_ADDITIONS_B
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_DISTRIBUTION_HISTORY
SYNONYM - FA_LOCATIONS
SYNONYM - FA_SYSTEM_CONTROLS
SYNONYM - FA_TRANSACTION_HEADERS
SYNONYM - FND_ID_FLEX_STRUCTURES
SYNONYM - GL_CODE_COMBINATIONS
PACKAGE - HR_SECURITY
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - PER_PERIODS_OF_SERVICE

APPS.FA_DISTRIBUTION_INQ_WEB_V is not referenced by any database object

[top of page]

View: FA_EMPLOYEES

[top of page]

APPS.FA_EMPLOYEES references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - PER_PEOPLE_X
SYNONYM - PER_PERIODS_OF_SERVICE
APPS.FA_EMPLOYEES is referenced by following:

APPS
PACKAGE BODY - CSI_ASSET_PVT
VIEW - FAFV_ASSET_ASSIGNS
VIEW - FA_ASSET_DISTRIBUTION_V
PACKAGE BODY - FA_CUA_ASSET_WB_APIS_PKG
PACKAGE BODY - FA_CUA_HIERARCHY_PKG
VIEW - FA_HIERARCHY_DISTRIBUTIONS_V
VIEW - FA_HR_BATCH_DIST_NEW_V
VIEW - FA_HR_BATCH_DIST_OLD_V
PACKAGE BODY - FA_MASS_REC_UTILS_PKG
PACKAGE BODY - FA_MASS_RET_PUB

[top of page]

View: FA_EMP_ASSET_WEB_V

[top of page]

APPS.FA_EMP_ASSET_WEB_V references the following:

APPS
SYNONYM - FA_ADDITIONS
SYNONYM - FA_ASSET_KEYWORDS
SYNONYM - FA_CATEGORIES
VIEW - FA_CATEGORIES_B_KFV
SYNONYM - FA_DISTRIBUTION_HISTORY
VIEW - FA_LOCATIONS_KFV
VIEW - GL_CODE_COMBINATIONS_KFV
PACKAGE - HR_SECURITY
SYNONYM - PER_ALL_PEOPLE_F

APPS.FA_EMP_ASSET_WEB_V is not referenced by any database object

[top of page]

View: FA_EXTENDED_DEPRN_V

[top of page]

APPS.FA_EXTENDED_DEPRN_V references the following:

APPS
SYNONYM - FA_ADDITIONS_B
SYNONYM - FA_ADDITIONS_TL
SYNONYM - FA_BOOKS
SYNONYM - FA_DEPRN_PERIODS
SYNONYM - FA_DEPRN_SUMMARY
SYNONYM - FA_TRANSACTION_HEADERS

APPS.FA_EXTENDED_DEPRN_V is not referenced by any database object

[top of page]

View: FA_FINANCIAL_INQUIRY_COST_V

[top of page]

APPS.FA_FINANCIAL_INQUIRY_COST_V references the following:

APPS
SYNONYM - FA_ADDITIONS_B
SYNONYM - FA_BOOKS
SYNONYM - FA_BOOKS_BAS
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_CALENDAR_PERIODS
SYNONYM - FA_DEPRN_PERIODS
SYNONYM - FA_LOOKUPS
SYNONYM - FA_TRANSACTION_HEADERS

APPS.FA_FINANCIAL_INQUIRY_COST_V is not referenced by any database object

[top of page]

View: FA_FINANCIAL_INQUIRY_DEPRN_V

[top of page]

APPS.FA_FINANCIAL_INQUIRY_DEPRN_V references the following:

APPS
SYNONYM - FA_ADDITIONS_B
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_DEPRN_PERIODS
SYNONYM - FA_DEPRN_SUMMARY
VIEW - GL_SETS_OF_BOOKS

APPS.FA_FINANCIAL_INQUIRY_DEPRN_V is not referenced by any database object

[top of page]

View: FA_FINANCIAL_INQUIRY_UPL_V

[top of page]

APPS.FA_FINANCIAL_INQUIRY_UPL_V references the following:

APPS
SYNONYM - FA_ADJUSTMENTS
SYNONYM - FA_LOOKUPS
SYNONYM - FA_TRANSACTION_HEADERS

APPS.FA_FINANCIAL_INQUIRY_UPL_V is not referenced by any database object

[top of page]

View: FA_FIN_INQRY_COST_WEB_V

[top of page]

APPS.FA_FIN_INQRY_COST_WEB_V references the following:

APPS
SYNONYM - FA_ADDITIONS_B
SYNONYM - FA_BOOKS
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_DEPRN_PERIODS
SYNONYM - FA_LOOKUPS
SYNONYM - FA_TRANSACTION_HEADERS
PACKAGE - FND_CURRENCY
VIEW - GL_SETS_OF_BOOKS

APPS.FA_FIN_INQRY_COST_WEB_V is not referenced by any database object

[top of page]

View: FA_FIN_INQRY_DEPRN_WEB_V

[top of page]

APPS.FA_FIN_INQRY_DEPRN_WEB_V references the following:

APPS
SYNONYM - FA_ADDITIONS
SYNONYM - FA_ADJUSTMENTS
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_DEPRN_DETAIL
SYNONYM - FA_DEPRN_PERIODS
SYNONYM - FA_DISTRIBUTION_HISTORY
PACKAGE - FND_CURRENCY
VIEW - GL_CODE_COMBINATIONS_KFV
VIEW - GL_SETS_OF_BOOKS

APPS.FA_FIN_INQRY_DEPRN_WEB_V is not referenced by any database object

[top of page]

View: FA_FIN_INQRY_UPL_WEB_V

[top of page]

APPS.FA_FIN_INQRY_UPL_WEB_V references the following:

APPS
SYNONYM - FA_ADJUSTMENTS
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_LOOKUPS
SYNONYM - FA_TRANSACTION_HEADERS
PACKAGE - FND_CURRENCY
VIEW - GL_CODE_COMBINATIONS_KFV
VIEW - GL_SETS_OF_BOOKS

APPS.FA_FIN_INQRY_UPL_WEB_V is not referenced by any database object

[top of page]

View: FA_FUTURE_MASS_ADDITIONS_V

[top of page]

APPS.FA_FUTURE_MASS_ADDITIONS_V references the following:

APPS
SYNONYM - FA_ADDITIONS
SYNONYM - FA_ADDITIONS_B
VIEW - FA_ADDITIONS_NON_SEC_VL
SYNONYM - FA_BOOKS
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_CATEGORIES
SYNONYM - FA_DISTRIBUTION_HISTORY
SYNONYM - FA_LEASES
VIEW - FA_MASS_ADDITIONS_V
SYNONYM - FA_RETIREMENTS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - PO_VENDORS

APPS.FA_FUTURE_MASS_ADDITIONS_V is not referenced by any database object

[top of page]

View: FA_GROUP_COST_INQUIRY_V

[top of page]

APPS.FA_GROUP_COST_INQUIRY_V references the following:

APPS
SYNONYM - FA_BOOKS_GROUPS
SYNONYM - FA_DEPRN_PERIODS
SYNONYM - FA_TRANSACTION_HEADERS

APPS.FA_GROUP_COST_INQUIRY_V is not referenced by any database object

[top of page]

View: FA_GROUP_DEPRN_DETAIL_MRC_V

[top of page]

APPS.FA_GROUP_DEPRN_DETAIL_MRC_V references the following:

APPS
SYNONYM - FA_MC_GROUP_DEPRN_DETAIL

APPS.FA_GROUP_DEPRN_DETAIL_MRC_V is not referenced by any database object

[top of page]

View: FA_GROUP_DEPRN_SUMMARY_MRC_V

[top of page]

APPS.FA_GROUP_DEPRN_SUMMARY_MRC_V references the following:

APPS
SYNONYM - FA_MC_GROUP_DEPRN_SUMMARY

APPS.FA_GROUP_DEPRN_SUMMARY_MRC_V is not referenced by any database object

[top of page]

View: FA_HIERARCHY_BATCH_DETAILS_V

[top of page]

APPS.FA_HIERARCHY_BATCH_DETAILS_V references the following:

APPS
SYNONYM - FA_ADDITIONS
PACKAGE - FA_CUA_ASSET_WB_APIS_PKG
SYNONYM - FA_LOOKUPS
SYNONYM - FA_MASS_UPDATE_BATCH_DETAILS

APPS.FA_HIERARCHY_BATCH_DETAILS_V is not referenced by any database object

[top of page]

View: FA_HIERARCHY_BATCH_HEADER_V

[top of page]

APPS.FA_HIERARCHY_BATCH_HEADER_V references the following:

APPS
PACKAGE - FA_CUA_ASSET_WB_APIS_PKG
SYNONYM - FA_LOOKUPS
SYNONYM - FA_MASS_UPDATE_BATCH_HEADERS
SYNONYM - FND_USER

APPS.FA_HIERARCHY_BATCH_HEADER_V is not referenced by any database object

[top of page]

View: FA_HIERARCHY_DISTRIBUTIONS_V

[top of page]

APPS.FA_HIERARCHY_DISTRIBUTIONS_V references the following:

APPS
SYNONYM - FA_ASSET_HIERARCHY
SYNONYM - FA_ASSET_HIERARCHY_PURPOSE
SYNONYM - FA_ASSET_HIERARCHY_VALUES
PACKAGE - FA_CUA_HIERARCHY_PKG
SYNONYM - FA_DISTRIBUTION_HISTORY
VIEW - FA_EMPLOYEES
SYNONYM - FA_HIERARCHY_DISTRIBUTIONS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY

APPS.FA_HIERARCHY_DISTRIBUTIONS_V is not referenced by any database object

[top of page]

View: FA_HIERARCHY_RULE_DETAILS_V

[top of page]

APPS.FA_HIERARCHY_RULE_DETAILS_V references the following:

APPS
SYNONYM - FA_HIERARCHY_RULE_DETAILS

APPS.FA_HIERARCHY_RULE_DETAILS_V is not referenced by any database object

[top of page]

View: FA_HR_BATCH_DIST_NEW_V

[top of page]

APPS.FA_HR_BATCH_DIST_NEW_V references the following:

APPS
PACKAGE - FA_CUA_ASSET_WB_APIS_PKG
VIEW - FA_EMPLOYEES
SYNONYM - FA_HIERARCHY_DISTRIBUTIONS
SYNONYM - FA_MASS_UPDATE_BATCH_DETAILS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY

APPS.FA_HR_BATCH_DIST_NEW_V is not referenced by any database object

[top of page]

View: FA_HR_BATCH_DIST_OLD_V

[top of page]

APPS.FA_HR_BATCH_DIST_OLD_V references the following:

APPS
PACKAGE - FA_CUA_ASSET_WB_APIS_PKG
SYNONYM - FA_DISTRIBUTION_HISTORY
VIEW - FA_EMPLOYEES
SYNONYM - FA_MASS_UPDATE_BATCH_DETAILS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY

APPS.FA_HR_BATCH_DIST_OLD_V is not referenced by any database object

[top of page]

View: FA_HR_RETIREMENT_DETAILS_V

[top of page]

APPS.FA_HR_RETIREMENT_DETAILS_V references the following:

APPS
SYNONYM - FA_ADDITIONS
SYNONYM - FA_HR_RETIREMENT_DETAILS
SYNONYM - FA_LOOKUPS
SYNONYM - FND_USER

APPS.FA_HR_RETIREMENT_DETAILS_V is not referenced by any database object

[top of page]

View: FA_HR_RETIREMENT_HEADERS_V

[top of page]

APPS.FA_HR_RETIREMENT_HEADERS_V references the following:

APPS
SYNONYM - FA_ASSET_HIERARCHY
SYNONYM - FA_HR_RETIREMENT_HEADERS
SYNONYM - FA_LOOKUPS
SYNONYM - FND_USER

APPS.FA_HR_RETIREMENT_HEADERS_V is not referenced by any database object

[top of page]

View: FA_IMPAIRMENTS_MRC_V

[top of page]

APPS.FA_IMPAIRMENTS_MRC_V references the following:

APPS
SYNONYM - FA_MC_IMPAIRMENTS

APPS.FA_IMPAIRMENTS_MRC_V is not referenced by any database object

[top of page]

View: FA_INS_ADDITIONS_V

[top of page]

APPS.FA_INS_ADDITIONS_V references the following:

APPS
SYNONYM - FA_ADDITIONS_B
SYNONYM - FA_ADDITIONS_TL
SYNONYM - FA_ASSET_KEYWORDS
SYNONYM - FA_BOOKS
SYNONYM - FA_BOOK_CONTROLS
VIEW - GL_SETS_OF_BOOKS

APPS.FA_INS_ADDITIONS_V is not referenced by any database object

[top of page]

View: FA_INS_LINES_V

[top of page]

APPS.FA_INS_LINES_V references the following:

APPS
SYNONYM - FA_INS_LINES
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS

APPS.FA_INS_LINES_V is not referenced by any database object

[top of page]

View: FA_INS_MST_POLS_V

[top of page]

APPS.FA_INS_MST_POLS_V references the following:

APPS
SYNONYM - FA_INS_MST_POLS
VIEW - FND_TERRITORIES_VL
VIEW - PO_VENDORS
VIEW - PO_VENDOR_SITES_ALL
APPS.FA_INS_MST_POLS_V is referenced by following:

APPS
PACKAGE BODY - FA_INS_POLICIES_PKG

[top of page]

View: FA_INS_POLICIES_V

[top of page]

APPS.FA_INS_POLICIES_V references the following:

APPS
PACKAGE - ARP_ADDR_PKG
SYNONYM - FA_INS_MST_POLS
SYNONYM - FA_INS_POLICIES
SYNONYM - FA_PRICE_INDEXES
VIEW - FND_TERRITORIES_VL
VIEW - PO_VENDORS
VIEW - PO_VENDOR_SITES_ALL

APPS.FA_INS_POLICIES_V is not referenced by any database object

[top of page]

View: FA_INVENTORY_V

[top of page]

APPS.FA_INVENTORY_V references the following:

APPS
SYNONYM - FA_ADDITIONS_B
SYNONYM - FA_ADDITIONS_TL
SYNONYM - FA_DISTRIBUTION_HISTORY
SYNONYM - FA_INV_INTERFACE
SYNONYM - FA_LOOKUPS

APPS.FA_INVENTORY_V is not referenced by any database object

[top of page]

View: FA_INVOICE_DETAILS_V

[top of page]

APPS.FA_INVOICE_DETAILS_V references the following:

APPS
SYNONYM - FA_ASSET_INVOICES
VIEW - PO_VENDORS

APPS.FA_INVOICE_DETAILS_V is not referenced by any database object

[top of page]

View: FA_INVOICE_DETAILS_WEB_V

[top of page]

APPS.FA_INVOICE_DETAILS_WEB_V references the following:

APPS
SYNONYM - FA_ASSET_INVOICES
SYNONYM - FA_LOOKUPS
PACKAGE - FND_CURRENCY
VIEW - PO_VENDORS

APPS.FA_INVOICE_DETAILS_WEB_V is not referenced by any database object

[top of page]

View: FA_INVOICE_TRANSFERS_V

[top of page]

APPS.FA_INVOICE_TRANSFERS_V references the following:

APPS
SYNONYM - FA_ADDITIONS_B
SYNONYM - FA_ADDITIONS_TL
SYNONYM - FA_DEPRN_PERIODS
SYNONYM - FA_INVOICE_TRANSACTIONS
SYNONYM - FA_TRX_REFERENCES

APPS.FA_INVOICE_TRANSFERS_V is not referenced by any database object

[top of page]

View: FA_INV_INTERFACE_V

[top of page]

APPS.FA_INV_INTERFACE_V references the following:

APPS
SYNONYM - FA_ASSET_KEYWORDS
SYNONYM - FA_CATEGORIES
SYNONYM - FA_DISTRIBUTION_HISTORY
SYNONYM - FA_INV_INTERFACE
SYNONYM - FA_LOCATIONS
SYNONYM - FA_LOOKUPS

APPS.FA_INV_INTERFACE_V is not referenced by any database object

[top of page]

View: FA_ITF_IMPAIRMENTS_MRC_V

[top of page]

APPS.FA_ITF_IMPAIRMENTS_MRC_V references the following:

APPS
SYNONYM - FA_MC_ITF_IMPAIRMENTS

APPS.FA_ITF_IMPAIRMENTS_MRC_V is not referenced by any database object

[top of page]

View: FA_LEASES_V

[top of page]

APPS.FA_LEASES_V references the following:

APPS
SYNONYM - FA_LEASES
VIEW - PO_VENDORS
VIEW - PO_VENDOR_SITES_ALL

APPS.FA_LEASES_V is not referenced by any database object

[top of page]

View: FA_LEASES_WEB_V

[top of page]

APPS.FA_LEASES_WEB_V references the following:

APPS
SYNONYM - FA_ADDITIONS
VIEW - FA_ASSET_KEYWORDS_KFV
SYNONYM - FA_CATEGORIES_B
VIEW - FA_CATEGORIES_B_KFV
SYNONYM - FA_LEASES
VIEW - PO_VENDORS

APPS.FA_LEASES_WEB_V is not referenced by any database object

[top of page]

View: FA_LEASE_PAYMENT_ITEMS_V

[top of page]

APPS.FA_LEASE_PAYMENT_ITEMS_V references the following:

APPS
SYNONYM - FA_AMORT_SCHEDULES
SYNONYM - FA_LEASES
SYNONYM - FA_LEASE_PAYMENT_ITEMS
VIEW - PO_VENDORS
VIEW - PO_VENDOR_SITES_ALL

APPS.FA_LEASE_PAYMENT_ITEMS_V is not referenced by any database object

[top of page]

View: FA_LOOKUPS_VL

[top of page]

APPS.FA_LOOKUPS_VL references the following:

APPS
SYNONYM - FA_LOOKUPS_B
SYNONYM - FA_LOOKUPS_TL
APPS.FA_LOOKUPS_VL is referenced by following:

APPS
SYNONYM - FA_LOOKUPS

[top of page]

View: FA_LOOKUP_TYPES_VL

[top of page]

APPS.FA_LOOKUP_TYPES_VL references the following:

APPS
SYNONYM - FA_LOOKUP_TYPES_B
SYNONYM - FA_LOOKUP_TYPES_TL
APPS.FA_LOOKUP_TYPES_VL is referenced by following:

APPS
SYNONYM - FA_LOOKUP_TYPES

[top of page]

View: FA_MASS_ADDITIONS_V

[top of page]

APPS.FA_MASS_ADDITIONS_V references the following:

APPS
SYNONYM - FA_ADDITIONS_B
VIEW - FA_ADDITIONS_NON_SEC_VL
SYNONYM - FA_BOOK_CONTROLS_SEC
SYNONYM - FA_LEASES
SYNONYM - FA_LOOKUPS
SYNONYM - FA_MASS_ADDITIONS
SYNONYM - FA_WARRANTIES
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - PER_PEOPLE_F
VIEW - PO_VENDORS
APPS.FA_MASS_ADDITIONS_V is referenced by following:

APPS
VIEW - FA_FUTURE_MASS_ADDITIONS_V

[top of page]

View: FA_MASS_EXTERNAL_TRANSFERS_V

[top of page]

APPS.FA_MASS_EXTERNAL_TRANSFERS_V references the following:

APPS
SYNONYM - FA_ADDITIONS
SYNONYM - FA_ASSET_HISTORY
SYNONYM - FA_BOOKS
SYNONYM - FA_DISTRIBUTION_HISTORY
SYNONYM - FA_MASS_EXTERNAL_TRANSFERS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - PER_PEOPLE_X
SYNONYM - PER_PERIODS_OF_SERVICE

APPS.FA_MASS_EXTERNAL_TRANSFERS_V is not referenced by any database object

[top of page]

View: FA_MASS_EXT_RETIREMENTS_V

[top of page]

APPS.FA_MASS_EXT_RETIREMENTS_V references the following:

APPS
SYNONYM - FA_ADDITIONS
SYNONYM - FA_ASSET_HISTORY
SYNONYM - FA_BOOKS
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_FISCAL_YEAR
SYNONYM - FA_MASS_EXT_RETIREMENTS

APPS.FA_MASS_EXT_RETIREMENTS_V is not referenced by any database object

[top of page]

View: FA_MUPD_V

[top of page]

APPS.FA_MUPD_V references the following:

APPS
SYNONYM - FA_ADDITIONS
PACKAGE - FA_CUA_ASSET_WB_APIS_PKG
SYNONYM - FA_MASS_UPDATE_BATCH_DETAILS

APPS.FA_MUPD_V is not referenced by any database object

[top of page]

View: FA_PRRUN_PERIODS_V

[top of page]

APPS.FA_PRRUN_PERIODS_V references the following:

APPS
SYNONYM - FA_CALENDAR_PERIODS
SYNONYM - FA_CALENDAR_TYPES
SYNONYM - FA_FISCAL_YEAR

APPS.FA_PRRUN_PERIODS_V is not referenced by any database object

[top of page]

View: FA_QUICK_ADDITIONS_V

[top of page]

APPS.FA_QUICK_ADDITIONS_V references the following:

APPS
SYNONYM - FA_ADDITIONS_B
SYNONYM - FA_ADDITIONS_TL
SYNONYM - FA_ASSET_INVOICES
VIEW - PO_VENDORS

APPS.FA_QUICK_ADDITIONS_V is not referenced by any database object

[top of page]

View: FA_QUICK_BOOKS_V

[top of page]

APPS.FA_QUICK_BOOKS_V references the following:

APPS
SYNONYM - FA_BOOKS
SYNONYM - FA_BOOK_CONTROLS

APPS.FA_QUICK_BOOKS_V is not referenced by any database object

[top of page]

View: FA_QUICK_DISTRIBUTIONS_V

[top of page]

APPS.FA_QUICK_DISTRIBUTIONS_V references the following:

APPS
SYNONYM - FA_DISTRIBUTION_HISTORY
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - PER_PEOPLE_F
SYNONYM - PER_PERIODS_OF_SERVICE

APPS.FA_QUICK_DISTRIBUTIONS_V is not referenced by any database object

[top of page]

View: FA_RESERVE_TRANSFERS_V

[top of page]

APPS.FA_RESERVE_TRANSFERS_V references the following:

APPS
SYNONYM - FA_ADDITIONS_B
SYNONYM - FA_ADDITIONS_TL
SYNONYM - FA_DEPRN_PERIODS
SYNONYM - FA_TRX_REFERENCES

APPS.FA_RESERVE_TRANSFERS_V is not referenced by any database object

[top of page]

View: FA_RETIRED_ASSET_WEB_V

[top of page]

APPS.FA_RETIRED_ASSET_WEB_V references the following:

APPS
SYNONYM - FA_ADDITIONS
VIEW - FA_ASSET_KEYWORDS_KFV
SYNONYM - FA_BOOKS
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_CATEGORIES_B
VIEW - FA_CATEGORIES_B_KFV
SYNONYM - FA_RETIREMENTS
SYNONYM - FA_TRANSACTION_HEADERS
PACKAGE - FND_CURRENCY
VIEW - GL_SETS_OF_BOOKS

APPS.FA_RETIRED_ASSET_WEB_V is not referenced by any database object

[top of page]

View: FA_RETIREMENTS_MRC_V

[top of page]

APPS.FA_RETIREMENTS_MRC_V references the following:

APPS
SYNONYM - FA_MC_RETIREMENTS
APPS.FA_RETIREMENTS_MRC_V is referenced by following:

APPS
PACKAGE BODY - FARX_AL
PACKAGE BODY - FA_AMORT_PVT
PACKAGE BODY - FA_CALC_DEPRN_BASIS1_PKG
PACKAGE BODY - FA_CALC_DEPRN_BASIS2_PKG
PACKAGE BODY - FA_GAINLOSS_DPR_PKG
PACKAGE BODY - FA_GAINLOSS_PKG
PACKAGE BODY - FA_GAINLOSS_UND_PKG
PACKAGE BODY - FA_GAINLOSS_UPD_PKG
PACKAGE BODY - FA_PROCESS_GROUPS_PKG
PACKAGE BODY - FA_RETIREMENTS_PKG
PACKAGE BODY - FA_RETIREMENT_PVT
PACKAGE BODY - FA_TRACK_MEMBER_PVT
PACKAGE BODY - FA_UTIL_PVT
PACKAGE BODY - JL_JLMXFGLR_XMLP_PKG
PACKAGE BODY - JL_JLMXFIMP_XMLP_PKG
PACKAGE BODY - JL_JLMXFISR_XMLP_PKG

[top of page]

View: FA_RETIREMENTS_V

[top of page]

APPS.FA_RETIREMENTS_V references the following:

APPS
SYNONYM - FA_ADDITIONS_B
SYNONYM - FA_ADDITIONS_TL
SYNONYM - FA_ASSET_HISTORY
SYNONYM - FA_BOOKS
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_FISCAL_YEAR
SYNONYM - FA_RETIREMENTS
SYNONYM - FA_TRANSACTION_HEADERS

APPS.FA_RETIREMENTS_V is not referenced by any database object

[top of page]

View: FA_RETIREMENTS_WEB_V

[top of page]

APPS.FA_RETIREMENTS_WEB_V references the following:

APPS
SYNONYM - FA_ADDITIONS
SYNONYM - FA_ASSET_HISTORY
SYNONYM - FA_BOOKS
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_FISCAL_YEAR
SYNONYM - FA_RETIREMENTS
SYNONYM - FA_TRANSACTION_HEADERS
PACKAGE - FND_CURRENCY
VIEW - GL_SETS_OF_BOOKS

APPS.FA_RETIREMENTS_WEB_V is not referenced by any database object

[top of page]

View: FA_RETIREMENT_ADJUSTMENTS_V

[top of page]

APPS.FA_RETIREMENT_ADJUSTMENTS_V references the following:

APPS
SYNONYM - FA_ADJUSTMENTS
SYNONYM - FA_TRANSACTION_HEADERS

APPS.FA_RETIREMENT_ADJUSTMENTS_V is not referenced by any database object

[top of page]

View: FA_RETIREMENT_REQUESTS_V

[top of page]

APPS.FA_RETIREMENT_REQUESTS_V references the following:

APPS
SYNONYM - FA_ADDITIONS
SYNONYM - FA_ASSET_HISTORY
SYNONYM - FA_BOOKS
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_CALENDAR_PERIODS
SYNONYM - FA_DEPRN_PERIODS
SYNONYM - FA_LOOKUPS
SYNONYM - FA_MASS_RETIREMENTS
SYNONYM - FA_RETIREMENTS
SYNONYM - FA_TRANSACTION_HEADERS

APPS.FA_RETIREMENT_REQUESTS_V is not referenced by any database object

[top of page]

View: FA_RX_ATTRSETS_VL

[top of page]

APPS.FA_RX_ATTRSETS_VL references the following:

APPS
SYNONYM - FA_RX_ATTRSETS_B
SYNONYM - FA_RX_ATTRSETS_TL
APPS.FA_RX_ATTRSETS_VL is referenced by following:

APPS
SYNONYM - FA_RX_ATTRSETS

[top of page]

View: FA_RX_CR_REPORTS_V

[top of page]

APPS.FA_RX_CR_REPORTS_V references the following:

APPS
SYNONYM - FA_RX_REPORTS
VIEW - FND_APPLICATION_ALL_VIEW
VIEW - FND_CONCURRENT_PROGRAMS_VL
PACKAGE - FND_GLOBAL
SYNONYM - FND_REQUEST_GROUP_UNITS

APPS.FA_RX_CR_REPORTS_V is not referenced by any database object

[top of page]

View: FA_RX_NOCR_REPORTS_V

[top of page]

APPS.FA_RX_NOCR_REPORTS_V references the following:

APPS
SYNONYM - FA_RX_REPORTS
VIEW - FND_APPLICATION_ALL_VIEW
PACKAGE - FND_GLOBAL
VIEW - FND_RESPONSIBILITY_VL

APPS.FA_RX_NOCR_REPORTS_V is not referenced by any database object

[top of page]

View: FA_RX_REPORTS_V

[top of page]

APPS.FA_RX_REPORTS_V references the following:

APPS
SYNONYM - FA_RX_REPORTS
VIEW - FND_APPLICATION_ALL_VIEW
VIEW - FND_CONCURRENT_PROGRAMS_VL
PACKAGE - FND_GLOBAL
VIEW - FND_RESPONSIBILITY_VL
APPS.FA_RX_REPORTS_V is referenced by following:

APPS
PACKAGE BODY - FA_RX_PUBLISH
PACKAGE BODY - FV_FACTS1_PKG

[top of page]

View: FA_RX_REP_COLUMNS_VL

[top of page]

APPS.FA_RX_REP_COLUMNS_VL references the following:

APPS
SYNONYM - FA_RX_REP_COLUMNS_B
SYNONYM - FA_RX_REP_COLUMNS_TL
APPS.FA_RX_REP_COLUMNS_VL is referenced by following:

APPS
SYNONYM - FA_RX_REP_COLUMNS

[top of page]

View: FA_RX_REP_PARAMETERS_V

[top of page]

APPS.FA_RX_REP_PARAMETERS_V references the following:

APPS
SYNONYM - FA_RX_LOV
SYNONYM - FA_RX_REP_PARAMETERS

APPS.FA_RX_REP_PARAMETERS_V is not referenced by any database object

[top of page]

View: FA_RX_SUMMARY_VL

[top of page]

APPS.FA_RX_SUMMARY_VL references the following:

APPS
SYNONYM - FA_RX_SUMMARY_TL
APPS.FA_RX_SUMMARY_VL is referenced by following:

APPS
SYNONYM - FA_RX_SUMMARY

[top of page]

View: FA_SOURCE_LINES_V

[top of page]

APPS.FA_SOURCE_LINES_V references the following:

APPS
SYNONYM - FA_ASSET_INVOICES
SYNONYM - FA_EXT_INV_RETIREMENTS
VIEW - PO_VENDORS

APPS.FA_SOURCE_LINES_V is not referenced by any database object

[top of page]

View: FA_SXL_BOOKS_V

[top of page]

APPS.FA_SXL_BOOKS_V references the following:

APPS
SYNONYM - FA_BOOKS

APPS.FA_SXL_BOOKS_V is not referenced by any database object

[top of page]

View: FA_TRANSACTIONS_V

[top of page]

APPS.FA_TRANSACTIONS_V references the following:

APPS
SYNONYM - FA_ADDITIONS_B
SYNONYM - FA_ADDITIONS_TL
SYNONYM - FA_DEPRN_PERIODS
SYNONYM - FA_TRANSACTION_HEADERS

APPS.FA_TRANSACTIONS_V is not referenced by any database object

[top of page]

View: FA_TRANSACTION_HEADERS_V

[top of page]

APPS.FA_TRANSACTION_HEADERS_V references the following:

APPS
SYNONYM - FA_ADDITIONS_B
SYNONYM - FA_ASSET_HISTORY
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_TRANSACTION_HEADERS

APPS.FA_TRANSACTION_HEADERS_V is not referenced by any database object

[top of page]

View: FA_TRANSACTION_HISTORY_BOOKS_V

[top of page]

APPS.FA_TRANSACTION_HISTORY_BOOKS_V references the following:

APPS
SYNONYM - FA_ADDITIONS_B
SYNONYM - FA_ADDITIONS_TL
SYNONYM - FA_BOOKS
SYNONYM - FA_LOOKUPS_B
SYNONYM - FA_LOOKUPS_TL
SYNONYM - FA_TRANSACTION_HEADERS
PACKAGE - FND_NUMBER

APPS.FA_TRANSACTION_HISTORY_BOOKS_V is not referenced by any database object

[top of page]

View: FA_TRANSACTION_HISTORY_TRX_V

[top of page]

APPS.FA_TRANSACTION_HISTORY_TRX_V references the following:

APPS
SYNONYM - FA_ADDITIONS_B
SYNONYM - FA_ADDITIONS_TL
SYNONYM - FA_ASSET_HISTORY
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_CALENDAR_PERIODS
SYNONYM - FA_CATEGORIES
SYNONYM - FA_DEPRN_PERIODS
SYNONYM - FA_LOOKUPS_B
SYNONYM - FA_LOOKUPS_TL
SYNONYM - FA_TRANSACTION_HEADERS
SYNONYM - FA_TRX_REFERENCES

APPS.FA_TRANSACTION_HISTORY_TRX_V is not referenced by any database object

[top of page]

View: FA_TRANSFER_INVOICES_V

[top of page]

APPS.FA_TRANSFER_INVOICES_V references the following:

APPS
SYNONYM - FA_ADDITIONS_B
SYNONYM - FA_ADDITIONS_TL
SYNONYM - FA_BOOKS
SYNONYM - FA_BOOK_CONTROLS

APPS.FA_TRANSFER_INVOICES_V is not referenced by any database object

[top of page]

View: FA_TRANS_HIST_BOOKS_WEB_V

[top of page]

APPS.FA_TRANS_HIST_BOOKS_WEB_V references the following:

APPS
SYNONYM - FA_BOOKS
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_LOOKUPS
SYNONYM - FA_TRANSACTION_HEADERS
PACKAGE - FND_CURRENCY
PACKAGE - FND_NUMBER
VIEW - GL_SETS_OF_BOOKS

APPS.FA_TRANS_HIST_BOOKS_WEB_V is not referenced by any database object

[top of page]

View: FA_TRANS_HIST_TRX_WEB_V

[top of page]

APPS.FA_TRANS_HIST_TRX_WEB_V references the following:

APPS
SYNONYM - FA_ADDITIONS
SYNONYM - FA_ASSET_HISTORY
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_CALENDAR_PERIODS
SYNONYM - FA_CATEGORIES_B
VIEW - FA_CATEGORIES_B_KFV
SYNONYM - FA_DEPRN_PERIODS
SYNONYM - FA_LOOKUPS
SYNONYM - FA_TRANSACTION_HEADERS

APPS.FA_TRANS_HIST_TRX_WEB_V is not referenced by any database object

[top of page]

View: FA_UNPLANNED_DEPR_V

[top of page]

APPS.FA_UNPLANNED_DEPR_V references the following:

APPS
SYNONYM - FA_ADJUSTMENTS
SYNONYM - FA_LOOKUPS
SYNONYM - FA_TRANSACTION_HEADERS

APPS.FA_UNPLANNED_DEPR_V is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract