FLA_LIABILITY_CURR_SUMMARY_V

Details

• Schema: FUSION

• Object owner: FUN

• Object type: VIEW

Columns

Name
LEASE_ID CURRENCY_CODE PERIOD_NAME SCHEDULE_DATE PAYMENT_AMOUNT OPENING_LIABILITY_AMOUNT CLOSING_LIABILITY_AMOUNT INTEREST_AMOUNT OPENING_SHORT_TERM_LIAB_AMOUNT RECLASS_SHORT_TERM_LIAB_AMOUNT CLOSING_SHORT_TERM_LIAB_AMOUNT OPENING_LONG_TERM_LIAB_AMOUNT RECLASS_LONG_TERM_LIAB_AMOUNT CLOSING_LONG_TERM_LIAB_AMOUNT

Query

SQL_Statement

SELECT lease_id, currency_code, period_name, schedule_date, SUM(payment_item_amount) payment_amount, MIN(opening_liability_amount) KEEP(DENSE_RANK FIRST ORDER BY liability_start_date) opening_liability_amount, MIN(closing_liability_amount) KEEP(DENSE_RANK FIRST ORDER BY liability_end_date DESC) closing_liability_amount, SUM(interest_amount) interest_amount, MIN(opening_short_term_liab_amount) KEEP(DENSE_RANK FIRST ORDER BY liability_start_date) opening_short_term_liab_amount, SUM(reclass_short_term_liab_amount) reclass_short_term_liab_amount, MIN(closing_short_term_liab_amount) KEEP(DENSE_RANK FIRST ORDER BY liability_end_date DESC) closing_short_term_liab_amount, MIN(opening_long_term_liab_amount) KEEP(DENSE_RANK FIRST ORDER BY liability_start_date) opening_long_term_liab_amount, SUM(reclass_long_term_liab_amount) reclass_long_term_liab_amount, MIN(closing_long_term_liab_amount) KEEP(DENSE_RANK FIRST ORDER BY liability_end_date DESC) closing_long_term_liab_amount FROM fla_liability_schedules_v WHERE primary_regime_flag = 'Y' GROUP BY lease_id, currency_code, period_name, schedule_date