View: PN_TRX_LEASE_EXPENSE

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

View Text

SELECT ITEM.PAYMENT_ITEM_ID PAYMENT_ITEM_ID
, LEASE.LEASE_NUM LEASE_NUMBER
, LEASE.NAME LEASE_NAME
, SUPPLIER.VENDOR_NAME SUPPLIER_NAME
, SUPPLIER_SITE.VENDOR_SITE_CODE SUPPLIER_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
, PO_VENDORS SUPPLIER
, PO_VENDOR_SITES_ALL SUPPLIER_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 TERM.VENDOR_ID = SUPPLIER.VENDOR_ID
AND TERM.VENDOR_SITE_ID = SUPPLIER_SITE.VENDOR_SITE_ID
AND ITEM.PAYMENT_ITEM_TYPE_LOOKUP_CODE = 'NORMALIZED'

Columns