FLA_LIABILITY_SCH_SUMMARY_V

Details

• Schema: FUSION

• Object owner: FUN

• Object type: VIEW

Columns

Name

SCHEDULE_HEADER_ID PAYMENT_NUMBER LEASE_ID LEASE_DETAIL_ID VERSION_NUM REGIME_CODE CURRENCY_CODE ORG_PRIMARY_REGIME_CODE ORG_SECONDARY_REGIME_CODE ROU_ASSET_FLAG LIABILITY_FLAG PERIOD_NAME SCHEDULE_DATE LIABILITY_PERIOD_START ACTIVE_FLAG LIABILITY_PERIOD_END PAYMENT_AMOUNT LIABILITY_DAYS PRESENT_VALUE OPENING_LIABILITY_AMOUNT CLOSING_LIABILITY_AMOUNT INTEREST_AMOUNT ADJUSTED_LIABILITY_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 schedule_header_id, payment_number, lease_id, lease_detail_id, version_num, regime_code, currency_code, org_primary_regime_code, org_secondary_regime_code, rou_asset_flag, liability_flag, period_name, schedule_date, MIN(liability_start_date) liability_period_start, active_flag, MAX(liability_end_date) liability_period_end, SUM (payment_item_amount) payment_amount, SUM (number_of_liability_days) liability_days, SUM (present_value_amount) present_value, 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, NULLIF (SUM (adjusted_liability_amount),0) adjusted_liability_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 schedule_header_id, payment_number, lease_id, lease_detail_id, version_num, regime_code, period_name, schedule_date, active_flag, currency_code, org_primary_regime_code, org_secondary_regime_code, rou_asset_flag, liability_flag