JG Statutory Asset Ledger Report- Not Supported: Reserved For Future Use

select
	i.asset_number, 
	i.description,
	i.company, 
	substr(i.asset_cost_acct, 1, :P_PRECISION * :P_PRECISION_WIDTH) parent_account,
	i.asset_cost_acct cost_account,
	i.account_description,
	i.date_placed_in_service, 
       	a.commitment,          
       	a.investment_law,           
	nvl(sum(i.cost), 0) cost,
	nvl(sum(i.ltd_deprn), 0) reserve,
	nvl(sum(i.nbv), 0) nbv,
	i.serial_number,
	i.tag_number,
	i.category,
	i.employee_name,
	i.employee_number,
	nvl(i.life_yr_mo,0),
	nvl(i.ytd_deprn,0),
	nvl(i.deprn_amount,0),
	nvl(i.nbv_beginning_fy,0),
	i.deprn_expense_acct,
	i.accum_deprn_acct,
	i.expense_acct_description,
	i.functional_currency_code,
	i.cost_center,
	i.cost_center_description,
	i.company_description,
	i.category_description,
	i.organization_name,
	i.major_category_description,
	i.minor_category_description, 
	JG_JGZZFALE_XMLP_PKG.cf_parent_acct_descrformula(substr ( i.asset_cost_acct , 1 , :P_PRECISION * :P_PRECISION_WIDTH )) CF_PARENT_ACCT_DESCR
from
	fa_additions a,
	fa_deprn_rep_itf i
where
	i.request_id = :P_CONC_REQUEST_ID and
	i.company = :P_BALANCING_SEGMENT and
	a.asset_number = i.asset_number
group by
	i.asset_number, 
	i.description,
	i.company,
	substr(i.asset_cost_acct, 1, :P_PRECISION * :P_PRECISION_WIDTH),
	i.asset_cost_acct,
	i.account_description,
	i.date_placed_in_service,
       	a.commitment,          
       	a.investment_law,
	i.serial_number,
	i.tag_number,
	i.category,
	i.employee_name,
	i.employee_number,
	i.life_yr_mo,
	nvl(i.ytd_deprn,0),
	nvl(i.deprn_amount,0),
	nvl(i.nbv_beginning_fy,0),
	i.deprn_expense_acct,
	i.accum_deprn_acct,
	i.expense_acct_description,
	i.functional_currency_code,
	i.cost_center,
	i.cost_center_description,
	i.company_description,
	i.category_description,
	i.organization_name,
	i.major_category_description,
	i.minor_category_description
order by
	i.asset_cost_acct,
	i.asset_number