View: PN_VAR_RENT_SUMM_V

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

View Text

SELECT SUMM.VAR_RENT_ID
, SUMM.PERIOD_ID
, SUMM.LINE_ITEM_ID
, SUMM.INVOICE_DATE
, SUM(VSUMM.TOT_ACT_VOL) ACTUAL_VOLUME
, SUM(VSUMM.TOT_FOR_VOL) FORECASTED_VOLUME
, TO_NUMBER(DECODE(SUM(VSUMM.TOT_FOR_VOL)
, NULL
, NULL
, SUM(SUM(VSUMM.TOT_FOR_VOL)) OVER (PARTITION BY SUMM.LINE_ITEM_ID ORDER BY SUMM.INVOICE_DATE ROWS UNBOUNDED PRECEDING)))
, SUM(VSUMM.TOT_DED) DEDUCTIONS
, (SUM(VSUMM.TOT_ACT_VOL) - SUM(VSUMM.TOT_DED)) NET_ACTUAL_VOLUME
, TO_NUMBER(DECODE((SUM(VSUMM.TOT_ACT_VOL)-SUM(VSUMM.TOT_DED))
, NULL
, NULL
, SUM(SUM(VSUMM.TOT_ACT_VOL)-SUM(VSUMM.TOT_DED)) OVER (PARTITION BY SUMM.LINE_ITEM_ID ORDER BY SUMM.INVOICE_DATE ROWS UNBOUNDED PRECEDING)))
, SUM(SUMM.ACT_VAR_RENT) ACT_VAR_RENT
, TO_NUMBER(DECODE(SUM(SUMM.ACT_VAR_RENT)
, NULL
, NULL
, SUM(SUM(SUMM.ACT_VAR_RENT)) OVER (PARTITION BY SUMM.LINE_ITEM_ID ORDER BY SUMM.INVOICE_DATE ROWS UNBOUNDED PRECEDING)))
, SUM(SUMM.FOR_VAR_RENT) FOR_VAR_RENT
, TO_NUMBER(DECODE(SUM(SUMM.FOR_VAR_RENT)
, NULL
, NULL
, SUM(SUM(SUMM.FOR_VAR_RENT)) OVER (PARTITION BY SUMM.LINE_ITEM_ID ORDER BY SUMM.INVOICE_DATE ROWS UNBOUNDED PRECEDING)))
, GD.INV_SCHEDULE_DATE
, SUMM.ORG_ID
FROM PN_VAR_RENT_SUMM SUMM
, PN_VAR_GRP_DATES_ALL GD
, (SELECT PN_VARIABLE_AMOUNT_PKG.GET_VOL_DED(SUMM1.LINE_ITEM_ID
, SUMM1.GROUP_DATE
, 'ACT') TOT_ACT_VOL
, PN_VARIABLE_AMOUNT_PKG.GET_VOL_DED(SUMM1.LINE_ITEM_ID
, SUMM1.GROUP_DATE
, 'FOR') TOT_FOR_VOL
, PN_VARIABLE_AMOUNT_PKG.GET_VOL_DED(SUMM1.LINE_ITEM_ID
, SUMM1.GROUP_DATE
, 'DED') TOT_DED
, SUMM1.LINE_ITEM_ID
, SUMM1.GROUP_DATE
FROM PN_VAR_RENT_SUMM_ALL SUMM1) VSUMM
WHERE SUMM.LINE_ITEM_ID = VSUMM.LINE_ITEM_ID
AND SUMM.GROUP_DATE = VSUMM.GROUP_DATE
AND SUMM.GRP_DATE_ID = GD.GRP_DATE_ID GROUP BY SUMM.VAR_RENT_ID
, SUMM.PERIOD_ID
, SUMM.LINE_ITEM_ID
, SUMM.INVOICE_DATE
, GD.INV_SCHEDULE_DATE
, SUMM.ORG_ID

Columns