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

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Inflation Accounting : Backlog Detail Report
Application: Public Sector Financials International
Source: Inflation Accounting : Backlog Detail Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGIIABLD_XML
DB package: IGI_IGIIABLD_XMLP_PKG
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,
               0            ADDITION,
               NVL(SUM(DECODE(BAL.Source_Type_Code,  
	                         'DEPRECIATION', NVL(BAL.Amount,0),
                                         'ADDITION', NVL(BAL.Amount,0), NULL)), 0)    DEPRECIATION,
              NVL(SUM(DECODE(BAL.Source_Type_Code, 
	                         'ADJUSTMENT',NVL(BAL.Amount,0), NULL)), 0)      ADJUSTMENT,
              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, 
		           'TRANSFER', NVL(BAL.Amount,0), NULL)), 0)      TRANSFER,
              NVL(SUM (DECODE (BAL.Source_Type_Code, 
		 	'END', NVL(BAL.Amount,0), NULL)), 0)	ENDING
--	&D_COMP_CODE d_comp_code, 
--	&D_ACCOUNT d_account, 
--	&D_COST_CTR d_cost_ctr
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,5
Parameter NameSQL textValidation
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 : Operating Expense 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 GL Account Distribution Analysis
Blitz Report™