View: PN_VAR_RENTS_V

Product:	PN - Property Manager
Description:	Form view used to input variable rent agreement related information.
Implementation/DBA Data:	APPS.PN_VAR_RENTS_V

View Text

SELECT VARENT.ROWID ROW_ID
, VARENT.VAR_RENT_ID VAR_RENT_ID
, VARENT.RENT_NUM RENT_NUM
, VARENT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, VARENT.LAST_UPDATED_BY LAST_UPDATED_BY
, VARENT.CREATION_DATE CREATION_DATE
, VARENT.CREATED_BY CREATED_BY
, VARENT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, VARENT.LEASE_ID LEASE_ID
, LEASE.NAME LEASE_NAME
, LEASE.LEASE_NUM LEASE_NUMBER
, LEASE.LEASE_CLASS_CODE LEASE_CLASS_CODE
, LDET.LEASE_COMMENCEMENT_DATE LEASE_COMMENCEMENT_DATE
, LDET.LEASE_TERMINATION_DATE LEASE_TERMINATION_DATE
, VARENT.CURRENCY_CODE CURRENCY_CODE
, VARENT.LOCATION_ID LOCATION_ID
, VARENT.PRORATION_DAYS PRORATION_DAYS
, (SELECT PLO.LOCATION_CODE
FROM PN_LOCATIONS PLO
WHERE PLO.LOCATION_ID(+) = VARENT.LOCATION_ID
AND ROWNUM =1) LOCATION_CODE
, VARENT.PURPOSE_CODE PURPOSE_CODE
, FND.MEANING PURPOSE
, VARENT.TYPE_CODE TYPE_CODE
, FND1.MEANING TYPE
, VARENT.COMMENCEMENT_DATE COMMENCEMENT_DATE
, VARENT.TERMINATION_DATE TERMINATION_DATE
, VARENT.ABSTRACTED_BY_USER ABSTRACTED_BY_USER_ID
, USER1.USER_NAME USER_ABSTRACTED
, VARENT.UOM_CODE UOM
, VARENT.CUMULATIVE_VOL CUMULATIVE_VOL
, VARENT.ACCRUAL ACCRUAL
, VARENT.ROUNDING ROUNDING
, VARENT.INVOICE_ON INVOICE_ON
, VARENT.NEGATIVE_RENT NEGATIVE_RENT
, VARENT.TERM_TEMPLATE_ID TERM_TEMPLATE_ID
, TEMPLATE.NAME TERM_TEMPLATE
, VARENT.ABATEMENT_AMOUNT ABATEMENT_AMOUNT
, VARENT.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, VARENT.ATTRIBUTE1 ATTRIBUTE1
, VARENT.ATTRIBUTE2 ATTRIBUTE2
, VARENT.ATTRIBUTE3 ATTRIBUTE3
, VARENT.ATTRIBUTE4 ATTRIBUTE4
, VARENT.ATTRIBUTE5 ATTRIBUTE5
, VARENT.ATTRIBUTE6 ATTRIBUTE6
, VARENT.ATTRIBUTE7 ATTRIBUTE7
, VARENT.ATTRIBUTE8 ATTRIBUTE8
, VARENT.ATTRIBUTE9 ATTRIBUTE9
, VARENT.ATTRIBUTE10 ATTRIBUTE10
, VARENT.ATTRIBUTE11 ATTRIBUTE11
, VARENT.ATTRIBUTE12 ATTRIBUTE12
, VARENT.ATTRIBUTE13 ATTRIBUTE13
, VARENT.ATTRIBUTE14 ATTRIBUTE14
, VARENT.ATTRIBUTE15 ATTRIBUTE15
, VARENT.ORG_ID ORG_ID
FROM PN_LEASES LEASE
, PN_LEASE_DETAILS LDET
, PN_TERM_TEMPLATES TEMPLATE
, FND_USER USER1
, FND_LOOKUPS FND
, FND_LOOKUPS FND1
, PN_VAR_RENTS VARENT
WHERE LEASE.LEASE_ID = VARENT.LEASE_ID
AND LDET.LEASE_ID = LEASE.LEASE_ID
AND TEMPLATE.TERM_TEMPLATE_ID(+) = VARENT.TERM_TEMPLATE_ID
AND USER1.USER_ID = VARENT.ABSTRACTED_BY_USER
AND FND.LOOKUP_TYPE = 'PN_PAYMENT_PURPOSE_TYPE'
AND FND.LOOKUP_CODE = VARENT.PURPOSE_CODE
AND FND1.LOOKUP_TYPE = 'PN_VAR_RENT_TYPE'
AND FND1.LOOKUP_CODE = VARENT.TYPE_CODE

Columns