FA Asset Addition Report

[alamaijaz]

Hi,

Asset Addition Report show both CIP status and CAPITILIZED status of an asset. I added a parameter fa_books.date_placed_in_service from '01-JAN-2007' TO '30-APR-2008'. When I run it on dated 30th April 2008 the data was correct, but after 10 days I run it with same parameter value the data got change. the Query is below,

(select distinct
fac.segment1 C_MAJOR,fac.segment2 C_MINOR,
fac.segment3 C_LEVEL3,
fac.description C_CATEGORY,
faa.asset_NUMBER asset_id ,
faa.asset_id mtc_asset_id,
faa.description C_ASSET_DESCRIPTION,
faa.tag_number,
fabk.date_placed_in_service ,
faa.asset_Category_id,
--ASH fabk.original_cost C_ASS_COST
fabk.cost C_ASS_COST --ASH (original - retired)
from fa_additions faa ,
fa_books fabk,fa_categories fac,fa_distribution_history hst
where fabk.date_placed_in_service between '01-jan-03' and '30-apr-08'
and faa.asset_id=hst.asset_id
and faa.asset_category_id=fac.category_id
and faa.asset_id = fabk.asset_id
AND FABK.DATE_INEFFECTIVE IS NULL
AND FABK.TRANSACTION_HEADER_ID_OUT IS NULL
AND hst.DATE_INEFFECTIVE IS NULL
AND hst.TRANSACTION_HEADER_ID_OUT IS NULL
and hst.book_type_code=fabk.book_type_code
and fabk.book_type_code='MTC-VB FA BOOK)