View: PN_VAR_PERIODS_DATES_V

Product:	PN - Property Manager
Description:	Form view for viewing variable rent period details.
Implementation/DBA Data:	APPS.PN_VAR_PERIODS_DATES_V

View Text

SELECT PER.ROWID
, PER.PERIOD_ID
, PER.PERIOD_NUM
, PER.VAR_RENT_ID
, PER.START_DATE
, PER.END_DATE
, VARENT.UOM_CODE
, VARENT.RENT_NUM
, VARENT.LEASE_ID
, VARENT_DATES.INVG_FREQ_CODE
, VARENT_DATES.RECON_FREQ_CODE
, VARENT_DATES.REPTG_FREQ_CODE
, VARENT_DATES.AUDIT_FREQ_CODE
, PER.LAST_UPDATE_DATE
, PER.LAST_UPDATED_BY
, PER.CREATION_DATE
, PER.CREATED_BY
, PER.LAST_UPDATE_LOGIN
, VARENT.ORG_ID
FROM PN_VAR_RENT_DATES_ALL VARENT_DATES
, PN_VAR_RENTS VARENT
, PN_VAR_PERIODS_ALL PER
WHERE PER.VAR_RENT_ID = VARENT.VAR_RENT_ID
AND VARENT.VAR_RENT_ID = VARENT_DATES.VAR_RENT_ID

Columns