View: PN_LEASE_CHANGES_V

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

View Text

SELECT LCHANGE.ROWID ROW_ID
, LCHANGE.LEASE_CHANGE_ID LEASE_CHANGE_ID
, LCHANGE.LEASE_ID LEASE_ID
, LCHANGE.LEASE_TRANSACTION_ID LEASE_TRANSACTION_ID
, LCHANGE.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LCHANGE.LAST_UPDATED_BY LAST_UPDATED_BY
, LCHANGE.CREATION_DATE CREATION_DATE
, LCHANGE.CREATED_BY CREATED_BY
, LCHANGE.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LCHANGE.LEASE_CHANGE_NUMBER LEASE_CHANGE_NUMBER
, LCHANGE.LEASE_CHANGE_NAME LEASE_CHANGE_NAME
, LCHANGE.ABSTRACTED_BY_USER ABSTRACTED_BY_USER_ID
, FNA.USER_NAME USER_ABSTRACTED
, LCHANGE.RESPONSIBLE_USER RESPONSIBLE_USER_ID
, FNR.USER_NAME USER_RESPONSIBLE
, LCHANGE.CHANGE_EXECUTION_DATE CHANGE_EXECUTION_DATE
, LCHANGE.CHANGE_COMMENCEMENT_DATE CHANGE_COMMENCEMENT_DATE
, LCHANGE.CHANGE_TERMINATION_DATE CHANGE_TERMINATION_DATE
, LCHANGE.CHANGE_TYPE_LOOKUP_CODE CHANGE_TYPE_LOOKUP_CODE
, (TRUNC(LCHANGE.CHANGE_TERMINATION_DATE) - TRUNC(LCHANGE.CHANGE_COMMENCEMENT_DATE) + 1) AMENDMENT_TERM
, LCHANGE.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, LCHANGE.ATTRIBUTE1 ATTRIBUTE1
, LCHANGE.ATTRIBUTE2 ATTRIBUTE2
, LCHANGE.ATTRIBUTE3 ATTRIBUTE3
, LCHANGE.ATTRIBUTE4 ATTRIBUTE4
, LCHANGE.ATTRIBUTE5 ATTRIBUTE5
, LCHANGE.ATTRIBUTE6 ATTRIBUTE6
, LCHANGE.ATTRIBUTE7 ATTRIBUTE7
, LCHANGE.ATTRIBUTE8 ATTRIBUTE8
, LCHANGE.ATTRIBUTE9 ATTRIBUTE9
, LCHANGE.ATTRIBUTE10 ATTRIBUTE10
, LCHANGE.ATTRIBUTE11 ATTRIBUTE11
, LCHANGE.ATTRIBUTE12 ATTRIBUTE12
, LCHANGE.ATTRIBUTE13 ATTRIBUTE13
, LCHANGE.ATTRIBUTE14 ATTRIBUTE14
, LCHANGE.ATTRIBUTE15 ATTRIBUTE15
, LEASE.STATUS STATUS
, LEASE.LEASE_STATUS LEASE_STATUS
, LEASE.LEASE_NUM LEASE_NUMBER
, LEASE.NAME LEASE_NAME
, PLT.TRANSACTION_TYPE TRANSACTION_TYPE_CODE
, FLV.MEANING TRANSACTION_TYPE
, FLL.MEANING LEASE_TYPE
, LEASE.LEASE_TYPE_CODE LEASE_TYPE_CODE
, LEASE.LEASE_CLASS_CODE LEASE_CLASS_CODE
, FLC.MEANING LEASE_CLASS
, LEASE.LOCATION_ID LOCATION_ID
, LEASE.CUSTOMER_ID CUSTOMER_ID
, HZP.PARTY_NAME CUSTOMER_NAME
, HCA.ACCOUNT_NUMBER CUSTOMER_NUMBER
, LEASE.ORG_ID ORG_ID
FROM FND_USER FNA
, FND_USER FNR
, FND_LOOKUPS FLV
, FND_LOOKUPS FLL
, FND_LOOKUPS FLC
, HZ_PARTIES HZP
, HZ_CUST_ACCOUNTS HCA
, PN_LEASES LEASE
, PN_LEASE_TRANSACTIONS_ALL PLT
, PN_LEASE_CHANGES_ALL LCHANGE
WHERE FNA.USER_ID (+) = LCHANGE.ABSTRACTED_BY_USER
AND FNR.USER_ID (+) = LCHANGE.RESPONSIBLE_USER
AND LEASE.LEASE_ID = LCHANGE.LEASE_ID
AND PLT.LEASE_TRANSACTION_ID = LCHANGE.LEASE_TRANSACTION_ID
AND LCHANGE.LEASE_CHANGE_NUMBER IS NOT NULL
AND FLV.LOOKUP_CODE = PLT.TRANSACTION_TYPE
AND FLV.LOOKUP_TYPE = 'PN_LEASE_CHANGE_TYPE'
AND FLL.LOOKUP_CODE = LEASE.LEASE_TYPE_CODE
AND FLL.LOOKUP_TYPE = 'PN_LEASE_TYPE'
AND FLC.LOOKUP_CODE = LEASE.LEASE_CLASS_CODE
AND FLC.LOOKUP_TYPE = 'PN_LEASE_CLASS'
AND HCA.CUST_ACCOUNT_ID (+) = LEASE.CUSTOMER_ID
AND HZP.PARTY_ID (+) = HCA.PARTY_ID

Columns