View: PN_TRX_LEASE_REVENUE

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

View Text

SELECT ITEM.PAYMENT_ITEM_ID PAYMENT_ITEM_ID
, LEASE.LEASE_NUM LEASE_NUMBER
, LEASE.NAME LEASE_NAME
, CUST.PARTY_NAME CUSTOMER_NAME
, CUST_SITE.LOCATION CUSTOMER_SITE
, TERM_PURPOSE_LKUP.MEANING PAYMENT_PURPOSE
, TERM_TYPE_LKUP.MEANING PAYMENT_TYPE
, LOC.LOCATION_CODE LOCATION_CODE
FROM PN_PAYMENT_ITEMS ITEM
, PN_PAYMENT_TERMS_ALL TERM
, PN_LEASES_ALL LEASE
, PN_LOCATIONS_ALL LOC
, FND_LOOKUPS TERM_PURPOSE_LKUP
, FND_LOOKUPS TERM_TYPE_LKUP
, HZ_PARTIES CUST
, HZ_CUST_ACCOUNTS_ALL CUST_ACCT
, HZ_CUST_SITE_USES_ALL CUST_SITE
WHERE ITEM.PAYMENT_TERM_ID = TERM.PAYMENT_TERM_ID
AND LEASE.LEASE_ID = TERM.LEASE_ID
AND LEASE.LEASE_CLASS_CODE <> 'DIRECT'
AND LOC.LOCATION_ID (+) = TERM.LOCATION_ID
AND TERM_TYPE_LKUP.LOOKUP_TYPE = 'PN_PAYMENT_TERM_TYPE'
AND TERM_TYPE_LKUP.LOOKUP_CODE = TERM.PAYMENT_TERM_TYPE_CODE
AND TERM_PURPOSE_LKUP.LOOKUP_TYPE = 'PN_PAYMENT_PURPOSE_TYPE'
AND TERM_PURPOSE_LKUP.LOOKUP_CODE = TERM.PAYMENT_PURPOSE_CODE
AND CUST.PARTY_ID = CUST_ACCT.PARTY_ID
AND TERM.CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID
AND TERM.CUSTOMER_SITE_USE_ID = CUST_SITE.SITE_USE_ID
AND ITEM.PAYMENT_ITEM_TYPE_LOOKUP_CODE = 'NORMALIZED'

Columns