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
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 |
