View: PN_LEASES_V

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

View Text

SELECT LEASE.ROWID ROW_ID
, LEASE.LEASE_ID LEASE_ID
, LEASE.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LEASE.LAST_UPDATED_BY LAST_UPDATED_BY
, LEASE.CREATION_DATE CREATION_DATE
, LEASE.CREATED_BY CREATED_BY
, LEASE.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LEASE.NAME LEASE_NAME
, LEASE.LEASE_NUM LEASE_NUMBER
, LEASE.PARENT_LEASE_ID PARENT_LEASE_ID
, LEASE.LEASE_TYPE_CODE LEASE_TYPE_CODE
, LEASE.LEASE_CLASS_CODE LEASE_CLASS_CODE
, LEASE.PAYMENT_TERM_PRORATION_RULE PAYMENT_TERM_RULE
, LEASE.COMMENTS COMMENTS
, LEASE.STATUS STATUS
, LEASE.LEASE_STATUS LEASE_STATUS
, LEASE.LOCATION_ID LOCATION_ID
, LEASE.CUSTOMER_ID CUSTOMER_ID
, HZP.PARTY_NAME CUSTOMER_NAME
, HCA.ACCOUNT_NUMBER CUSTOMER_NUMBER
, LDET.LEASE_DETAIL_ID LEASE_DETAIL_ID
, LDET.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, LDET.ATTRIBUTE1 ATTRIBUTE1
, LDET.ATTRIBUTE2 ATTRIBUTE2
, LDET.ATTRIBUTE3 ATTRIBUTE3
, LDET.ATTRIBUTE4 ATTRIBUTE4
, LDET.ATTRIBUTE5 ATTRIBUTE5
, LDET.ATTRIBUTE6 ATTRIBUTE6
, LDET.ATTRIBUTE7 ATTRIBUTE7
, LDET.ATTRIBUTE8 ATTRIBUTE8
, LDET.ATTRIBUTE9 ATTRIBUTE9
, LDET.ATTRIBUTE10 ATTRIBUTE10
, LDET.ATTRIBUTE11 ATTRIBUTE11
, LDET.ATTRIBUTE12 ATTRIBUTE12
, LDET.ATTRIBUTE13 ATTRIBUTE13
, LDET.ATTRIBUTE14 ATTRIBUTE14
, LDET.ATTRIBUTE15 ATTRIBUTE15
, LCHANGE.LEASE_CHANGE_ID LEASE_CHANGE_ID
, LDET.EXPENSE_ACCOUNT_ID EXPENSE_ACCOUNT_ID
, LDET.ACCRUAL_ACCOUNT_ID ACCRUAL_ACCOUNT_ID
, LDET.RECEIVABLE_ACCOUNT_ID RECEIVABLE_ACCOUNT_ID
, LDET.TERM_TEMPLATE_ID TERM_TEMPLATE_ID
, LDET.LEASE_COMMENCEMENT_DATE LEASE_COMMENCEMENT_DATE
, LDET.LEASE_TERMINATION_DATE LEASE_TERMINATION_DATE
, LDET.LEASE_EXECUTION_DATE LEASE_EXECUTION_DATE
, LDET.LEASE_EXTENSION_END_DATE LEASE_EXTENSION_END_DATE
, (TRUNC(LDET.LEASE_TERMINATION_DATE) - TRUNC(LDET.LEASE_COMMENCEMENT_DATE) + 1) LEASE_TERM
, LEASE.ABSTRACTED_BY_USER ABSTRACTED_BY_USER_ID
, FNA.USER_NAME USER_ABSTRACTED
, LDET.RESPONSIBLE_USER RESPONSIBLE_USER_ID
, FNR.USER_NAME USER_RESPONSIBLE
, LOOK.MEANING LEASE_TYPE
, LOOK2.MEANING LEASE_CLASS
, MLEASE.LEASE_NUM PARENT_LEASE_NUMBER
, MLEASE.NAME PARENT_LEASE_NAME
, LDET.GROUPING_RULE_ID GROUPING_RULE_ID
, PNGR.NAME INV_GROUP_NAME
, LEASE.ORG_ID ORG_ID
FROM PN_LEASES_ALL MLEASE
, PN_LEASE_CHANGES_ALL LCHANGE
, PN_LEASE_DETAILS_ALL LDET
, FND_USER FNA
, FND_USER FNR
, FND_LOOKUPS LOOK
, FND_LOOKUPS LOOK2
, HZ_PARTIES HZP
, HZ_CUST_ACCOUNTS HCA
, PN_LEASES LEASE
, PN_PAY_GROUP_RULES PNGR
WHERE MLEASE.LEASE_ID(+) = LEASE.PARENT_LEASE_ID
AND LCHANGE.LEASE_CHANGE_NUMBER IS NULL
AND LCHANGE.LEASE_ID = LDET.LEASE_ID
AND LDET.LEASE_ID = LEASE.LEASE_ID
AND FNA.USER_ID = LEASE.ABSTRACTED_BY_USER
AND FNR.USER_ID = LDET.RESPONSIBLE_USER
AND LOOK.LOOKUP_TYPE = 'PN_LEASE_TYPE'
AND LOOK.LOOKUP_CODE = LEASE.LEASE_TYPE_CODE
AND LOOK2.LOOKUP_TYPE = 'PN_LEASE_CLASS'
AND LOOK2.LOOKUP_CODE = LEASE.LEASE_CLASS_CODE
AND HCA.CUST_ACCOUNT_ID (+) = LEASE.CUSTOMER_ID
AND HZP.PARTY_ID (+) = HCA.PARTY_ID
AND PNGR.GROUPING_RULE_ID(+) = LDET.GROUPING_RULE_ID

Columns