IGI Inflation Accounting : Backlog Summary Report- Not Supported: Reserved For Future Use
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Inflation Accounting : Backlog Summary Report
Application: Public Sector Financials International
Source: Inflation Accounting : Backlog Summary Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGIIABLS_XML
DB package: IGI_IGIIABLS_XMLP_PKG
Description: Inflation Accounting : Backlog Summary Report
Application: Public Sector Financials International
Source: Inflation Accounting : Backlog Summary Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGIIABLS_XML
DB package: IGI_IGIIABLS_XMLP_PKG
SELECT BAL.COMPANY COMP_CODE, BAL.ACCOUNT ACCOUNT, BAL.COST_CENTER COST_CTR, 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 WHERE :DO_INSERT = 1 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, BAL.DATA_SOURCE, BAL.DISPLAY_ORDER ORDER BY 1,2,3,5 |
| 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 |