JG Statutory Asset Ledger - draft

Description
Categories: BI Publisher
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
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
COA ID
 
Number
Second Global Attribute
 
LOV Oracle
First Global Attribute
 
LOV Oracle
Country
 
LOV Oracle
Precision Width
 
Number
Precision
 
LOV Oracle
Parent Totals
 
LOV Oracle
Period
 
LOV Oracle
Balancing Segment
 
Book
 
LOV Oracle
Official Run
 
LOV Oracle