Introduction:
This query will provide the complete asset details in oracle apps. We can use this query to develop the custom fixed assets reports in oracle apps and can extract the fixed asset data from system.
Script:
select distinct a.ASSET_ID,a.last_update_date,a.BOOK_TYPE_CODE,a.LIFE_IN_MONTHS,a.DEPRN_METHOD_CODE,
a.ORIGINAL_COST,a.cost,b.DEPRN_AMOUNT,b.YTD_DEPRN,b.DEPRN_RESERVE “Accumulted_depr”,
(a.original_cost – nvl(b.DEPRN_RESERVE,0)) “Net Book Value”
from
apps.fa_books a,apps.fa_deprn_detail b,apps.fa_deprn_periods c
where a.asset_id=b.asset_id
AND b.period_counter = c.period_counter
–and a.asset_id=1183535
and a.BOOK_TYPE_CODE=’DO_IND_CORP_BOOK’
and c.FISCAL_YEAR=’2019′
and c.PERIOD_COUNTER=242388 and b.DEPRN_SOURCE_CODE=’D’
— AND a.DATE_INEFFECTIVE is null
AND (a.DATE_INEFFECTIVE is null or a.DATE_INEFFECTIVE between c.PERIOD_OPEN_DATE and c.PERIOD_CLOSE_DATE)
— and a.last_update_date like ‘%NOV-19′”
Got any queries?
Do drop a note by writing us at yeswanth.r@doyensys.com or use the comment section below to ask your questions
