ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1543869E053B46B63588994 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 JL JLARFEFR_XML Y US JL Argentine Exhibit of Fixed Assets - draft 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 BI Publisher :c_base_currency_code :c_base_description :c_base_min_acct_unit :c_base_precision :c_organization_name :c_period_from :c_period_to :c_scaling_factor :lp_currency_code :lp_fa_adjustments :lp_fa_asset_invoices :lp_fa_book_controls :lp_fa_books :lp_fa_deferred_deprn :lp_fa_deprn_detail :lp_fa_deprn_periods :lp_fa_deprn_summary :lp_fa_retirements :p_book_type_code :p_ca_org_id :p_ca_set_of_books_id :p_conc_request_id :p_corp_book :p_detail_level :p_end_of_report :p_mrcsobtype :p_no_data_found :p_period_counter_from :p_period_counter_to