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

➜ Back to Library
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
Download
Related Blitz Reports
FA Mass Revaluation Preview - draft FA Japanese Detail by Asset Type (Addition/All Assets) Report 180 Characters FA Asset Impairments FA Japanese Depreciable Assets Tax Summary FA Depreciation Summary Tax Register (Russia) FA Japanese Detail by Asset Type (Addition/All Assets) Report 132 Characters JG Statutory Asset Cost/Reserve Detail Report- Not Supported: Reserved For Future Use IGI Inflation Accounting : Asset Revaluation Preview Summary - draft IGI Inflation Accounting : Asset Revaluation Preview Detail - draft
Blitz Report™

Blitz Report™ provides multiple benefits: