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
Source: Argentine Exhibit of Fixed Assets Report (XML) - Not Supported: Reserved For Future Use
Short Name: JLARFEFR_XML
DB package: JL_JLARFEFR_XMLP_PKG
Run
JL Argentine Exhibit of Fixed Assets - draft and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
