IGI Inflation Accounting : Operating Expense Detail Report- Not Supported: Reserved For Future Use

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Inflation Accounting : Operating Expense Detail Report
Application: Public Sector Financials International
Source: Inflation Accounting : Operating Expense Detail Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGIIAOPD_XML
DB package: IGI_IGIIAOPD_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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,
	SUM(DECODE(BAL.Source_Type_Code,  
		'ADDITION', NVL(BAL.Amount,0), NULL)) 		ADDITION,
	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, 
		'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, 
	IGI_IGIIAOPD_XMLP_PKG.cost_additionformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'ADDITION' , NVL ( BAL.Amount , 0 ) , NULL ) )) COST_ADDITION, 
	IGI_IGIIAOPD_XMLP_PKG.cost_adjustmentformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'ADJUSTMENT' , NVL ( BAL.Amount , 0 ) , NULL ) )) COST_ADJUSTMENT, 
	IGI_IGIIAOPD_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_IGIIAOPD_XMLP_PKG.cost_reclassformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'RECLASS' , NVL ( BAL.Amount , 0 ) , NULL ) )) COST_RECLASS, 
	IGI_IGIIAOPD_XMLP_PKG.cost_transferformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'TRANSFER' , NVL ( BAL.Amount , 0 ) , NULL ) )) COST_TRANSFER, 
	IGI_IGIIAOPD_XMLP_PKG.cost_movementformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'ADDITION' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'ADJUSTMENT' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'REVALUATION' , NVL ( BAL.Amount , 0 ) , 'DEPRECIATION' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'RECLASS' , NVL ( BAL.Amount , 0 ) , NULL ) ), :ASSET_COST_TRANSFER) COST_MOVEMENT, 
	IGI_IGIIAOPD_XMLP_PKG.blog_additionformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'ADDITION' , NVL ( BAL.Amount , 0 ) , NULL ) )) BLOG_ADDITION, 
	IGI_IGIIAOPD_XMLP_PKG.blog_adjustmentformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'ADJUSTMENT' , NVL ( BAL.Amount , 0 ) , NULL ) )) BLOG_ADJUSTMENT, 
	IGI_IGIIAOPD_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_IGIIAOPD_XMLP_PKG.blog_reclassformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'RECLASS' , NVL ( BAL.Amount , 0 ) , NULL ) )) BLOG_RECLASS, 
	IGI_IGIIAOPD_XMLP_PKG.blog_transferformula(BAL.DATA_SOURCE) BLOG_TRANSFER, 
	IGI_IGIIAOPD_XMLP_PKG.blog_movementformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'ADDITION' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'ADJUSTMENT' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'REVALUATION' , NVL ( BAL.Amount , 0 ) , 'DEPRECIATION' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'RECLASS' , NVL ( BAL.Amount , 0 ) , NULL ) )) BLOG_MOVEMENT, 
	IGI_IGIIAOPD_XMLP_PKG.net_additionformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'ADDITION' , NVL ( BAL.Amount , 0 ) , NULL ) )) NET_ADDITION, 
	IGI_IGIIAOPD_XMLP_PKG.net_adjustmentformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'ADJUSTMENT' , NVL ( BAL.Amount , 0 ) , NULL ) )) NET_ADJUSTMENT, 
	IGI_IGIIAOPD_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_IGIIAOPD_XMLP_PKG.net_reclassformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'RECLASS' , NVL ( BAL.Amount , 0 ) , NULL ) )) NET_RECLASS, 
	IGI_IGIIAOPD_XMLP_PKG.net_transferformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'TRANSFER' , NVL ( BAL.Amount , 0 ) , NULL ) )) NET_TRANSFER, 
	IGI_IGIIAOPD_XMLP_PKG.net_movementformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'ADDITION' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'ADJUSTMENT' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'REVALUATION' , NVL ( BAL.Amount , 0 ) , 'DEPRECIATION' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'RECLASS' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'TRANSFER' , NVL ( BAL.Amount , 0 ) , NULL ) )) NET_MOVEMENT
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
 
Related Blitz Reports
IGI Inflation Accounting : Cost Detail Report- Not Supported: Reserved For Future Use IGI Inflation Accounting : Backlog Detail Report- Not Supported: Reserved For Future Use IGI Inflation Accounting : Asset Revaluation Preview Detail - draft IGI Inflation Accounting : Revaluation Reserve Detail Report- Not Supported: Reserved For Future Use IGI Inflation Accounting : Asset Revaluation Preview Summary - draft IGI Inflation Accounting : Reserve Detail Report- Not Supported: Reserved For Future Use IGI Inflation Accounting : Cost Summary Report- Not Supported: Reserved For Future Use IGI Inflation Accounting : Reserve Summary Report- Not Supported: Reserved For Future Use IGI Inflation Accounting : Adjustments Report- Not Supported: Reserved For Future Use
Blitz Report™

Blitz Report™ provides multiple benefits: