VIEW: PN.PN_VAR_RENT_INV_ALL#

Source

View Text - Preformatted

select VAR_RENT_INV_ID VAR_RENT_INV_ID, ADJUST_NUM ADJUST_NUM, INVOICE_DATE INVOICE_DATE, FOR_PER_RENT FOR_PER_RENT, TOT_ACT_VOL TOT_ACT_VOL, ACT_PER_RENT ACT_PER_RENT, CONSTR_ACTUAL_RENT CONSTR_ACTUAL_RENT, ABATEMENT_APPL ABATEMENT_APPL, NEGATIVE_RENT NEGATIVE_RENT, ACTUAL_INVOICED_AMOUNT ACTUAL_INVOICED_AMOUNT, PERIOD_ID PERIOD_ID, VAR_RENT_ID VAR_RENT_ID, ACTUAL_TERM_STATUS ACTUAL_TERM_STATUS, FORECASTED_TERM_STATUS FORECASTED_TERM_STATUS, VARIANCE_TERM_STATUS VARIANCE_TERM_STATUS, ACTUAL_EXP_CODE ACTUAL_EXP_CODE, FORECASTED_EXP_CODE FORECASTED_EXP_CODE, VARIANCE_EXP_CODE VARIANCE_EXP_CODE, COMMENTS COMMENTS, 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, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ORG_ID ORG_ID, REC_ABATEMENT REC_ABATEMENT, REC_ABATEMENT_OVERRIDE REC_ABATEMENT_OVERRIDE, DEF_NEG_RENT DEF_NEG_RENT, TRUE_UP_AMT TRUE_UP_AMT, TRUE_UP_STATUS TRUE_UP_STATUS, TRUE_UP_EXP_CODE TRUE_UP_EXP_CODE, CREDIT_FLAG CREDIT_FLAG from "PN"."PN_VAR_RENT_INV_ALL"

View Text - HTML Formatted

SELECT VAR_RENT_INV_ID VAR_RENT_INV_ID
, ADJUST_NUM ADJUST_NUM
, INVOICE_DATE INVOICE_DATE
, FOR_PER_RENT FOR_PER_RENT
, TOT_ACT_VOL TOT_ACT_VOL
, ACT_PER_RENT ACT_PER_RENT
, CONSTR_ACTUAL_RENT CONSTR_ACTUAL_RENT
, ABATEMENT_APPL ABATEMENT_APPL
, NEGATIVE_RENT NEGATIVE_RENT
, ACTUAL_INVOICED_AMOUNT ACTUAL_INVOICED_AMOUNT
, PERIOD_ID PERIOD_ID
, VAR_RENT_ID VAR_RENT_ID
, ACTUAL_TERM_STATUS ACTUAL_TERM_STATUS
, FORECASTED_TERM_STATUS FORECASTED_TERM_STATUS
, VARIANCE_TERM_STATUS VARIANCE_TERM_STATUS
, ACTUAL_EXP_CODE ACTUAL_EXP_CODE
, FORECASTED_EXP_CODE FORECASTED_EXP_CODE
, VARIANCE_EXP_CODE VARIANCE_EXP_CODE
, COMMENTS COMMENTS
, 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
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ORG_ID ORG_ID
, REC_ABATEMENT REC_ABATEMENT
, REC_ABATEMENT_OVERRIDE REC_ABATEMENT_OVERRIDE
, DEF_NEG_RENT DEF_NEG_RENT
, TRUE_UP_AMT TRUE_UP_AMT
, TRUE_UP_STATUS TRUE_UP_STATUS
, TRUE_UP_EXP_CODE TRUE_UP_EXP_CODE
, CREDIT_FLAG CREDIT_FLAG
FROM "PN"."PN_VAR_RENT_INV_ALL"