IGI Inflation Accounting : Revaluation Reserve Detail Report- Not Supported: Reserved For Future Use

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Inflation Accounting : Revaluation Reserve Detail Report
Application: Public Sector Financials International
Source: Inflation Accounting : Revaluation Reserve Detail Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGIIARRD_XML
DB package: IGI_IGIIARRD_XMLP_PKG
Run IGI Inflation Accounting : Revaluation Reserve Detail Report- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT 
	BAL.COMPANY	COMP_CODE,	
	BAL.ACCOUNT	ACCOUNT,
	BAL.COST_CENTER	COST_CTR,
	FAD.ASSET_NUMBER     ASSET_NUMBER,
 	BAL.DATA_SOURCE       BALANCE_TYPE,
	BAL.DISPLAY_ORDER    DISPLAY_ORDER,
	NVL(SUM (DECODE (BAL.Source_Type_Code, 
		'BEGIN', NVL(BAL.Amount,0), NULL)), 0)		BEGINNING,
	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, 
		'ADJUSTMENT',NVL(BAL.Amount,0), NULL)) 	ADJUSTMENT,
	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),
                                     'DEPRECIATION',NVL(BAL.Amount,0), NULL)) 	REVALUATION,
	SUM(DECODE(BAL.Source_Type_Code, 
		'TRANSFER', NVL(BAL.Amount,0), NULL)) 		TRANSFER,
	NVL(SUM (DECODE (BAL.Source_Type_Code, 
		'END', NVL(BAL.Amount,0), NULL)), 0)		ENDING, 
	IGI_IGIIARRD_XMLP_PKG.cost_beginningformula(BAL.DATA_SOURCE, NVL ( SUM ( DECODE ( BAL.Source_Type_Code , 'BEGIN' , NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 )) COST_BEGINNING, 
	IGI_IGIIARRD_XMLP_PKG.cost_additionformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'ADDITION' , NVL ( BAL.Amount , 0 ) , NULL ) )) COST_ADDITION, 
	IGI_IGIIARRD_XMLP_PKG.cost_depreciationformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'DEPRECIATION' , NVL ( BAL.Amount , 0 ) , NULL ) )) COST_DEPRECIATION, 
	IGI_IGIIARRD_XMLP_PKG.cost_adjustmentformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'ADJUSTMENT' , NVL ( BAL.Amount , 0 ) , NULL ) )) COST_ADJUSTMENT, 
	IGI_IGIIARRD_XMLP_PKG.cost_retirementformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'RETIREMENT' , - NVL ( BAL.Amount , 0 ) , NULL ) )) COST_RETIREMENT, 
	IGI_IGIIARRD_XMLP_PKG.cost_revaluationformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'REVALUATION' , NVL ( BAL.Amount , 0 ) , 'DEPRECIATION' , NVL ( BAL.Amount , 0 ) , NULL ) )) COST_REVALUATION, 
	IGI_IGIIARRD_XMLP_PKG.cost_reclassformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'RECLASS' , NVL ( BAL.Amount , 0 ) , NULL ) )) COST_RECLASS, 
	IGI_IGIIARRD_XMLP_PKG.cost_transferformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'TRANSFER' , NVL ( BAL.Amount , 0 ) , NULL ) )) COST_TRANSFER, 
	IGI_IGIIARRD_XMLP_PKG.cost_endingformula(BAL.DATA_SOURCE, NVL ( SUM ( DECODE ( BAL.Source_Type_Code , 'END' , NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 )) COST_ENDING, 
	IGI_IGIIARRD_XMLP_PKG.gfund_beginningformula(BAL.DATA_SOURCE, NVL ( SUM ( DECODE ( BAL.Source_Type_Code , 'BEGIN' , NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 )) GFUND_BEGINNING, 
	IGI_IGIIARRD_XMLP_PKG.gfund_additionformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'ADDITION' , NVL ( BAL.Amount , 0 ) , NULL ) )) GFUND_ADDITION, 
	IGI_IGIIARRD_XMLP_PKG.gfund_depreciationformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'DEPRECIATION' , NVL ( BAL.Amount , 0 ) , NULL ) )) GFUND_DEPRECIATION, 
	IGI_IGIIARRD_XMLP_PKG.gfund_adjustmentformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'ADJUSTMENT' , NVL ( BAL.Amount , 0 ) , NULL ) )) GFUND_ADJUSTMENT, 
	IGI_IGIIARRD_XMLP_PKG.gfund_retirementformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'RETIREMENT' , - NVL ( BAL.Amount , 0 ) , NULL ) )) GFUND_RETIREMENT, 
	IGI_IGIIARRD_XMLP_PKG.gfund_revaluationformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'REVALUATION' , NVL ( BAL.Amount , 0 ) , 'DEPRECIATION' , NVL ( BAL.Amount , 0 ) , NULL ) )) GFUND_REVALUATION, 
	IGI_IGIIARRD_XMLP_PKG.gfund_reclassformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'RECLASS' , NVL ( BAL.Amount , 0 ) , NULL ) )) GFUND_RECLASS, 
	IGI_IGIIARRD_XMLP_PKG.gfund_transferformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'TRANSFER' , NVL ( BAL.Amount , 0 ) , NULL ) )) GFUND_TRANSFER, 
	IGI_IGIIARRD_XMLP_PKG.gfund_endingformula(BAL.DATA_SOURCE, NVL ( SUM ( DECODE ( BAL.Source_Type_Code , 'END' , NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 )) GFUND_ENDING, 
	IGI_IGIIARRD_XMLP_PKG.blog_beginningformula(BAL.DATA_SOURCE, NVL ( SUM ( DECODE ( BAL.Source_Type_Code , 'BEGIN' , NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 )) BLOG_BEGINNING, 
	IGI_IGIIARRD_XMLP_PKG.blog_additionformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'ADDITION' , NVL ( BAL.Amount , 0 ) , NULL ) )) BLOG_ADDITION, 
	IGI_IGIIARRD_XMLP_PKG.blog_depreciationformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'DEPRECIATION' , NVL ( BAL.Amount , 0 ) , NULL ) )) BLOG_DEPRECIATION, 
	IGI_IGIIARRD_XMLP_PKG.blog_adjustmentformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'ADJUSTMENT' , NVL ( BAL.Amount , 0 ) , NULL ) )) BLOG_ADJUSTMENT, 
	IGI_IGIIARRD_XMLP_PKG.blog_retirementformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'RETIREMENT' , - NVL ( BAL.Amount , 0 ) , NULL ) )) BLOG_RETIREMENT, 
	IGI_IGIIARRD_XMLP_PKG.blog_revaluationformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'REVALUATION' , NVL ( BAL.Amount , 0 ) , 'DEPRECIATION' , NVL ( BAL.Amount , 0 ) , NULL ) )) BLOG_REVALUATION, 
	IGI_IGIIARRD_XMLP_PKG.blog_reclassformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'RECLASS' , NVL ( BAL.Amount , 0 ) , NULL ) )) BLOG_RECLASS, 
	IGI_IGIIARRD_XMLP_PKG.blog_transferformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'TRANSFER' , NVL ( BAL.Amount , 0 ) , NULL ) )) BLOG_TRANSFER, 
	IGI_IGIIARRD_XMLP_PKG.blog_endingformula(BAL.DATA_SOURCE, NVL ( SUM ( DECODE ( BAL.Source_Type_Code , 'END' , NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 )) BLOG_ENDING, 
	IGI_IGIIARRD_XMLP_PKG.net_beginningformula(BAL.DATA_SOURCE, NVL ( SUM ( DECODE ( BAL.Source_Type_Code , 'BEGIN' , NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 )) NET_BEGINNING, 
	IGI_IGIIARRD_XMLP_PKG.net_additionformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'ADDITION' , NVL ( BAL.Amount , 0 ) , NULL ) )) NET_ADDITION, 
	IGI_IGIIARRD_XMLP_PKG.net_depreciationformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'DEPRECIATION' , NVL ( BAL.Amount , 0 ) , NULL ) )) NET_DEPRECIATION, 
	IGI_IGIIARRD_XMLP_PKG.net_adjustmentformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'ADJUSTMENT' , NVL ( BAL.Amount , 0 ) , NULL ) )) NET_ADJUSTMENT, 
	IGI_IGIIARRD_XMLP_PKG.net_retirementformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'RETIREMENT' , - NVL ( BAL.Amount , 0 ) , NULL ) )) NET_RETIREMENT, 
	IGI_IGIIARRD_XMLP_PKG.net_revaluationformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'REVALUATION' , NVL ( BAL.Amount , 0 ) , 'DEPRECIATION' , NVL ( BAL.Amount , 0 ) , NULL ) )) NET_REVALUATION, 
	IGI_IGIIARRD_XMLP_PKG.net_reclassformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'RECLASS' , NVL ( BAL.Amount , 0 ) , NULL ) )) NET_RECLASS, 
	IGI_IGIIARRD_XMLP_PKG.net_transferformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'TRANSFER' , NVL ( BAL.Amount , 0 ) , NULL ) )) NET_TRANSFER, 
	IGI_IGIIARRD_XMLP_PKG.net_endingformula(BAL.DATA_SOURCE, NVL ( SUM ( DECODE ( BAL.Source_Type_Code , 'END' , NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 )) NET_ENDING
FROM   
	IGI_IAC_BALANCES_REPORT BAL,
	FA_ADDITIONS FAD
WHERE   
	:DO_INSERT = 1
	AND	BAL.ASSET_ID = FAD.ASSET_ID
	AND     	BAL.COMPANY BETWEEN 
			NVL(:P_COMPANY1,  BAL.COMPANY)  AND
			NVL(:P_COMPANY2,  BAL.COMPANY) 
	AND     	BAL.COST_CENTER BETWEEN 
			NVL(:P_COST_CENTER1,  BAL.COST_CENTER)  AND
			NVL(:P_COST_CENTER2,  BAL.COST_CENTER) 
	AND     	BAL.ACCOUNT BETWEEN 
			NVL(:P_ACCOUNT1,  BAL.ACCOUNT)  AND
			NVL(:P_ACCOUNT2,  BAL.ACCOUNT)
GROUP BY
	BAL.COMPANY,
	BAL.ACCOUNT,
	BAL.COST_CENTER,
	FAD.ASSET_NUMBER,
	BAL.DATA_SOURCE,
	BAL.DISPLAY_ORDER
ORDER BY 1,2,3,4,6
Parameter Name SQL text Validation
Book
 
LOV Oracle
Period From
 
LOV Oracle
Period To
 
LOV Oracle
Company From
 
Char
Company To
 
Char
Cost Center From
 
Char
Cost Center To
 
Char
Account From
 
Char
Account To
 
Char
Download
Blitz Report™

Blitz Report™ provides multiple benefits:

Blitz Report™