JL Argentine Exhibit of Fixed Assets - draft

Description
Categories: BI Publisher
Application: Latin America Localizations
Source: Argentine Exhibit of Fixed Assets Report (XML) - Not Supported: Reserved For Future Use
Short Name: JLARFEFR_XML
DB package: JL_JLARFEFR_XMLP_PKG
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