select
fa.asset_number,
fa.description,
fc.current_cost original_cost,
fd.deprn_reserve accum_deprn,
fc.current_cost-fd.deprn_reserve current_value
from
fa_additions fa,
fa_asset_keywords_kfv fk,
fa_financial_inquiry_cost_v fc,
fa_deprn_summary fd,
fa_categories fca,
(select asset_id,max(transaction_header_id_in) header_id from fa_financial_inquiry_cost_v group by asset_id) max_fc,
(select asset_id,max(deprn_run_date) deprn_run_date from fa_deprn_summary group by asset_id) max_fd
where
fc.asset_id=fd.asset_id
and fa.asset_category_id=fca.category_id
and fc.asset_id=fa.asset_id
and fa.asset_key_ccid=fk.code_combination_id
and fc.asset_id=max_fc.asset_id
and fc.transaction_header_id_in=max_fc.header_id
and fd.asset_id=max_fd.asset_id
and fd.deprn_run_date=max_fd.deprn_run_date
and fd.deprn_source_code='DEPRN'
fa.asset_number,
fa.description,
fc.current_cost original_cost,
fd.deprn_reserve accum_deprn,
fc.current_cost-fd.deprn_reserve current_value
from
fa_additions fa,
fa_asset_keywords_kfv fk,
fa_financial_inquiry_cost_v fc,
fa_deprn_summary fd,
fa_categories fca,
(select asset_id,max(transaction_header_id_in) header_id from fa_financial_inquiry_cost_v group by asset_id) max_fc,
(select asset_id,max(deprn_run_date) deprn_run_date from fa_deprn_summary group by asset_id) max_fd
where
fc.asset_id=fd.asset_id
and fa.asset_category_id=fca.category_id
and fc.asset_id=fa.asset_id
and fa.asset_key_ccid=fk.code_combination_id
and fc.asset_id=max_fc.asset_id
and fc.transaction_header_id_in=max_fc.header_id
and fd.asset_id=max_fd.asset_id
and fd.deprn_run_date=max_fd.deprn_run_date
and fd.deprn_source_code='DEPRN'
You made some decent factors there. I looked on the internet for the difficulty and found most individuals will associate with along with your website.
ReplyDeleteAsset Management Software India
Asset Management Software Chennai
Asset Management Software
Asset Management Software Mumbai
We provide the highest level of quality software products and cms contract management system, services globally that meet the needs of our customers by maintaining our staff as our principal asset and being responsive to market expectations. Any progressive business demands the right tools to guide innovation and achieve strategic superiority. Having worked with more than 200 finance and leasing companies in over 30 countries, NETSOL Technologies understands the unique operational challenges of todays leasing and finance companies and empowers these organizations to achieve business excellence. Our customized approach and commitment to providing superior quality IT solutions has enabled us to help our clients streamline their business operations and optimize efficiency.
ReplyDelete