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

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Statutory Asset Ledger Report
Application: Regional Localizations
Source: Statutory Asset Ledger Report (XML) - Not Supported: Reserved For Future Use
Short Name: JGZZFALE_XML
DB package: JG_JGZZFALE_XMLP_PKG
Run JG Statutory Asset Ledger Report- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Parameter Name SQL text Validation
Official Run
 
LOV Oracle
Book
 
LOV Oracle
Balancing Segment
 
Char
Period
 
LOV Oracle
Parent Totals
 
LOV Oracle
Precision
 
LOV Oracle
Precision Width
 
Number
Country
 
LOV Oracle
First Global Attribute
 
LOV Oracle
Second Global Attribute
 
LOV Oracle
Blitz Report™