VIEW: PN.PN_RENT_INCREASE_SUMMARY_ITF#

Source

View Text - Preformatted

select NAME NAME, LEASE_NUM LEASE_NUM, PAYMENT_TERM_PRORATION_RULE PAYMENT_TERM_PRORATION_RULE, ABSTRACTED_BY_USER_NAME ABSTRACTED_BY_USER_NAME, LEASE_CLASS_MEANING LEASE_CLASS_MEANING, LEASE_COMMENCEMENT_DATE LEASE_COMMENCEMENT_DATE, LEASE_TERMINATION_DATE LEASE_TERMINATION_DATE, LEASE_EXECUTION_DATE LEASE_EXECUTION_DATE, LEASE_EXTENSION_END_DATE LEASE_EXTENSION_END_DATE, LOCATION_CODE LOCATION_CODE, INDEX_NAME INDEX_NAME, IL_COMMENCEMENT_DATE IL_COMMENCEMENT_DATE, IL_TERMINATION_DATE IL_TERMINATION_DATE, INDEX_LEASE_NUMBER INDEX_LEASE_NUMBER, IL_ASSESSMENT_DATE IL_ASSESSMENT_DATE, ASSESSMENT_INTERVAL ASSESSMENT_INTERVAL, SPREAD_FREQUENCY_MEANING SPREAD_FREQUENCY_MEANING, BASIS_PERCENT_DEFAULT BASIS_PERCENT_DEFAULT, INITIAL_BASIS INITIAL_BASIS, BASE_INDEX BASE_INDEX, INDEX_FINDER_METHOD INDEX_FINDER_METHOD, INDEX_FINDER_MONTHS INDEX_FINDER_MONTHS, NEGATIVE_RENT_TYPE_MEANING NEGATIVE_RENT_TYPE_MEANING, INCREASE_ON_MEANING INCREASE_ON_MEANING, BASIS_TYPE BASIS_TYPE, REFERENCE_PERIOD_MEANING REFERENCE_PERIOD_MEANING, BASE_YEAR BASE_YEAR, ILP_ASSESSMENT_DATE ILP_ASSESSMENT_DATE, BASIS_START_DATE BASIS_START_DATE, BASIS_END_DATE BASIS_END_DATE, INDEX_FINDER_DATE INDEX_FINDER_DATE, CURRENT_BASIS CURRENT_BASIS, RELATIONSHIP_MEANING RELATIONSHIP_MEANING, INDEX_PERCENT_CHANGE INDEX_PERCENT_CHANGE, BASIS_PERCENT_CHANGE BASIS_PERCENT_CHANGE, CURRENT_INDEX_LINE_VALUE CURRENT_INDEX_LINE_VALUE, PREVIOUS_INDEX_LINE_VALUE PREVIOUS_INDEX_LINE_VALUE, UNCONSTRAINT_RENT_DUE UNCONSTRAINT_RENT_DUE, CONSTRAINT_RENT_DUE CONSTRAINT_RENT_DUE, CARRY_FORWARD_AMOUNT CARRY_FORWARD_AMOUNT, CARRY_FORWARD_PERCENT CARRY_FORWARD_PERCENT, CONSTRAINT_APPLIED_AMOUNT CONSTRAINT_APPLIED_AMOUNT, CONSTRAINT_APPLIED_PERCENT CONSTRAINT_APPLIED_PERCENT, OPEN_CARRY_FORWARD_AMOUNT OPEN_CARRY_FORWARD_AMOUNT, OPEN_CARRY_FORWARD_PERCENT OPEN_CARRY_FORWARD_PERCENT, APP_CARRY_FORWARD_AMOUNT APP_CARRY_FORWARD_AMOUNT, APP_CARRY_FORWARD_PERCENT APP_CARRY_FORWARD_PERCENT, OLD_RENT OLD_RENT, NEW_RENT NEW_RENT, CHANGE_RENT CHANGE_RENT, CONSTRAINT_PRORATION CONSTRAINT_PRORATION, INDEX_MULTIPLIER INDEX_MULTIPLIER, UNADJUSTED_INDEX_CHANGE UNADJUSTED_INDEX_CHANGE, ADJUSTED_INDEX_CHANGE_PERCENT ADJUSTED_INDEX_CHANGE_PERCENT, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID from "PN"."PN_RENT_INCREASE_SUMMARY_ITF"

View Text - HTML Formatted

