View: PN_VAR_PERIODS_V

Product:	PN - Property Manager
Description:	Form view used to display generated periods for a variable rent agreement.
Implementation/DBA Data:	APPS.PN_VAR_PERIODS_V

View Text

SELECT PER.ROWID ROW_ID
, PER.PERIOD_ID PERIOD_ID
, PER.PERIOD_NUM PERIOD_NUM
, PER.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PER.LAST_UPDATED_BY LAST_UPDATED_BY
, PER.CREATION_DATE CREATION_DATE
, PER.CREATED_BY CREATED_BY
, PER.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PER.VAR_RENT_ID VAR_RENT_ID
, PER.START_DATE START_DATE
, PER.END_DATE END_DATE
, SUMM.ACTUAL_VAR_RENT ACTUAL_VAR_RENT
, SUMM.FOR_VAR_RENT FOR_VAR_RENT
, (SUMM.ACTUAL_VAR_RENT - SUMM.FOR_VAR_RENT) DIFF_VAR_RENT
, PER.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PER.ATTRIBUTE1 ATTRIBUTE1
, PER.ATTRIBUTE2 ATTRIBUTE2
, PER.ATTRIBUTE3 ATTRIBUTE3
, PER.ATTRIBUTE4 ATTRIBUTE4
, PER.ATTRIBUTE5 ATTRIBUTE5
, PER.ATTRIBUTE6 ATTRIBUTE6
, PER.ATTRIBUTE7 ATTRIBUTE7
, PER.ATTRIBUTE8 ATTRIBUTE8
, PER.ATTRIBUTE9 ATTRIBUTE9
, PER.ATTRIBUTE10 ATTRIBUTE10
, PER.ATTRIBUTE11 ATTRIBUTE11
, PER.ATTRIBUTE12 ATTRIBUTE12
, PER.ATTRIBUTE13 ATTRIBUTE13
, PER.ATTRIBUTE14 ATTRIBUTE14
, PER.ATTRIBUTE15 ATTRIBUTE15
, PER.ORG_ID ORG_ID
FROM (SELECT SUM(VSUMM.ACTUAL_INVOICED_AMOUNT) ACTUAL_VAR_RENT
, SUM(DECODE(VSUMM.ADJUST_NUM
, 0
, VSUMM.FOR_PER_RENT
, 0)) FOR_VAR_RENT
, VSUMM.PERIOD_ID
, VSUMM.VAR_RENT_ID
FROM PN_VAR_RENT_INV_ALL VSUMM
, PN_VAR_PERIODS_ALL PER
WHERE VSUMM.PERIOD_ID(+) = PER.PERIOD_ID
AND VSUMM.VAR_RENT_ID(+) = PER.VAR_RENT_ID GROUP BY VSUMM.PERIOD_ID
, VSUMM.VAR_RENT_ID) SUMM
, PN_VAR_RENTS_ALL VARENT
, PN_VAR_PERIODS PER
WHERE PER.VAR_RENT_ID = VARENT.VAR_RENT_ID
AND SUMM.PERIOD_ID(+) = PER.PERIOD_ID
AND SUMM.VAR_RENT_ID(+) = PER.VAR_RENT_ID

Columns