View: PN_INDEX_LEASE_PERIODS_V

Product:	PN - Property Manager
Description:	Form view based on PN_INDEX_LEASE_PERIODS_ALL
Implementation/DBA Data:	APPS.PN_INDEX_LEASE_PERIODS_V

View Text

SELECT PERIODS.ROWID ROW_ID
, PERIODS.INDEX_PERIOD_ID
, PERIODS.INDEX_LEASE_ID
, PERIODS.LINE_NUMBER
, PERIODS.ASSESSMENT_DATE
, PERIODS.BASIS_START_DATE
, PERIODS.BASIS_END_DATE
, PERIODS.INDEX_FINDER_DATE
, PERIODS.CURRENT_INDEX_LINE_ID
, PERIODS.CURRENT_INDEX_LINE_VALUE
, PERIODS.PREVIOUS_INDEX_LINE_ID
, PERIODS.PREVIOUS_INDEX_LINE_VALUE
, PERIODS.CURRENT_BASIS
, PERIODS.RELATIONSHIP
, PERIODS.INDEX_PERCENT_CHANGE
, PERIODS.BASIS_PERCENT_CHANGE
, PERIODS.CONSTRAINT_APPLIED_AMOUNT
, PERIODS.CONSTRAINT_APPLIED_PERCENT
, PERIODS.CARRY_FORWARD_AMOUNT
, PERIODS.CARRY_FORWARD_PERCENT
, PERIODS.UNCONSTRAINT_RENT_DUE
, PERIODS.CONSTRAINT_RENT_DUE
, PERIODS.LAST_UPDATE_DATE
, PERIODS.LAST_UPDATED_BY
, PERIODS.CREATION_DATE
, PERIODS.CREATED_BY
, PERIODS.LAST_UPDATE_LOGIN
, PERIODS.ATTRIBUTE_CATEGORY
, PERIODS.ATTRIBUTE1
, PERIODS.ATTRIBUTE2
, PERIODS.ATTRIBUTE3
, PERIODS.ATTRIBUTE4
, PERIODS.ATTRIBUTE5
, PERIODS.ATTRIBUTE6
, PERIODS.ATTRIBUTE7
, PERIODS.ATTRIBUTE8
, PERIODS.ATTRIBUTE9
, PERIODS.ATTRIBUTE10
, PERIODS.ATTRIBUTE11
, PERIODS.ATTRIBUTE12
, PERIODS.ATTRIBUTE13
, PERIODS.ATTRIBUTE14
, PERIODS.ATTRIBUTE15
, LEASES.BASE_INDEX
, PERIODS.ORG_ID
FROM PN_INDEX_LEASE_PERIODS PERIODS
, PN_INDEX_LEASES_ALL LEASES
WHERE PERIODS.INDEX_LEASE_ID = LEASES.INDEX_LEASE_ID ORDER BY PERIODS.LINE_NUMBER

Columns