FA Calculation of Capital Adjustment / General Fund Account Balances for UK Local Authority Accounting Implementation
Description
Categories: BI Publisher
Application: Assets
Source: Calculation of Capital Adjustment / General Fund Account Balances for UK Local Authority Accounting Implementation
Short Name: FASRPCGC
DB package: FA_SORP_UPG_PKG
Source: Calculation of Capital Adjustment / General Fund Account Balances for UK Local Authority Accounting Implementation
Short Name: FASRPCGC
DB package: FA_SORP_UPG_PKG
Run
FA Calculation of Capital Adjustment / General Fund Account Balances for UK Local Authority Accounting Implementation and other Oracle EBS reports with Blitz Report™ on our demo environment
select category_name, sum(current_cost) current_cost, sum(depriciation_reserve)depriciation_reserve, sum(revaluation_reserve) revaluation_reserve, sum(impairment_reserve) accumulated_impairment, sum(capital_adjustment_acct_amount)capital_adjustment_acct_amount, sum(general_fund_acct_amount) general_fund_acct_amount from &p_from &p_where group by category_name |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Asset Book |
|
LOV Oracle | |
Summary Mode |
|
LOV Oracle | |
Report Mode |
|
LOV Oracle |