VIEW: APPS.PN_TRX_LEASE_REVENUE

Source

View Text - Preformatted

SELECT item.payment_item_id payment_item_id, lease.lease_num lease_number, lease.name lease_name, substr(cust.party_name,1,240) 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 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 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'

View Text - HTML Formatted

SELECT ITEM.PAYMENT_ITEM_ID PAYMENT_ITEM_ID
, LEASE.LEASE_NUM LEASE_NUMBER
, LEASE.NAME LEASE_NAME
, SUBSTR(CUST.PARTY_NAME
, 1
, 240) 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 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 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'