JG Statutory Asset Cost/Reserve Detail - draft

Description
Categories: BI Publisher
Application: Regional Localizations
Source: Statutory Asset Cost/Reserve Detail Report (XML) - Not Supported: Reserved For Future Use
Short Name: JGZZFAAD_XML
DB package: JG_JGZZFAAD_XMLP_PKG
select
	i.asset_number, 
	i.company,
	substr(i.cost_account, 1, :P_PRECISION * :P_PRECISION_WIDTH) parent_account,
	substr(i.cost_account, 1, :P_PRECISION * :P_PRECISION_WIDTH) parent_acct,
	i.account,
	i.account_description,
	i.cost_account,
	i.date_placed_in_service, 
 	round(i.stl_depreciation_rate, 2) stl_depreciation_rate,
	i.concat_vendor_name vendor_name,
	i.concat_invoice_number invoice_number,
	i.concat_location location,
	i.concat_retirement_type retirement_type,
	nvl(sum(i.cost_begin_balance), 0) cost_begin_balance,
	nvl(sum(i.begin_balance), 0) begin_balance,
	nvl(sum(&lp_dynamic_col), 0) additions,
	nvl(sum(i.revaluations), 0) revaluations,
	nvl(sum(i.retirements), 0) * -1 retirements,
	nvl(sum(i.reclasses), 0) reclasses,
	nvl(sum(i.adjustments), 0) adjustments,
	nvl(sum(i.end_balance), 0) end_balance, 
	JG_JGZZFAAD_XMLP_PKG.cf_pareant_acct_descrformula(substr(i.cost_account, 1, :P_PRECISION * :P_PRECISION_WIDTH)) CF_parent_acct_descr, 
--	JG_JGZZFAAD_XMLP_PKG.cf_begin_balanceformula(:cs_begin_balance_rtot, nvl(sum(i.begin_balance), 0)) cf_begin_balance_cf, 
--	JG_JGZZFAAD_XMLP_PKG.cf_additions_cfformula(:cs_additions_rtot, nvl(sum(i.additions), 0)) cf_additions_cf, 
--	JG_JGZZFAAD_XMLP_PKG.cf_retirements_cfformula(:cs_retirements_rtot, nvl(sum(i.retirements), 0) * -1) cf_retirements_cf, 
--	JG_JGZZFAAD_XMLP_PKG.cf_revaluations_cfformula(:cs_revaluations_rtot, nvl(sum(i.revaluations), 0)) cf_revaluations_cf, 
--	JG_JGZZFAAD_XMLP_PKG.cf_reclasses_cfformula(:cs_reclasses_rtot, nvl(sum(i.reclasses), 0)) cf_reclasses_cf, 
--	JG_JGZZFAAD_XMLP_PKG.cf_adjustments_cfformula(:cs_adjustments_rtot, nvl(sum(i.adjustments), 0)) cf_adjustments_cf, 
--	JG_JGZZFAAD_XMLP_PKG.cf_cost_begin_balance_cfformul(:cs_cost_begin_balance_rtot, nvl(sum(i.cost_begin_balance), 0)) cf_cost_begin_balance_cf, 
--	JG_JGZZFAAD_XMLP_PKG.cf_end_balance_cfformula(:cs_end_balance_rtot, nvl(sum(i.end_balance), 0)) cf_end_balance_cf, 
	JG_JGZZFAAD_XMLP_PKG.cf_page_parent_acct_descrformu(substr(i.cost_account, 1, :P_PRECISION * :P_PRECISION_WIDTH), substr(i.cost_account, 1, :P_PRECISION * :P_PRECISION_WIDTH)) CF_page_parent_acct_descr 
--	JG_JGZZFAAD_XMLP_PKG.cf_cost_begin_balance_reptotfo(:CS_cost_begin_balance_reptot, nvl(sum(i.cost_begin_balance), 0)) cf_cost_begin_balance_reptot, 
--	JG_JGZZFAAD_XMLP_PKG.cf_begin_balance_reptotformula(:CS_begin_bal_reptot, nvl(sum(i.begin_balance), 0)) cf_begin_balance_reptot, 
--	JG_JGZZFAAD_XMLP_PKG.cf_additions_reptotformula(:CS_additions_reptot, nvl(sum(i.additions), 0)) cf_additions_reptot, 
--	JG_JGZZFAAD_XMLP_PKG.cf_adjustments_reptotformula(:CS_adjustments_reptot, nvl(sum(i.adjustments), 0)) cf_adjustments_reptot, 
--	JG_JGZZFAAD_XMLP_PKG.cf_reclases_reptotformula(:CS_reclasses_reptot, nvl(sum(i.reclasses), 0)) cf_reclasses_reptot, 
--	JG_JGZZFAAD_XMLP_PKG.cf_retirements_reptotformula(:CS_retirements_reptot, nvl(sum(i.retirements), 0) * -1) cf_retirements_reptot, 
--	JG_JGZZFAAD_XMLP_PKG.cf_revaluations_reptotformula(:CS_revaluations_reptot, nvl(sum(i.revaluations), 0)) cf_revaluations_reptot, 
--	JG_JGZZFAAD_XMLP_PKG.cf_end_balance_reptotformula(:CS_end_balance_reptot, nvl(sum(i.end_balance), 0)) cf_end_balance_reptot
from
	fa_balances_rep_itf i
where
   	i.request_id = :P_CONC_REQUEST_ID and
	i.company = :P_BALANCING_SEGMENT
group by
	i.asset_number, 
	i.company,
	substr(i.cost_account, 1, :P_PRECISION * :P_PRECISION_WIDTH),
	substr(i.cost_account, 1, :P_PRECISION * :P_PRECISION_WIDTH),
	i.account,
	i.account_description,
	i.cost_account,
	i.date_placed_in_service, 
 	round(i.stl_depreciation_rate, 2),
	i.concat_vendor_name,
	i.concat_invoice_number,
	i.concat_location,
	i.concat_retirement_type
order by
	i.cost_account,
	i.asset_number
Parameter Name SQL text Validation
Report Type
 
LOV Oracle
Official Run
 
LOV Oracle
Book
 
LOV Oracle
Balancing Segment
 
From Period
 
LOV Oracle
To Period
 
LOV Oracle
Parent Totals
 
LOV Oracle
Precision
 
LOV Oracle
Precision Width
 
Number
Asset Information
 
LOV Oracle
COA ID
 
Number