FA(资产)常用SQL

select * from FA_SYSTEM_CONTROLS 资产系统控制
select * from FA_LOCATIONS 地点
select * from FA_ASSET_KEYWORDS 资产关键字

select fltv.LOOKUP_TYPE,fltv.MEANING,fltv.DESCRIPTION,fltv.USER_MAINTAINABLE 快速编码
,flv.LOOKUP_CODE,flv.MEANING,flv.DESCRIPTION
from FA_LOOKUP_TYPES_VL fltv, FA_LOOKUPS_VL flv
where fltv.LOOKUP_TYPE=flv.LOOKUP_TYPE
and fltv.MEANING='报废'

select * from FA_LOOKUPS_TL T where T.Lookup_Type='FISCAL YEAR' 会计年度
select * from FA_FISCAL_YEAR

select * from FA_CALENDAR_TYPES 资产日历
select * from FA_CALENDAR_PERIODS

select * from hr_lookups 资产组织
where meaning='资产组织'

select * from FA_BOOK_CONTROLS 资产账簿
select * from FA_METHODS 折旧方法
select * from FA_FLAT_RATES 折旧比率
select * from FA_CONVENTION_TYPES 比例分摊惯例
select * from FA_CONVENTIONS

select *from FA_CATEGORIES_VL 资产分类
select *from FA_CATEGORY_BOOK_DEFAULTS 资产类别的默认折旧规则
--==============================================================================\\
SELECT tab.application_id,tab.table_name,tab.description \\
FROM fnd_tables tab WHERE tab.table_name LIKE  '%FA%BOOK%'

--==============================================================================\\
SELECT * FROM apps.fa_system_controls;
--------------------------------------------------------------------------------
--Asset info
SELECT * FROM apps.fa_books;

--definition of an asset book
SELECT * FROM apps.fa_book_controls;

--cost and reserve accounts for a book and category combination
SELECT * FROM apps.fa_category_books;

--asset categories
SELECT * FROM apps.fa_categories_b;

SELECT * FROM apps.fa_category_book_defaults;

--FA locations
SELECT * FROM apps.fa_locations_kfv;

--fa employee
SELECT * FROM apps.fa_employees;
SELECT * FROM per_all_people_f; 

--asset key
SELECT * FROM apps.fa_asset_keywords; 
--------------------------------------------------------------------------------

SELECT * FROM apps.fa_mass_additions;

SELECT * FROM apps.fa_additions_b;

SELECT * FROM apps.fa_transaction_headers; 

--information about asset reclassification, capitalizations, unit adjustments,
--and partial unit retirements
SELECT * FROM apps.fa_asset_history;

SELECT * FROM apps.fa_asset_distribution_V

SELECT * FROM apps.fa_distribution_history 

SELECT * FROM apps.fa_deleted_mass_additions;
--------------------------------------------------------------------------------
--Assets needs to create journal entries for transactions \\
SELECT * FROM apps.fa_adjustments;

SELECT * FROM apps.fa_transfer_details;

SELECT * FROM apps.fa_deprn_detail;

SELECT * FROM apps.fa_deprn_periods;

SELECT * FROM apps.fa_deprn_override;

--depreciation information for your assets
SELECT * FROM apps.fa_deprn_summary;


--==============================================================================
/*
delete FROM apps.fa_deleted_mass_additions;\\

DELETE FROM apps.fa_mass_additions test WHERE test.description LIKE '%hawk%'

*/ --===========================================================================

/*--删除mass addition信息\\

DELETE FROM apps.fa_mass_additions test WHERE test.description LIKE '%hawk%'
*/ --===========================================================================

--fa_mass_additions :
/* stores information on assets you want to automatically add to Oracle Assets 
  from another system.  ******** FA_ADDITIONS_B contains descriptive information 
  to help you identify your assets. Oracle Assets does not use this table to 
  calculate depreciation.When you add an asset, Oracle Assets inserts a row into 
  this table and into FA_ASSET_HISTORY.When you change the asset information 
  stored in this table, Oracle Assets updates it in this table. It also creates 
  a new row in FA_ASSET_HISTORY.*/

--fa_distribution_history
-- assign who and details the assets
-- to allocate depreciation expenses, and the Transfers form uses it to maintain 
-- an audit trail of asset transfers

--FA_DEPRN_DETAIL  
-- contains the depreciation amounts that the depreciation program charges to the
-- depreciation expense account for a particular asset and accounting period.