VIEW: PN.PN_RENT_INCREASE_DETAILACC_IT#

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, PAYMENT_PURPOSE_MEANING PAYMENT_PURPOSE_MEANING, PAYMENT_TERM_TYPE_MEANING PAYMENT_TERM_TYPE_MEANING, FREQUENCY_MEANING FREQUENCY_MEANING, START_DATE START_DATE, END_DATE END_DATE, VENDOR_NAME VENDOR_NAME, VENDOR_SITE_CODE VENDOR_SITE_CODE, TARGET_DATE TARGET_DATE, ACTUAL_AMOUNT ACTUAL_AMOUNT, ESTIMATED_AMOUNT ESTIMATED_AMOUNT, CURRENCY_CODE CURRENCY_CODE, RATE RATE, CUSTOMER_NAME CUSTOMER_NAME, CUSTOMER_BILL_SITE CUSTOMER_BILL_SITE, NORMALIZE NORMALIZE, LOCATION_CODE LOCATION_CODE, LOCATION_TYPE_LOOKUP_CODE LOCATION_TYPE_LOOKUP_CODE, SCHEDULE_DAY SCHEDULE_DAY, CUSTOMER_SHIP_SITE CUSTOMER_SHIP_SITE, AP_AR_TERM_NAME AP_AR_TERM_NAME, CUST_TRX_TYPE_NAME CUST_TRX_TYPE_NAME, PROJECT_NUMBER PROJECT_NUMBER, TASK_NUMBER TASK_NUMBER, ORGANIZATION_NAME ORGANIZATION_NAME, EXPENDITURE_TYPE EXPENDITURE_TYPE, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, INV_RULE_NAME INV_RULE_NAME, ACCOUNT_RULE_NAME ACCOUNT_RULE_NAME, SALESREP_NAME SALESREP_NAME, PAYTERM_STATUS PAYTERM_STATUS, APPROVED_BY_NAME APPROVED_BY_NAME, PO_NUMBER PO_NUMBER, PAYMENT_METHOD PAYMENT_METHOD, SUPPLIER_NUMBER SUPPLIER_NUMBER, CUSTOMER_NUMBER CUSTOMER_NUMBER, ANNUAL ANNUAL, AREA AREA, ANNUAL_AREA ANNUAL_AREA, TAX_CODE TAX_CODE, TAX_GROUP TAX_GROUP, TAX_INCLUDED TAX_INCLUDED, INDEX_TERM_INDICATOR INDEX_TERM_INDICATOR, 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, ACCOUNT_CLASS_MEANING ACCOUNT_CLASS_MEANING, GL_CONCATENATED_SEGMENTS GL_CONCATENATED_SEGMENTS, DISTRIBUTION_PERCENTAGE DISTRIBUTION_PERCENTAGE, DISTRIBUTION_AMOUNT DISTRIBUTION_AMOUNT, CONSTRAINT_PRORATION CONSTRAINT_PRORATION, INDEX_MULTIPLIER INDEX_MULTIPLIER, UNADJUSTED_INDEX_CHANGE UNADJUSTED_INDEX_CHANGE, ADJUSTED_INDEX_CHANGE_PERCENT ADJUSTED_INDEX_CHANGE_PERCENT, INCLUDE_IN_VAR_RENT INCLUDE_IN_VAR_RENT, 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_DETAILACC_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
, PAYMENT_PURPOSE_MEANING PAYMENT_PURPOSE_MEANING
, PAYMENT_TERM_TYPE_MEANING PAYMENT_TERM_TYPE_MEANING
, FREQUENCY_MEANING FREQUENCY_MEANING
, START_DATE START_DATE
, END_DATE END_DATE
, VENDOR_NAME VENDOR_NAME
, VENDOR_SITE_CODE VENDOR_SITE_CODE
, TARGET_DATE TARGET_DATE
, ACTUAL_AMOUNT ACTUAL_AMOUNT
, ESTIMATED_AMOUNT ESTIMATED_AMOUNT
, CURRENCY_CODE CURRENCY_CODE
, RATE RATE
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_BILL_SITE CUSTOMER_BILL_SITE
, NORMALIZE NORMALIZE
, LOCATION_CODE LOCATION_CODE
, LOCATION_TYPE_LOOKUP_CODE LOCATION_TYPE_LOOKUP_CODE
, SCHEDULE_DAY SCHEDULE_DAY
, CUSTOMER_SHIP_SITE CUSTOMER_SHIP_SITE
, AP_AR_TERM_NAME AP_AR_TERM_NAME
, CUST_TRX_TYPE_NAME CUST_TRX_TYPE_NAME
, PROJECT_NUMBER PROJECT_NUMBER
, TASK_NUMBER TASK_NUMBER
, ORGANIZATION_NAME ORGANIZATION_NAME
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, INV_RULE_NAME INV_RULE_NAME
, ACCOUNT_RULE_NAME ACCOUNT_RULE_NAME
, SALESREP_NAME SALESREP_NAME
, PAYTERM_STATUS PAYTERM_STATUS
, APPROVED_BY_NAME APPROVED_BY_NAME
, PO_NUMBER PO_NUMBER
, PAYMENT_METHOD PAYMENT_METHOD
, SUPPLIER_NUMBER SUPPLIER_NUMBER
, CUSTOMER_NUMBER CUSTOMER_NUMBER
, ANNUAL ANNUAL
, AREA AREA
, ANNUAL_AREA ANNUAL_AREA
, TAX_CODE TAX_CODE
, TAX_GROUP TAX_GROUP
, TAX_INCLUDED TAX_INCLUDED
, INDEX_TERM_INDICATOR INDEX_TERM_INDICATOR
, 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
, ACCOUNT_CLASS_MEANING ACCOUNT_CLASS_MEANING
, GL_CONCATENATED_SEGMENTS GL_CONCATENATED_SEGMENTS
, DISTRIBUTION_PERCENTAGE DISTRIBUTION_PERCENTAGE
, DISTRIBUTION_AMOUNT DISTRIBUTION_AMOUNT
, CONSTRAINT_PRORATION CONSTRAINT_PRORATION
, INDEX_MULTIPLIER INDEX_MULTIPLIER
, UNADJUSTED_INDEX_CHANGE UNADJUSTED_INDEX_CHANGE
, ADJUSTED_INDEX_CHANGE_PERCENT ADJUSTED_INDEX_CHANGE_PERCENT
, INCLUDE_IN_VAR_RENT INCLUDE_IN_VAR_RENT
, 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_DETAILACC_ITF"