GL_DAILY_BALANCES_V

Details

• Schema: FUSION

• Object owner: GL

• Object type: VIEW

Columns

Name
LEDGER_ID LEDGER_NAME LEDGER_CURRENCY ACCOUNTING_DATE PERIOD_NAME PERIOD_TYPE PERIOD_SET_NAME CODE_COMBINATION_ID CURRENCY_CODE CURRENCY_TYPE ACTUAL_FLAG CONVERTED_FROM_CURRENCY PERIOD_YEAR PERIOD_NUM TEMPLATE_ID END_OF_DATE_BALANCE_NUM PERIOD_AGGREGATE_NUM PERIOD_AVERAGE_TO_DATE_NUM QUARTER_AGGREGATE_NUM QUARTER_AVERAGE_TO_DATE_NUM YEAR_AGGREGATE_NUM YEAR_AVERAGE_TO_DATE_NUM

Query

SQL_Statement

SELECT DB.ledger_id LEDGER_ID, LR.target_ledger_name LEDGER_NAME, LR.target_currency_code LEDGER_CURRENCY, DPM.accounting_date ACCOUNTING_DATE, DPM.period_name PERIOD_NAME, DPM.period_type PERIOD_TYPE, DPM.period_set_name PERIOD_SET_NAME, DB.code_combination_id CODE_COMBINATION_ID, DB.currency_code CURRENCY_CODE, DB.currency_type CURRENCY_TYPE, DB.actual_flag ACTUAL_FLAG, DB.converted_from_currency CONVERTED_FROM_CURRENCY, DB.period_year PERIOD_YEAR, DB.period_num PERIOD_NUM, DB.template_id TEMPLATE_ID, round ( (decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 1, decode(DB.currency_type, 'O', DB.end_of_day1, 'T', DB.end_of_day1, DB.period_aggregate1), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 2, decode(DB.currency_type, 'O', DB.end_of_day2, 'T', DB.end_of_day2, DB.period_aggregate2 - DB.period_aggregate1), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 3, decode(DB.currency_type, 'O', DB.end_of_day3, 'T', DB.end_of_day3, DB.period_aggregate3 - DB.period_aggregate2), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 4, decode(DB.currency_type, 'O', DB.end_of_day4, 'T', DB.end_of_day4, DB.period_aggregate4 - DB.period_aggregate3), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 5, decode(DB.currency_type, 'O', DB.end_of_day5, 'T', DB.end_of_day5, DB.period_aggregate5 - DB.period_aggregate4), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 6, decode(DB.currency_type, 'O', DB.end_of_day6, 'T', DB.end_of_day6, DB.period_aggregate6 - DB.period_aggregate5), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 7, decode(DB.currency_type, 'O', DB.end_of_day7, 'T', DB.end_of_day7, DB.period_aggregate7 - DB.period_aggregate6), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 8, decode(DB.currency_type, 'O', DB.end_of_day8, 'T', DB.end_of_day8, DB.period_aggregate8 - DB.period_aggregate7), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 9, decode(DB.currency_type, 'O', DB.end_of_day9, 'T', DB.end_of_day9, DB.period_aggregate9 - DB.period_aggregate8), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 10, decode(DB.currency_type, 'O',DB.end_of_day10, 'T',DB.end_of_day10, DB.period_aggregate10 - DB.period_aggregate9), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 11, decode(DB.currency_type, 'O',DB.end_of_day11, 'T',DB.end_of_day11, DB.period_aggregate11 - DB.period_aggregate10), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 12, decode(DB.currency_type, 'O',DB.end_of_day12, 'T',DB.end_of_day12, DB.period_aggregate12 - DB.period_aggregate11), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 13, decode(DB.currency_type, 'O',DB.end_of_day13, 'T',DB.end_of_day13, DB.period_aggregate13 - DB.period_aggregate12), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 14, decode(DB.currency_type, 'O',DB.end_of_day14, 'T',DB.end_of_day14, DB.period_aggregate14 - DB.period_aggregate13), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 15, decode(DB.currency_type, 'O',DB.end_of_day15, 'T',DB.end_of_day15, DB.period_aggregate15 - DB.period_aggregate14), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 16, decode(DB.currency_type, 'O',DB.end_of_day16, 'T',DB.end_of_day16, DB.period_aggregate16 - DB.period_aggregate15), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 17, decode(DB.currency_type, 'O',DB.end_of_day17, 'T',DB.end_of_day17, DB.period_aggregate17 - DB.period_aggregate16), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 18, decode(DB.currency_type, 'O',DB.end_of_day18, 'T',DB.end_of_day18, DB.period_aggregate18 - DB.period_aggregate17), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 19, decode(DB.currency_type, 'O',DB.end_of_day19, 'T',DB.end_of_day19, DB.period_aggregate19 - DB.period_aggregate18), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 20, decode(DB.currency_type, 'O',DB.end_of_day20, 'T',DB.end_of_day20, DB.period_aggregate20 - DB.period_aggregate19), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 21, decode(DB.currency_type, 'O',DB.end_of_day21, 'T',DB.end_of_day21, DB.period_aggregate21 - DB.period_aggregate20), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 22, decode(DB.currency_type, 'O',DB.end_of_day22, 'T',DB.end_of_day22, DB.period_aggregate22 - DB.period_aggregate21), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 23, decode(DB.currency_type, 'O',DB.end_of_day23, 'T',DB.end_of_day23, DB.period_aggregate23 - DB.period_aggregate22), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 24, decode(DB.currency_type, 'O',DB.end_of_day24, 'T',DB.end_of_day24, DB.period_aggregate24 - DB.period_aggregate23), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 25, decode(DB.currency_type, 'O',DB.end_of_day25, 'T',DB.end_of_day25, DB.period_aggregate25 - DB.period_aggregate24), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 26, decode(DB.currency_type, 'O',DB.end_of_day26, 'T',DB.end_of_day26, DB.period_aggregate26 - DB.period_aggregate25), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 27, decode(DB.currency_type, 'O',DB.end_of_day27, 'T',DB.end_of_day27, DB.period_aggregate27 - DB.period_aggregate26), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 28, decode(DB.currency_type, 'O',DB.end_of_day28, 'T',DB.end_of_day28, DB.period_aggregate28 - DB.period_aggregate27), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 29, decode(DB.currency_type, 'O',DB.end_of_day29, 'T',DB.end_of_day29, DB.period_aggregate29 - DB.period_aggregate28), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 30, decode(DB.currency_type, 'O',DB.end_of_day30, 'T',DB.end_of_day30, DB.period_aggregate30 - DB.period_aggregate29), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 31, decode(DB.currency_type, 'O',DB.end_of_day31, 'T',DB.end_of_day31, DB.period_aggregate31 - DB.period_aggregate30), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 32, decode(DB.currency_type, 'O',DB.end_of_day32, 'T',DB.end_of_day32, DB.period_aggregate32 - DB.period_aggregate31), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 33, decode(DB.currency_type, 'O',DB.end_of_day33, 'T',DB.end_of_day33, DB.period_aggregate33 - DB.period_aggregate32), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 34, decode(DB.currency_type, 'O',DB.end_of_day34, 'T',DB.end_of_day34, DB.period_aggregate34 - DB.period_aggregate33), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 35, decode(DB.currency_type, 'O',DB.end_of_day35, 'T',DB.end_of_day35, DB.period_aggregate35 - DB.period_aggregate34), 0)) / nvl (FC.minimum_accountable_unit, power(10, -FC.precision))) * nvl (FC.minimum_accountable_unit, power(10, -FC.precision)) END_OF_DATE_BALANCE_NUM, round( (decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 1, DB.period_aggregate1, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 2, DB.period_aggregate2, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 3, DB.period_aggregate3, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 4, DB.period_aggregate4, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 5, DB.period_aggregate5, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 6, DB.period_aggregate6, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 7, DB.period_aggregate7, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 8, DB.period_aggregate8, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 9, DB.period_aggregate9, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 10, DB.period_aggregate10, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 11, DB.period_aggregate11, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 12, DB.period_aggregate12, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 13, DB.period_aggregate13, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 14, DB.period_aggregate14, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 15, DB.period_aggregate15, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 16, DB.period_aggregate16, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 17, DB.period_aggregate17, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 18, DB.period_aggregate18, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 19, DB.period_aggregate19, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 20, DB.period_aggregate20, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 21, DB.period_aggregate21, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 22, DB.period_aggregate22, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 23, DB.period_aggregate23, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 24, DB.period_aggregate24, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 25, DB.period_aggregate25, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 26, DB.period_aggregate26, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 27, DB.period_aggregate27, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 28, DB.period_aggregate28, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 29, DB.period_aggregate29, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 30, DB.period_aggregate30, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 31, DB.period_aggregate31, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 32, DB.period_aggregate32, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 33, DB.period_aggregate33, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 34, DB.period_aggregate34, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 35, DB.period_aggregate35, 0)) / nvl (FC.minimum_accountable_unit, power (10, -FC.precision))) * nvl (FC.minimum_accountable_unit, power (10, -FC.precision)) PERIOD_AGGREGATE_NUM, round ( (decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 1, DB.period_aggregate1, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 2, DB.period_aggregate2, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 3, DB.period_aggregate3, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 4, DB.period_aggregate4, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 5, DB.period_aggregate5, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 6, DB.period_aggregate6, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 7, DB.period_aggregate7, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 8, DB.period_aggregate8, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 9, DB.period_aggregate9, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 10, DB.period_aggregate10, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 11, DB.period_aggregate11, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 12, DB.period_aggregate12, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 13, DB.period_aggregate13, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 14, DB.period_aggregate14, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 15, DB.period_aggregate15, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 16, DB.period_aggregate16, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 17, DB.period_aggregate17, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 18, DB.period_aggregate18, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 19, DB.period_aggregate19, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 20, DB.period_aggregate20, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 21, DB.period_aggregate21, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 22, DB.period_aggregate22, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 23, DB.period_aggregate23, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 24, DB.period_aggregate24, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 25, DB.period_aggregate25, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 26, DB.period_aggregate26, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 27, DB.period_aggregate27, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 28, DB.period_aggregate28, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 29, DB.period_aggregate29, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 30, DB.period_aggregate30, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 31, DB.period_aggregate31, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 32, DB.period_aggregate32, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 33, DB.period_aggregate33, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 34, DB.period_aggregate34, 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 35, DB.period_aggregate35, 0)) / ( DPM.accounting_date - DB.period_start_date + 1 ) / nvl (FC.minimum_accountable_unit, power (10, -FC.precision))) * nvl (FC.minimum_accountable_unit, power (10, -FC.precision)) PERIOD_AVERAGE_TO_DATE_NUM, round ( (decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 1, nvl(DB.quarter_aggregate1, opening_quarter_aggregate + DB.period_aggregate1), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 2, nvl(DB.quarter_aggregate2, opening_quarter_aggregate + DB.period_aggregate2), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 3, nvl(DB.quarter_aggregate3, opening_quarter_aggregate + DB.period_aggregate3), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 4, nvl(DB.quarter_aggregate4, opening_quarter_aggregate + DB.period_aggregate4), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 5, nvl(DB.quarter_aggregate5, opening_quarter_aggregate + DB.period_aggregate5), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 6, nvl(DB.quarter_aggregate6, opening_quarter_aggregate + DB.period_aggregate6), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 7, nvl(DB.quarter_aggregate7, opening_quarter_aggregate + DB.period_aggregate7), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 8, nvl(DB.quarter_aggregate8, opening_quarter_aggregate + DB.period_aggregate8), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 9, nvl(DB.quarter_aggregate9, opening_quarter_aggregate + DB.period_aggregate9), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 10, nvl(DB.quarter_aggregate10, opening_quarter_aggregate + DB.period_aggregate10), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 11, nvl(DB.quarter_aggregate11, opening_quarter_aggregate + DB.period_aggregate11), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 12, nvl(DB.quarter_aggregate12, opening_quarter_aggregate + DB.period_aggregate12), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 13, nvl(DB.quarter_aggregate13, opening_quarter_aggregate + DB.period_aggregate13), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 14, nvl(DB.quarter_aggregate14, opening_quarter_aggregate + DB.period_aggregate14), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 15, nvl(DB.quarter_aggregate15, opening_quarter_aggregate + DB.period_aggregate15), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 16, nvl(DB.quarter_aggregate16, opening_quarter_aggregate + DB.period_aggregate16), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 17, nvl(DB.quarter_aggregate17, opening_quarter_aggregate + DB.period_aggregate17), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 18, nvl(DB.quarter_aggregate18, opening_quarter_aggregate + DB.period_aggregate18), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 19, nvl(DB.quarter_aggregate19, opening_quarter_aggregate + DB.period_aggregate19), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 20, nvl(DB.quarter_aggregate20, opening_quarter_aggregate + DB.period_aggregate20), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 21, nvl(DB.quarter_aggregate21, opening_quarter_aggregate + DB.period_aggregate21), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 22, nvl(DB.quarter_aggregate22, opening_quarter_aggregate + DB.period_aggregate22), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 23, nvl(DB.quarter_aggregate23, opening_quarter_aggregate + DB.period_aggregate23), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 24, nvl(DB.quarter_aggregate24, opening_quarter_aggregate + DB.period_aggregate24), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 25, nvl(DB.quarter_aggregate25, opening_quarter_aggregate + DB.period_aggregate25), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 26, nvl(DB.quarter_aggregate26, opening_quarter_aggregate + DB.period_aggregate26), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 27, nvl(DB.quarter_aggregate27, opening_quarter_aggregate + DB.period_aggregate27), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 28, nvl(DB.quarter_aggregate28, opening_quarter_aggregate + DB.period_aggregate28), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 29, nvl(DB.quarter_aggregate29, opening_quarter_aggregate + DB.period_aggregate29), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 30, nvl(DB.quarter_aggregate30, opening_quarter_aggregate + DB.period_aggregate30), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 31, nvl(DB.quarter_aggregate31, opening_quarter_aggregate + DB.period_aggregate31), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 32, nvl(DB.quarter_aggregate32, opening_quarter_aggregate + DB.period_aggregate32), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 33, nvl(DB.quarter_aggregate33, opening_quarter_aggregate + DB.period_aggregate33), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 34, nvl(DB.quarter_aggregate34, opening_quarter_aggregate + DB.period_aggregate34), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 35, nvl(DB.quarter_aggregate35, opening_quarter_aggregate + DB.period_aggregate35), 0)) / nvl (FC.minimum_accountable_unit, power (10, -FC.precision))) * nvl (FC.minimum_accountable_unit, power (10, -FC.precision)) QUARTER_AGGREGATE_NUM, round ( (decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 1, nvl(DB.quarter_aggregate1, opening_quarter_aggregate + DB.period_aggregate1), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 2, nvl(DB.quarter_aggregate2, opening_quarter_aggregate + DB.period_aggregate2), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 3, nvl(DB.quarter_aggregate3, opening_quarter_aggregate + DB.period_aggregate3), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 4, nvl(DB.quarter_aggregate4, opening_quarter_aggregate + DB.period_aggregate4), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 5, nvl(DB.quarter_aggregate5, opening_quarter_aggregate + DB.period_aggregate5), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 6, nvl(DB.quarter_aggregate6, opening_quarter_aggregate + DB.period_aggregate6), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 7, nvl(DB.quarter_aggregate7, opening_quarter_aggregate + DB.period_aggregate7), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 8, nvl(DB.quarter_aggregate8, opening_quarter_aggregate + DB.period_aggregate8), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 9, nvl(DB.quarter_aggregate9, opening_quarter_aggregate + DB.period_aggregate9), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 10, nvl(DB.quarter_aggregate10, opening_quarter_aggregate + DB.period_aggregate10), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 11, nvl(DB.quarter_aggregate11, opening_quarter_aggregate + DB.period_aggregate11), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 12, nvl(DB.quarter_aggregate12, opening_quarter_aggregate + DB.period_aggregate12), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 13, nvl(DB.quarter_aggregate13, opening_quarter_aggregate + DB.period_aggregate13), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 14, nvl(DB.quarter_aggregate14, opening_quarter_aggregate + DB.period_aggregate14), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 15, nvl(DB.quarter_aggregate15, opening_quarter_aggregate + DB.period_aggregate15), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 16, nvl(DB.quarter_aggregate16, opening_quarter_aggregate + DB.period_aggregate16), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 17, nvl(DB.quarter_aggregate17, opening_quarter_aggregate + DB.period_aggregate17), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 18, nvl(DB.quarter_aggregate18, opening_quarter_aggregate + DB.period_aggregate18), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 19, nvl(DB.quarter_aggregate19, opening_quarter_aggregate + DB.period_aggregate19), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 20, nvl(DB.quarter_aggregate20, opening_quarter_aggregate + DB.period_aggregate20), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 21, nvl(DB.quarter_aggregate21, opening_quarter_aggregate + DB.period_aggregate21), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 22, nvl(DB.quarter_aggregate22, opening_quarter_aggregate + DB.period_aggregate22), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 23, nvl(DB.quarter_aggregate23, opening_quarter_aggregate + DB.period_aggregate23), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 24, nvl(DB.quarter_aggregate24, opening_quarter_aggregate + DB.period_aggregate24), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 25, nvl(DB.quarter_aggregate25, opening_quarter_aggregate + DB.period_aggregate25), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 26, nvl(DB.quarter_aggregate26, opening_quarter_aggregate + DB.period_aggregate26), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 27, nvl(DB.quarter_aggregate27, opening_quarter_aggregate + DB.period_aggregate27), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 28, nvl(DB.quarter_aggregate28, opening_quarter_aggregate + DB.period_aggregate28), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 29, nvl(DB.quarter_aggregate29, opening_quarter_aggregate + DB.period_aggregate29), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 30, nvl(DB.quarter_aggregate30, opening_quarter_aggregate + DB.period_aggregate30), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 31, nvl(DB.quarter_aggregate31, opening_quarter_aggregate + DB.period_aggregate31), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 32, nvl(DB.quarter_aggregate32, opening_quarter_aggregate + DB.period_aggregate32), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 33, nvl(DB.quarter_aggregate33, opening_quarter_aggregate + DB.period_aggregate33), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 34, nvl(DB.quarter_aggregate34, opening_quarter_aggregate + DB.period_aggregate34), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 35, nvl(DB.quarter_aggregate35, opening_quarter_aggregate + DB.period_aggregate35), 0)) / ( DPM.accounting_date - DB.quarter_start_date + 1 ) / nvl (FC.minimum_accountable_unit, power (10, -FC.precision))) * nvl (FC.minimum_accountable_unit, power (10, -FC.precision)) QUARTER_AVERAGE_TO_DATE_NUM, round( (decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 1, nvl(DB.year_aggregate1, opening_year_aggregate + DB.period_aggregate1), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 2, nvl(DB.year_aggregate2, opening_year_aggregate + DB.period_aggregate2), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 3, nvl(DB.year_aggregate3, opening_year_aggregate + DB.period_aggregate3), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 4, nvl(DB.year_aggregate4, opening_year_aggregate + DB.period_aggregate4), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 5, nvl(DB.year_aggregate5, opening_year_aggregate + DB.period_aggregate5), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 6, nvl(DB.year_aggregate6, opening_year_aggregate + DB.period_aggregate6), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 7, nvl(DB.year_aggregate7, opening_year_aggregate + DB.period_aggregate7), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 8, nvl(DB.year_aggregate8, opening_year_aggregate + DB.period_aggregate8), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 9, nvl(DB.year_aggregate9, opening_year_aggregate + DB.period_aggregate9), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 10, nvl(DB.year_aggregate10, opening_year_aggregate + DB.period_aggregate10), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 11, nvl(DB.year_aggregate11, opening_year_aggregate + DB.period_aggregate11), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 12, nvl(DB.year_aggregate12, opening_year_aggregate + DB.period_aggregate12), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 13, nvl(DB.year_aggregate13, opening_year_aggregate + DB.period_aggregate13), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 14, nvl(DB.year_aggregate14, opening_year_aggregate + DB.period_aggregate14), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 15, nvl(DB.year_aggregate15, opening_year_aggregate + DB.period_aggregate15), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 16, nvl(DB.year_aggregate16, opening_year_aggregate + DB.period_aggregate16), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 17, nvl(DB.year_aggregate17, opening_year_aggregate + DB.period_aggregate17), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 18, nvl(DB.year_aggregate18, opening_year_aggregate + DB.period_aggregate18), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 19, nvl(DB.year_aggregate19, opening_year_aggregate + DB.period_aggregate19), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 20, nvl(DB.year_aggregate20, opening_year_aggregate + DB.period_aggregate20), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 21, nvl(DB.year_aggregate21, opening_year_aggregate + DB.period_aggregate21), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 22, nvl(DB.year_aggregate22, opening_year_aggregate + DB.period_aggregate22), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 23, nvl(DB.year_aggregate23, opening_year_aggregate + DB.period_aggregate23), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 24, nvl(DB.year_aggregate24, opening_year_aggregate + DB.period_aggregate24), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 25, nvl(DB.year_aggregate25, opening_year_aggregate + DB.period_aggregate25), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 26, nvl(DB.year_aggregate26, opening_year_aggregate + DB.period_aggregate26), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 27, nvl(DB.year_aggregate27, opening_year_aggregate + DB.period_aggregate27), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 28, nvl(DB.year_aggregate28, opening_year_aggregate + DB.period_aggregate28), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 29, nvl(DB.year_aggregate29, opening_year_aggregate + DB.period_aggregate29), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 30, nvl(DB.year_aggregate30, opening_year_aggregate + DB.period_aggregate30), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 31, nvl(DB.year_aggregate31, opening_year_aggregate + DB.period_aggregate31), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 32, nvl(DB.year_aggregate32, opening_year_aggregate + DB.period_aggregate32), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 33, nvl(DB.year_aggregate33, opening_year_aggregate + DB.period_aggregate33), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 34, nvl(DB.year_aggregate34, opening_year_aggregate + DB.period_aggregate34), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 35, nvl(DB.year_aggregate35, opening_year_aggregate + DB.period_aggregate35), 0)) / nvl (FC.minimum_accountable_unit, power (10, -FC.precision))) * nvl (FC.minimum_accountable_unit, power (10, -FC.precision)) YEAR_AGGREGATE_NUM, round ( (decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 1, nvl(DB.year_aggregate1, opening_year_aggregate + DB.period_aggregate1), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 2, nvl(DB.year_aggregate2, opening_year_aggregate + DB.period_aggregate2), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 3, nvl(DB.year_aggregate3, opening_year_aggregate + DB.period_aggregate3), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 4, nvl(DB.year_aggregate4, opening_year_aggregate + DB.period_aggregate4), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 5, nvl(DB.year_aggregate5, opening_year_aggregate + DB.period_aggregate5), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 6, nvl(DB.year_aggregate6, opening_year_aggregate + DB.period_aggregate6), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 7, nvl(DB.year_aggregate7, opening_year_aggregate + DB.period_aggregate7), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 8, nvl(DB.year_aggregate8, opening_year_aggregate + DB.period_aggregate8), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 9, nvl(DB.year_aggregate9, opening_year_aggregate + DB.period_aggregate9), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 10, nvl(DB.year_aggregate10, opening_year_aggregate + DB.period_aggregate10), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 11, nvl(DB.year_aggregate11, opening_year_aggregate + DB.period_aggregate11), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 12, nvl(DB.year_aggregate12, opening_year_aggregate + DB.period_aggregate12), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 13, nvl(DB.year_aggregate13, opening_year_aggregate + DB.period_aggregate13), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 14, nvl(DB.year_aggregate14, opening_year_aggregate + DB.period_aggregate14), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 15, nvl(DB.year_aggregate15, opening_year_aggregate + DB.period_aggregate15), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 16, nvl(DB.year_aggregate16, opening_year_aggregate + DB.period_aggregate16), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 17, nvl(DB.year_aggregate17, opening_year_aggregate + DB.period_aggregate17), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 18, nvl(DB.year_aggregate18, opening_year_aggregate + DB.period_aggregate18), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 19, nvl(DB.year_aggregate19, opening_year_aggregate + DB.period_aggregate19), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 20, nvl(DB.year_aggregate20, opening_year_aggregate + DB.period_aggregate20), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 21, nvl(DB.year_aggregate21, opening_year_aggregate + DB.period_aggregate21), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 22, nvl(DB.year_aggregate22, opening_year_aggregate + DB.period_aggregate22), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 23, nvl(DB.year_aggregate23, opening_year_aggregate + DB.period_aggregate23), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 24, nvl(DB.year_aggregate24, opening_year_aggregate + DB.period_aggregate24), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 25, nvl(DB.year_aggregate25, opening_year_aggregate + DB.period_aggregate25), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 26, nvl(DB.year_aggregate26, opening_year_aggregate + DB.period_aggregate26), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 27, nvl(DB.year_aggregate27, opening_year_aggregate + DB.period_aggregate27), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 28, nvl(DB.year_aggregate28, opening_year_aggregate + DB.period_aggregate28), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 29, nvl(DB.year_aggregate29, opening_year_aggregate + DB.period_aggregate29), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 30, nvl(DB.year_aggregate30, opening_year_aggregate + DB.period_aggregate30), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 31, nvl(DB.year_aggregate31, opening_year_aggregate + DB.period_aggregate31), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 32, nvl(DB.year_aggregate32, opening_year_aggregate + DB.period_aggregate32), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 33, nvl(DB.year_aggregate33, opening_year_aggregate + DB.period_aggregate33), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 34, nvl(DB.year_aggregate34, opening_year_aggregate + DB.period_aggregate34), 0) + decode(trunc(DPM.accounting_date) - trunc(DB.period_start_date) + 1, 35, nvl(DB.year_aggregate35, opening_year_aggregate + DB.period_aggregate35), 0)) / ( DPM.accounting_date - DB.year_start_date + 1 ) / nvl (FC.minimum_accountable_unit, power (10, -FC.precision))) * nvl (FC.minimum_accountable_unit, power (10, -FC.precision)) YEAR_AVERAGE_TO_DATE_NUM FROM GL_DAILY_BALANCES DB, GL_DATE_PERIOD_MAP DPM, FND_CURRENCIES FC, GL_LEDGER_RELATIONSHIPS LR WHERE DPM.period_name || '' = DB.period_name AND FC.currency_code = DB.currency_code AND LR.source_ledger_id = DB.ledger_id AND LR.target_ledger_id = DB.ledger_id AND LR.application_id = 101