[Home] [Help]
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
Name |
GROUP_DATE |
INVOICE_DATE |
LINE_ITEM_ID |
TOT_VOL |
BKPT_VOL_START |
BKPT_VOL_END |
VOL_APPL |
BKPT_RATE |
VAR_RENT |
CUMULATIVE_RENT |
ACTUAL_EXP_CODE |
FORECASTED_EXP_CODE |
VARIANCE_EXP_CODE |
VAR_RENT_TYPE |
ORG_ID |