FA Reserve Detail - draft

Description
Categories: BI Publisher
Application: Assets
Source: Reserve Detail Report (XML) - Not Supported: Reserved For Future Use
Short Name: FASRSVED_XML
DB package: FA_FASRSVED_XMLP_PKG
SELECT
	&ACCT_FLEX_BAL_SEG					COMP_CODE,
	NVL (&ACCT_FLEX_ACCT_SEG, BAL.Category_Books_Account)	ACCOUNT,
	&ACCT_FLEX_COST_SEG					COST_CTR,
	AD.Asset_Number						ASSET,	
	SUM (DECODE (BAL.Source_Type_Code, 
		'BEGIN', NVL(BAL.Amount,0), NULL)) 			BEGIN,
	SUM (DECODE (BAL.Source_Type_Code, 
		'ADDITION', NVL(BAL.Amount,0), NULL)) 			ADDITION,
	SUM (DECODE (BAL.Source_Type_Code, 
		'DEPRECIATION', NVL(BAL.Amount,0), NULL)) 		DEPRECIATION,
	SUM (DECODE (BAL.Source_Type_Code, 
		'RECLASS', NVL(BAL.Amount,0), NULL)) 			RECLASS,
	SUM (DECODE (BAL.Source_Type_Code, 
		'RETIREMENT', -NVL(BAL.Amount,0), NULL))			RETIREMENT,
	SUM (DECODE (BAL.Source_Type_Code, 
		'REVALUATION', NVL(BAL.Amount,0), NULL)) 			REVALUATION,
	SUM (DECODE (BAL.Source_Type_Code, 
		'TAX', NVL(BAL.Amount,0), NULL)) 				TAX,
	SUM (DECODE (BAL.Source_Type_Code, 
		'TRANSFER', NVL(BAL.Amount,0), NULL)) 			TRANSFER,
	SUM (DECODE (BAL.Source_Type_Code, 
		'END', NVL(BAL.Amount,0), NULL