Product: | PN - Property Manager |
---|---|
Description: | Form view for viewing variable rent adjustment history details. |
Implementation/DBA Data: | APPS.PN_VAR_RENT_ADJ_V |
SELECT INV.ROWID ROW_ID
, INV.VAR_RENT_INV_ID VAR_RENT_INV_ID
, INV.INVOICE_DATE INVOICE_DATE
, INV.ADJUST_NUM ADJUST_NUM
, INV.TOT_ACT_VOL TOT_ACT_VOL
, INV.FOR_PER_RENT FOR_PER_RENT
, INV.ACT_PER_RENT ACT_PER_RENT
, INV.CONSTR_ACTUAL_RENT CONSTR_ACTUAL_RENT
, INV.ABATEMENT_APPL ABATEMENT_APPL
, (SUM(INV.ACTUAL_INVOICED_AMOUNT) OVER (PARTITION BY INV.INVOICE_DATE
, INV.PERIOD_ID ORDER BY INV.ADJUST_NUM
, INV.INVOICE_DATE)) AS ACTUAL_INVOICED_AMOUNT
, INV.ACTUAL_INVOICED_AMOUNT ADJUSTMENT
, INV.NEGATIVE_RENT NEGATIVE_RENT
, (INV.ACT_PER_RENT - INV.FOR_PER_RENT) VARIANCE
, INV.ACTUAL_TERM_STATUS ACTUAL_TERM_STATUS
, INV.FORECASTED_TERM_STATUS FORECASTED_TERM_STATUS
, INV.VARIANCE_TERM_STATUS VARIANCE_TERM_STATUS
, INV.COMMENTS COMMENTS
, INV.ACTUAL_EXP_CODE ACTUAL_EXP_CODE
, INV.FORECASTED_EXP_CODE FORECASTED_EXP_CODE
, INV.VARIANCE_EXP_CODE VARIANCE_EXP_CODE
, INV.REC_ABATEMENT REC_ABATEMENT
, INV.REC_ABATEMENT_OVERRIDE REC_ABATEMENT_OVERRIDE
, INV.PERIOD_ID PERIOD_ID
, INV.VAR_RENT_ID VAR_RENT_ID
, INV.LAST_UPDATE_DATE LAST_UPDATE_DATE
, INV.LAST_UPDATED_BY LAST_UPDATED_BY
, INV.CREATION_DATE CREATION_DATE
, INV.CREATED_BY CREATED_BY
, INV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, INV.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, INV.ATTRIBUTE1 ATTRIBUTE1
, INV.ATTRIBUTE2 ATTRIBUTE2
, INV.ATTRIBUTE3 ATTRIBUTE3
, INV.ATTRIBUTE4 ATTRIBUTE4
, INV.ATTRIBUTE5 ATTRIBUTE5
, INV.ATTRIBUTE6 ATTRIBUTE6
, INV.ATTRIBUTE7 ATTRIBUTE7
, INV.ATTRIBUTE8 ATTRIBUTE8
, INV.ATTRIBUTE9 ATTRIBUTE9
, INV.ATTRIBUTE10 ATTRIBUTE10
, INV.ATTRIBUTE11 ATTRIBUTE11
, INV.ATTRIBUTE12 ATTRIBUTE12
, INV.ATTRIBUTE13 ATTRIBUTE13
, INV.ATTRIBUTE14 ATTRIBUTE14
, INV.ATTRIBUTE15 ATTRIBUTE15
, INV.ORG_ID ORG_ID
, GD.INV_SCHEDULE_DATE INV_SCHEDULE_DATE
FROM PN_VAR_PERIODS_ALL PER
, PN_VAR_RENTS_ALL RENT
, PN_VAR_RENT_INV INV
, (SELECT GD1.INV_SCHEDULE_DATE
, GD1.INVOICE_DATE
, GD1.PERIOD_ID
FROM PN_VAR_GRP_DATES_ALL GD1 GROUP BY GD1.PERIOD_ID
, GD1.INVOICE_DATE
, GD1.INV_SCHEDULE_DATE) GD
WHERE INV.PERIOD_ID = GD.PERIOD_ID
AND INV.INVOICE_DATE = GD.INVOICE_DATE
AND INV.PERIOD_ID = PER.PERIOD_ID
AND INV.VAR_RENT_ID = RENT.VAR_RENT_ID
AND EXISTS (SELECT 1
FROM PN_VAR_RENT_INV INV1
WHERE INV1.PERIOD_ID = INV.PERIOD_ID
AND INV1.INVOICE_DATE = INV.INVOICE_DATE
AND INV1.ADJUST_NUM > 0)