eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PN_LEASE_DETAILS_HISTORY_V

Product:	PN - Property Manager
Description:
Implementation/DBA Data:	APPS.PN_LEASE_DETAILS_HISTORY_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.RECEIVABLE_ACCOUNT_ID
, PLD.ACCRUAL_ACCOUNT_ID
, PLD.TERM_TEMPLATE_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
, PNL.PAYMENT_TERM_PRORATION_RULE
, TO_NUMBER(NULL) DETAIL_HISTORY_ID
, TO_NUMBER(NULL) NEW_LEASE_CHANGE_ID
, 'Y' CURRENT_FLAG
, PLD.GROUPING_RULE_ID GROUPING_RULE_ID
, PPGR.NAME INV_GROUP_NAME
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 FNR.USER_ID = PLD.RESPONSIBLE_USER
AND PPGR.GROUPING_RULE_ID (+) = PLD.GROUPING_RULE_ID UNION ALL SELECT PLD.ROWID
, PLD.LEASE_DETAIL_ID
, PLD.LEASE_CHANGE_ID
, PLD.LEASE_ID
, PLD.NAME LEASE_NAME
, PLD.LEASE_NUM LEASE_NUMBER
, PLD.LEASE_STATUS LEASE_STATUS
, PLD.RESPONSIBLE_USER RESPONSIBLE_USER_ID
, FNR.USER_NAME
, PLD.EXPENSE_ACCOUNT_ID
, PLD.RECEIVABLE_ACCOUNT_ID
, PLD.ACCRUAL_ACCOUNT_ID
, PLDT.TERM_TEMPLATE_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
, PNL.PAYMENT_TERM_PRORATION_RULE
, PLD.DETAIL_HISTORY_ID DETAIL_HISTORY_ID
, PLD.NEW_LEASE_CHANGE_ID
, 'N' CURRENT_FLAG
, PLDT.GROUPING_RULE_ID GROUPING_RULE_ID
, PPGR.NAME INV_GROUP_NAME
FROM FND_USER FNR
, PN_LEASES_ALL PNL
, PN_LEASE_DETAILS_HISTORY PLD
, PN_LEASE_DETAILS_ALL PLDT
, PN_PAY_GROUP_RULES PPGR
WHERE PNL.LEASE_ID = PLD.LEASE_ID
AND PNL.LEASE_ID = PLDT.LEASE_ID
AND FNR.USER_ID = PLD.RESPONSIBLE_USER
AND PPGR.GROUPING_RULE_ID (+) = PLDT.GROUPING_RULE_ID

Columns

Name
ROW_ID
LEASE_DETAIL_ID
LEASE_CHANGE_ID
LEASE_ID
LEASE_NAME
LEASE_NUMBER
LEASE_STATUS
RESPONSIBLE_USER_ID
USER_RESPONSIBLE
EXPENSE_ACCOUNT_ID
RECEIVABLE_ACCOUNT_ID
ACCRUAL_ACCOUNT_ID
TERM_TEMPLATE_ID
LEASE_EXECUTION_DATE
LEASE_COMMENCEMENT_DATE
LEASE_TERMINATION_DATE
LEASE_EXTENSION_END_DATE
LEASE_TERM
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
PAYMENT_TERM_RULE
DETAIL_HISTORY_ID
NEW_LEASE_CHANGE_ID
CURRENT_FLAG
GROUPING_RULE_ID
INV_GROUP_NAME