IGI Inflation Accounting : Backlog Detail Report- Not Supported: Reserved For Future Use
Description
- Categories
- BI Publisher
- 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
Imported from BI Publisher
Inflation Accounting : Backlog Detail Report
Inflation Accounting : Backlog Detail Report
SQL 49 lines
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 |
Parameters 9
| Parameter | Type | List of values SQL |
|---|---|---|
| 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 |