JL Argentine Exhibit of Fixed Assets - draft

SELECT
a.conc_request_id                     c_conc_request_id,
a.exhibit_group_id                     c_category_id,
a.asset_id                                 c_asset_id,
round(a.begin_cost ,0)                            c_FOR_initial_cost,
round(a.additions ,0)                               c_FOR_additions,
round(a.retirements,0)                            c_FOR_retirements,
round(a.transfers ,0)                               c_FOR_transfer,
round(a.end_cost  ,0)                              c_end_cost,
round(a.begin_accum_depr,0)                c_FOR_initial_accum_deprn,
round(a.accum_depr_retirements,0)      c_FOR_retirement_deprn_amount,
round(a.accum_depr_transfers ,0)          c_FOR_transfer_deprn_amount,
round(a.accum_depr_rpt_period ,0)        c_FOR_deprn_amount,
round(a.deprn_reserve ,0)                       c_FOR_accum_deprn_end_fy,
round((a.end_cost - a.deprn_reserve),0)  c_net_book_value ,
b.asset_number                              c_asset_number,
c.name                                         c_group_description
FROM  jl_ar_fa_exhibit_report a , fa_additions b,jl_ar_fa_exhibit_groups c
WHERE a.asset_id = b.asset_id
and  c.exhibit_group_id = a.exhibit_group_id
 ORDER BY 16 ASC,2 ASC , a.exhibit_group_id

SELECT a.conc_request_id c_conc_request_id, a.exhibit_group_id c_category_id, a.asset_id c_asset_id, round(a.begin_cost ,0) c_FOR_initial_cost, round(a.additions ,0) c_FOR_additions, round(a.retirements,0) c_FOR_retirements, round(a.transfers ,0) c_FOR_transfer, round(a.end_cost ,0) c_end_cost, round(a.begin_accum_depr,0) c_FOR_initial_accum_deprn, round(a.accum_depr_retirements,0) c_FOR_retirement_deprn_amount, round(a.accum_depr_transfers ,0) c_FOR_transfer_deprn_amount, round(a.accum_depr_rpt_period ,0) c_FOR_deprn_amount, round(a.deprn_reserve ,0) c_FOR_accum_deprn_end_fy, round((a.end_cost - a.deprn_reserve),0) c_net_book_value , b.asset_number c_asset_number, c.name c_group_description FROM jl_ar_fa_exhibit_report a , fa_additions b,jl_ar_fa_exhibit_groups c WHERE a.asset_id = b.asset_id and c.exhibit_group_id = a.exhibit_group_id ORDER BY 16 ASC,2 ASC , a.exhibit_group_id