View: PN_VAR_RENT_INV_V

Product:	PN - Property Manager
Description:	Form view used to view variable rent calculation details by period.
Implementation/DBA Data:	APPS.PN_VAR_RENT_INV_V

View Text

SELECT "ROW_ID"
, "VAR_RENT_INV_ID"
, "ADJUST_NUM"
, "VAR_RENT_ID"
, "PERIOD_ID"
, "INVOICE_DATE"
, "TOT_ACT_VOL"
, "ACT_PER_RENT"
, "CONSTR_ACTUAL_RENT"
, "FOR_PER_RENT"
, "CUMULATIVE_FOR_RENT"
, "ACTUAL_FORECASTED_RENT"
, "CUMULATIVE_ACT_FOR_RENT"
, "FORECASTED_TERM_STATUS"
, "ABATEMENT_APPL"
, "REC_ABATEMENT"
, "REC_ABATEMENT_OVERRIDE"
, "NEGATIVE_RENT"
, "PREV_INVOICED_AMOUNT"
, "ACTUAL_INVOICED_AMOUNT"
, "CUMULATIVE_ACT_RENT"
, "ACTUAL_TERM_STATUS"
, "VARIANCE_TERM_STATUS"
, "ACTUAL_EXP_CODE"
, "FORECASTED_EXP_CODE"
, "VARIANCE_EXP_CODE"
, "COMMENTS"
, "ATTRIBUTE_CATEGORY"
, "ATTRIBUTE1"
, "ATTRIBUTE2"
, "ATTRIBUTE3"
, "ATTRIBUTE4"
, "ATTRIBUTE5"
, "ATTRIBUTE6"
, "ATTRIBUTE7"
, "ATTRIBUTE8"
, "ATTRIBUTE9"
, "ATTRIBUTE10"
, "ATTRIBUTE11"
, "ATTRIBUTE12"
, "ATTRIBUTE13"
, "ATTRIBUTE14"
, "ATTRIBUTE15"
, "CREATION_DATE"
, "CREATED_BY"
, "LAST_UPDATE_DATE"
, "LAST_UPDATED_BY"
, "LAST_UPDATE_LOGIN"
, "INV_SCHEDULE_DATE"
, "ORG_ID"
FROM (SELECT RENT_INV.ROWID AS ROW_ID
, RENT_INV.VAR_RENT_INV_ID
, RENT_INV.ADJUST_NUM
, RENT_INV.VAR_RENT_ID
, RENT_INV.PERIOD_ID
, RENT_INV.INVOICE_DATE
, RENT_INV.TOT_ACT_VOL
, RENT_INV.ACT_PER_RENT
, RENT_INV.CONSTR_ACTUAL_RENT
, RENT_INV.FOR_PER_RENT
, TO_NUMBER(DECODE(RENT_INV.FOR_PER_RENT
, NULL
, NULL
, SUM(RENT_INV.FOR_PER_RENT) OVER (PARTITION BY RENT_INV.PERIOD_ID ORDER BY RENT_INV.PERIOD_ID
, RENT_INV.INVOICE_DATE ROWS UNBOUNDED PRECEDING))) AS CUMULATIVE_FOR_RENT
, (RENT_INV.ACTUAL_INVOICED_AMOUNT - RENT_INV.FOR_PER_RENT) AS ACTUAL_FORECASTED_RENT
, TO_NUMBER(DECODE((RENT_INV.ACTUAL_INVOICED_AMOUNT - RENT_INV.FOR_PER_RENT)
, NULL
, NULL
, SUM(RENT_INV.ACTUAL_INVOICED_AMOUNT - RENT_INV.FOR_PER_RENT) OVER (PARTITION BY RENT_INV.PERIOD_ID ORDER BY RENT_INV.PERIOD_ID
, RENT_INV.INVOICE_DATE ROWS UNBOUNDED PRECEDING))) AS CUMULATIVE_ACT_FOR_RENT
, RENT_INV.FORECASTED_TERM_STATUS
, RENT_INV.ABATEMENT_APPL
, RENT_INV.REC_ABATEMENT
, RENT_INV.REC_ABATEMENT_OVERRIDE
, RENT_INV.NEGATIVE_RENT
, (SUM(TO_NUMBER(DECODE(RENT_INV.ACTUAL_EXP_CODE
, 'Y'
, RENT_INV.ACTUAL_INVOICED_AMOUNT
, 0))) OVER (PARTITION BY RENT_INV.PERIOD_ID
, RENT_INV.INVOICE_DATE ORDER BY RENT_INV.ADJUST_NUM
, RENT_INV.INVOICE_DATE)) AS PREV_INVOICED_AMOUNT
, (SUM(RENT_INV.ACTUAL_INVOICED_AMOUNT) OVER (PARTITION BY RENT_INV.PERIOD_ID
, RENT_INV.INVOICE_DATE ORDER BY RENT_INV.ADJUST_NUM
, RENT_INV.INVOICE_DATE)) AS ACTUAL_INVOICED_AMOUNT
, TO_NUMBER(DECODE(RENT_INV.ACTUAL_INVOICED_AMOUNT
, NULL
, NULL
, SUM(RENT_INV.ACTUAL_INVOICED_AMOUNT) OVER (PARTITION BY RENT_INV.PERIOD_ID ORDER BY RENT_INV.PERIOD_ID
, RENT_INV.INVOICE_DATE ROWS UNBOUNDED PRECEDING))) AS CUMULATIVE_ACT_RENT
, RENT_INV.ACTUAL_TERM_STATUS
, RENT_INV.VARIANCE_TERM_STATUS
, RENT_INV.ACTUAL_EXP_CODE
, RENT_INV.FORECASTED_EXP_CODE
, RENT_INV.VARIANCE_EXP_CODE
, RENT_INV.COMMENTS
, RENT_INV.ATTRIBUTE_CATEGORY
, RENT_INV.ATTRIBUTE1
, RENT_INV.ATTRIBUTE2
, RENT_INV.ATTRIBUTE3
, RENT_INV.ATTRIBUTE4
, RENT_INV.ATTRIBUTE5
, RENT_INV.ATTRIBUTE6
, RENT_INV.ATTRIBUTE7
, RENT_INV.ATTRIBUTE8
, RENT_INV.ATTRIBUTE9
, RENT_INV.ATTRIBUTE10
, RENT_INV.ATTRIBUTE11
, RENT_INV.ATTRIBUTE12
, RENT_INV.ATTRIBUTE13
, RENT_INV.ATTRIBUTE14
, RENT_INV.ATTRIBUTE15
, RENT_INV.CREATION_DATE
, RENT_INV.CREATED_BY
, RENT_INV.LAST_UPDATE_DATE
, RENT_INV.LAST_UPDATED_BY
, RENT_INV.LAST_UPDATE_LOGIN
, GD.INV_SCHEDULE_DATE
, RENT_INV.ORG_ID
FROM PN_VAR_RENT_INV RENT_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 RENT_INV.PERIOD_ID = GD.PERIOD_ID
AND RENT_INV.INVOICE_DATE = GD.INVOICE_DATE ) RENT_INV_TEMP
WHERE RENT_INV_TEMP.ADJUST_NUM = (SELECT MAX(INV.ADJUST_NUM)
FROM PN_VAR_RENT_INV_ALL INV
WHERE INV.PERIOD_ID = RENT_INV_TEMP.PERIOD_ID
AND INV.INVOICE_DATE = RENT_INV_TEMP.INVOICE_DATE)

Columns