View: PN_LEASE_DETAILS_V

Product:	PN - Property Manager
Description:
Implementation/DBA Data:	APPS.PN_LEASE_DETAILS_V

View Text

SELECT PLD. ROWID
, PLD.LEASE_DETAIL_ID
, PLD.LEASE_CHANGE_ID
, PLD.LEASE_ID
, PNL.NAME LEASE_NAME
, PNL.LEASE_NUM LEASE_NUMBER
, PNL.LEASE_STATUS LEASE_STATUS
, PLD.RESPONSIBLE_USER RESPONSIBLE_USER_ID
, FNR.USER_NAME
, PLD.EXPENSE_ACCOUNT_ID
, PLD.LEASE_EXECUTION_DATE
, PLD.LEASE_COMMENCEMENT_DATE
, PLD.LEASE_TERMINATION_DATE
, PLD.LEASE_EXTENSION_END_DATE
, (TRUNC(NVL(PLD.LEASE_TERMINATION_DATE
, SYSDATE)) - TRUNC(NVL(PLD.LEASE_COMMENCEMENT_DATE
, SYSDATE)) + 1) LEASE_TERM
, PLD.LAST_UPDATE_DATE
, PLD.LAST_UPDATED_BY
, PLD.CREATION_DATE
, PLD.CREATED_BY
, PLD.LAST_UPDATE_LOGIN
, PLD.ATTRIBUTE_CATEGORY
, PLD.ATTRIBUTE1
, PLD.ATTRIBUTE2
, PLD.ATTRIBUTE3
, PLD.ATTRIBUTE4
, PLD.ATTRIBUTE5
, PLD.ATTRIBUTE6
, PLD.ATTRIBUTE7
, PLD.ATTRIBUTE8
, PLD.ATTRIBUTE9
, PLD.ATTRIBUTE10
, PLD.ATTRIBUTE11
, PLD.ATTRIBUTE12
, PLD.ATTRIBUTE13
, PLD.ATTRIBUTE14
, PLD.ATTRIBUTE15
, PLD.ACCRUAL_ACCOUNT_ID
, PLD.RECEIVABLE_ACCOUNT_ID
, PLD.TERM_TEMPLATE_ID
, PNL.PAYMENT_TERM_PRORATION_RULE
, PLD.GROUPING_RULE_ID
, PPGR.NAME
, PLD.ORG_ID
FROM FND_USER FNR
, PN_LEASES_ALL PNL
, PN_LEASE_DETAILS PLD
, PN_PAY_GROUP_RULES PPGR
WHERE PNL.LEASE_ID = PLD.LEASE_ID
AND PPGR.GROUPING_RULE_ID (+) = PLD.GROUPING_RULE_ID
AND FNR.USER_ID = PLD.RESPONSIBLE_USER

Columns