VIEW: APPS.PN_TRX_LEASE_EXPENSE

Source

View Text - Preformatted

SELECT distinct 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 loc.active_start_date (+) <= term.start_date AND loc.active_end_date (+) >= term.end_date 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'

View Text - HTML Formatted

SELECT DISTINCT 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 LOC.ACTIVE_START_DATE (+) <= TERM.START_DATE
AND LOC.ACTIVE_END_DATE (+) >= TERM.END_DATE
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'