FLA_ACCRUAL_CURR_SUMMARY_V

Details

• Schema: FUSION

• Object owner: FUN

• Object type: VIEW

Columns

Name
LEASE_ID CURRENCY_CODE PERIOD_NAME SCHEDULE_DATE IFRS_AMORTIZATION IFRS_OPENING_ROU_AMOUNT IFRS_CLOSING_ROU_AMOUNT ASC_FIN_AMORTIZATION ASC_OPENING_FIN_ROU_AMOUNT ASC_CLOSING_FIN_ROU_AMOUNT ASC_OPER_AMORTIZATION ASC_LEASE_EXPENSE ASC_OPENING_OPER_ROU_AMOUNT ASC_CLOSING_OPER_ROU_AMOUNT

Query

SQL_Statement

SELECT lease_id, currency_code, period_name, schedule_date, SUM(ifrs_amortization) ifrs_amortization, SUM(ifrs_opening_rou_amount) ifrs_opening_rou_amount, SUM(ifrs_closing_rou_amount) ifrs_closing_rou_amount, SUM(asc_fin_amortization) asc_fin_amortization, SUM(asc_opening_fin_rou_amount) asc_opening_fin_rou_amount, SUM(asc_closing_fin_rou_amount) asc_closing_fin_rou_amount, SUM(asc_oper_amortization) asc_oper_amortization, SUM(asc_lease_expense) asc_lease_expense, SUM(asc_opening_oper_rou_amount) asc_opening_oper_rou_amount, SUM(asc_closing_oper_rou_amount) asc_closing_oper_rou_amount FROM (SELECT payment_number, lease_id, lease_detail_id, version_num, amortization_start_date, amortization_end_date, active_flag, transaction_type_code, accrual_start_date, period_name, schedule_date, number_of_accrual_days, currency_code, rou_asset_flag, liability_flag, ( CASE regime_code WHEN 'IFRS16' THEN fin_amortization ELSE 0 END ) ifrs_amortization, ( CASE regime_code WHEN 'IFRS16' THEN opening_fin_rou_amount ELSE 0 END ) ifrs_opening_rou_amount, ( CASE regime_code WHEN 'IFRS16' THEN closing_fin_rou_amount ELSE 0 END ) ifrs_closing_rou_amount, ( CASE regime_code WHEN 'ASC842' THEN fin_amortization ELSE 0 END ) asc_fin_amortization, ( CASE regime_code WHEN 'ASC842' THEN opening_fin_rou_amount ELSE 0 END ) asc_opening_fin_rou_amount, ( CASE regime_code WHEN 'ASC842' THEN closing_fin_rou_amount ELSE 0 END ) asc_closing_fin_rou_amount, ( CASE regime_code WHEN 'ASC842' THEN oper_amortization ELSE 0 END ) asc_oper_amortization, ( CASE regime_code WHEN 'ASC842' THEN lease_expense ELSE 0 END ) asc_lease_expense, ( CASE regime_code WHEN 'ASC842' THEN opening_oper_rou_amount ELSE 0 END ) asc_opening_oper_rou_amount, ( CASE regime_code WHEN 'ASC842' THEN closing_oper_rou_amount ELSE 0 END ) asc_closing_oper_rou_amount FROM fla_accrual_schedules_v ) GROUP BY lease_id, period_name, schedule_date, currency_code