JE Hungarian Accumulated Depreciation Movement Schedule - draft

Description
Categories: BI Publisher
Application: European Localizations
Source: Hungarian Accumulated Depreciation Movement Schedule (XML) - Not Supported: Reserved For Future Use
Short Name: JEHUFAMD_XML
DB package: JE_JEHUFAMD_XMLP_PKG
SELECT
	&ACCT_FLEX_BAL_SEG					COMP_CODE,
	NVL (null, BAL.Category_Books_Account)	ACCOUNT,
	LO.description						C_PROPERTY_TYPE,
	CA.description						C_CATEGORY_DESC,
	CA.category_id						C_CATEGORY_ID,
	NVL(SUM (DECODE (BAL.Source_Type_Code, 
		'BEGIN', NVL(BAL.Amount,0), NULL)),0)			BEGIN,
	NVL(SUM (DECODE (BAL.Source_Type_Code, 
		'ADDITION', NVL(BAL.Amount,0), NULL)),0)		ADDITION,
	NVL(SUM (DECODE (BAL.Source_Type_Code, 
		'DEPRECIATION', NVL(BAL.Amount,0), NULL)),0)		DEPRECIATION,
	NVL(SUM (DECODE (BAL.Source_Type_Code, 
		'RECLASS', NVL(BAL.Amount,0), NULL)),0)		RECLASS,
	NVL(SUM (DECODE (BAL.Source_Type_Code, 
		'RETIREMENT', -NVL(BAL.Amount,0), NULL)),0)		RETIREMENT,
	NVL(SUM (DECODE (BAL.Source_Type_Code, 
		'REVALUATION', NVL(BAL.Amount,0), NULL)),0)		REVALUATION,
	NVL(SUM (DECODE (BAL.Source_Type_Code, 
		'TAX', NVL(BAL.Amount,0),