SELECT NAME NAME
, LEASE_NUM LEASE_NUM
, PAYMENT_TERM_PRORATION_RULE PAYMENT_TERM_PRORATION_RULE
, ABSTRACTED_BY_USER_NAME ABSTRACTED_BY_USER_NAME
, LEASE_CLASS_MEANING LEASE_CLASS_MEANING
, LEASE_COMMENCEMENT_DATE LEASE_COMMENCEMENT_DATE
, LEASE_TERMINATION_DATE LEASE_TERMINATION_DATE
, LEASE_EXECUTION_DATE LEASE_EXECUTION_DATE
, LEASE_EXTENSION_END_DATE LEASE_EXTENSION_END_DATE
, LOCATION_CODE LOCATION_CODE
, INDEX_NAME INDEX_NAME
, IL_COMMENCEMENT_DATE IL_COMMENCEMENT_DATE
, IL_TERMINATION_DATE IL_TERMINATION_DATE
, INDEX_LEASE_NUMBER INDEX_LEASE_NUMBER
, IL_ASSESSMENT_DATE IL_ASSESSMENT_DATE
, ASSESSMENT_INTERVAL ASSESSMENT_INTERVAL
, SPREAD_FREQUENCY_MEANING SPREAD_FREQUENCY_MEANING
, BASIS_PERCENT_DEFAULT BASIS_PERCENT_DEFAULT
, INITIAL_BASIS INITIAL_BASIS
, BASE_INDEX BASE_INDEX
, INDEX_FINDER_METHOD INDEX_FINDER_METHOD
, INDEX_FINDER_MONTHS INDEX_FINDER_MONTHS
, NEGATIVE_RENT_TYPE_MEANING NEGATIVE_RENT_TYPE_MEANING
, INCREASE_ON_MEANING INCREASE_ON_MEANING
, BASIS_TYPE BASIS_TYPE
, REFERENCE_PERIOD_MEANING REFERENCE_PERIOD_MEANING
, BASE_YEAR BASE_YEAR
, ILP_ASSESSMENT_DATE ILP_ASSESSMENT_DATE
, BASIS_START_DATE BASIS_START_DATE
, BASIS_END_DATE BASIS_END_DATE
, INDEX_FINDER_DATE INDEX_FINDER_DATE
, CURRENT_BASIS CURRENT_BASIS
, RELATIONSHIP_MEANING RELATIONSHIP_MEANING
, INDEX_PERCENT_CHANGE INDEX_PERCENT_CHANGE
, BASIS_PERCENT_CHANGE BASIS_PERCENT_CHANGE
, CURRENT_INDEX_LINE_VALUE CURRENT_INDEX_LINE_VALUE
, PREVIOUS_INDEX_LINE_VALUE PREVIOUS_INDEX_LINE_VALUE
, UNCONSTRAINT_RENT_DUE UNCONSTRAINT_RENT_DUE
, CONSTRAINT_RENT_DUE CONSTRAINT_RENT_DUE
, CARRY_FORWARD_AMOUNT CARRY_FORWARD_AMOUNT
, CARRY_FORWARD_PERCENT CARRY_FORWARD_PERCENT
, CONSTRAINT_APPLIED_AMOUNT CONSTRAINT_APPLIED_AMOUNT
, CONSTRAINT_APPLIED_PERCENT CONSTRAINT_APPLIED_PERCENT
, OPEN_CARRY_FORWARD_AMOUNT OPEN_CARRY_FORWARD_AMOUNT
, OPEN_CARRY_FORWARD_PERCENT OPEN_CARRY_FORWARD_PERCENT
, APP_CARRY_FORWARD_AMOUNT APP_CARRY_FORWARD_AMOUNT
, APP_CARRY_FORWARD_PERCENT APP_CARRY_FORWARD_PERCENT
, OLD_RENT OLD_RENT
, NEW_RENT NEW_RENT
, CHANGE_RENT CHANGE_RENT
, CONSTRAINT_PRORATION CONSTRAINT_PRORATION
, INDEX_MULTIPLIER INDEX_MULTIPLIER
, UNADJUSTED_INDEX_CHANGE UNADJUSTED_INDEX_CHANGE
, ADJUSTED_INDEX_CHANGE_PERCENT ADJUSTED_INDEX_CHANGE_PERCENT
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
FROM "PN"."PN_RENT_INCREASE_SUMMARY_ITF"