View: PN_VAR_RENT_DETAILS_V

Product:	PN - Property Manager
Description:	Form view for viewing variable rent details by line item and group date.
Implementation/DBA Data:	APPS.PN_VAR_RENT_DETAILS_V

View Text

SELECT GROUP_DATE
, INVOICE_DATE
, LINE_ITEM_ID
, TOT_VOL
, BKPT_VOL_START
, BKPT_VOL_END
, VOL_APPL
, BKPT_RATE
, VAR_RENT
, SUM(VAR_RENT) OVER (PARTITION BY LINE_ITEM_ID ORDER BY LINE_ITEM_ID
, GROUP_DATE
, BKPT_VOL_START ROWS UNBOUNDED PRECEDING) AS CUMULATIVE_RENT
, ACTUAL_EXP_CODE
, FORECASTED_EXP_CODE
, VARIANCE_EXP_CODE
, VAR_RENT_TYPE
, ORG_ID
FROM PN_FOR_RENT_DETAILS_V UNION ALL SELECT GROUP_DATE
, INVOICE_DATE
, LINE_ITEM_ID
, TOT_VOL
, BKPT_VOL_START
, BKPT_VOL_END
, VOL_APPL
, BKPT_RATE
, VAR_RENT
, SUM(VAR_RENT) OVER (PARTITION BY LINE_ITEM_ID ORDER BY LINE_ITEM_ID
, GROUP_DATE
, BKPT_VOL_START ROWS UNBOUNDED PRECEDING) AS CUMULATIVE_RENT
, ACTUAL_EXP_CODE
, FORECASTED_EXP_CODE
, VARIANCE_EXP_CODE
, VAR_RENT_TYPE
, ORG_ID
FROM PN_ACT_RENT_DETAILS_V

Columns