VIEW: APPS.PN_INDEX_LEASES_V

Source

View Text - Preformatted

SELECT pil.rowid row_id, pil.org_id, pl.lease_id, pl.name lease_name, pl.lease_num, pil.index_lease_id, pil.index_lease_number, pihh.index_id, pihh.name index_type, pil.location_id, pil.term_template_id, (SELECT plo.location_code FROM pn_locations plo WHERE plo.location_id(+) = pil.location_id AND rownum =1) location_code, pl.lease_class_code, pld.lease_commencement_date, pld.lease_termination_date, fu.user_name user_responsible, fu.user_id abstracted_by, pil.commencement_date index_commencement_date, pil.termination_date index_termination_date, pil.creation_date, pil.created_by, pil.last_update_date, pil.last_updated_by, pil.last_update_login, pil.attribute_category, pil.attribute1, pil.attribute2, pil.attribute3, pil.attribute4, pil.attribute5, pil.attribute6, pil.attribute7, pil.attribute8, pil.attribute9, pil.attribute10, pil.attribute11, pil.attribute12, pil.attribute13, pil.attribute14, pil.attribute15, pil.assessment_date, pil.assessment_interval, pil.spread_frequency, pil.relationship_default, pil.basis_percent_default, pil.initial_basis, pil.base_index, pil.index_finder_method, pil.negative_rent_type, pil.increase_on, ptlook.meaning increase_on_type, pil.basis_type, pil.reference_period, pil.base_year, pil.leased_area, pil.rounding_flag, pil.aggregation_flag, pil.gross_flag, pil.base_index_line_id, pil.index_finder_months, pil.currency_code, pil.carry_forward_flag, pil.agreement_category, pil.agreement_attribute1, pil.agreement_attribute2, pil.agreement_attribute3, pil.agreement_attribute4, pil.agreement_attribute5, pil.agreement_attribute6, pil.agreement_attribute7, pil.agreement_attribute8, pil.agreement_attribute9, pil.agreement_attribute10, pil.agreement_attribute11, pil.agreement_attribute12, pil.agreement_attribute13, pil.agreement_attribute14, pil.agreement_attribute15, nvl(pil.retain_initial_basis_flag, 'N'), nvl(pil.index_multiplier,1), pil.vr_nbp_flag, pld.lease_extension_end_date, nvl(pil.proration_rule,'NO_PRORATION'), pil.proration_period_start_date FROM pn_leases_all pl, pn_index_leases pil, pn_index_history_headers pihh, fnd_lookups ptlook, pn_lease_details_all pld, fnd_user fu WHERE pl.lease_id = pil.lease_id AND pihh.index_id = pil.index_id AND pl.lease_id = pld.lease_id AND pil.abstracted_by = fu.user_id AND ptlook.lookup_type (+) = 'PN_PAYMENT_TERM_TYPE' AND ptlook.lookup_code (+) = pil.increase_on

View Text - HTML Formatted

SELECT PIL.ROWID ROW_ID
, PIL.ORG_ID
, PL.LEASE_ID
, PL.NAME LEASE_NAME
, PL.LEASE_NUM
, PIL.INDEX_LEASE_ID
, PIL.INDEX_LEASE_NUMBER
, PIHH.INDEX_ID
, PIHH.NAME INDEX_TYPE
, PIL.LOCATION_ID
, PIL.TERM_TEMPLATE_ID
, (SELECT PLO.LOCATION_CODE
FROM PN_LOCATIONS PLO
WHERE PLO.LOCATION_ID(+) = PIL.LOCATION_ID
AND ROWNUM =1) LOCATION_CODE
, PL.LEASE_CLASS_CODE
, PLD.LEASE_COMMENCEMENT_DATE
, PLD.LEASE_TERMINATION_DATE
, FU.USER_NAME USER_RESPONSIBLE
, FU.USER_ID ABSTRACTED_BY
, PIL.COMMENCEMENT_DATE INDEX_COMMENCEMENT_DATE
, PIL.TERMINATION_DATE INDEX_TERMINATION_DATE
, PIL.CREATION_DATE
, PIL.CREATED_BY
, PIL.LAST_UPDATE_DATE
, PIL.LAST_UPDATED_BY
, PIL.LAST_UPDATE_LOGIN
, PIL.ATTRIBUTE_CATEGORY
, PIL.ATTRIBUTE1
, PIL.ATTRIBUTE2
, PIL.ATTRIBUTE3
, PIL.ATTRIBUTE4
, PIL.ATTRIBUTE5
, PIL.ATTRIBUTE6
, PIL.ATTRIBUTE7
, PIL.ATTRIBUTE8
, PIL.ATTRIBUTE9
, PIL.ATTRIBUTE10
, PIL.ATTRIBUTE11
, PIL.ATTRIBUTE12
, PIL.ATTRIBUTE13
, PIL.ATTRIBUTE14
, PIL.ATTRIBUTE15
, PIL.ASSESSMENT_DATE
, PIL.ASSESSMENT_INTERVAL
, PIL.SPREAD_FREQUENCY
, PIL.RELATIONSHIP_DEFAULT
, PIL.BASIS_PERCENT_DEFAULT
, PIL.INITIAL_BASIS
, PIL.BASE_INDEX
, PIL.INDEX_FINDER_METHOD
, PIL.NEGATIVE_RENT_TYPE
, PIL.INCREASE_ON
, PTLOOK.MEANING INCREASE_ON_TYPE
, PIL.BASIS_TYPE
, PIL.REFERENCE_PERIOD
, PIL.BASE_YEAR
, PIL.LEASED_AREA
, PIL.ROUNDING_FLAG
, PIL.AGGREGATION_FLAG
, PIL.GROSS_FLAG
, PIL.BASE_INDEX_LINE_ID
, PIL.INDEX_FINDER_MONTHS
, PIL.CURRENCY_CODE
, PIL.CARRY_FORWARD_FLAG
, PIL.AGREEMENT_CATEGORY
, PIL.AGREEMENT_ATTRIBUTE1
, PIL.AGREEMENT_ATTRIBUTE2
, PIL.AGREEMENT_ATTRIBUTE3
, PIL.AGREEMENT_ATTRIBUTE4
, PIL.AGREEMENT_ATTRIBUTE5
, PIL.AGREEMENT_ATTRIBUTE6
, PIL.AGREEMENT_ATTRIBUTE7
, PIL.AGREEMENT_ATTRIBUTE8
, PIL.AGREEMENT_ATTRIBUTE9
, PIL.AGREEMENT_ATTRIBUTE10
, PIL.AGREEMENT_ATTRIBUTE11
, PIL.AGREEMENT_ATTRIBUTE12
, PIL.AGREEMENT_ATTRIBUTE13
, PIL.AGREEMENT_ATTRIBUTE14
, PIL.AGREEMENT_ATTRIBUTE15
, NVL(PIL.RETAIN_INITIAL_BASIS_FLAG
, 'N')
, NVL(PIL.INDEX_MULTIPLIER
, 1)
, PIL.VR_NBP_FLAG
, PLD.LEASE_EXTENSION_END_DATE
, NVL(PIL.PRORATION_RULE
, 'NO_PRORATION')
, PIL.PRORATION_PERIOD_START_DATE
FROM PN_LEASES_ALL PL
, PN_INDEX_LEASES PIL
, PN_INDEX_HISTORY_HEADERS PIHH
, FND_LOOKUPS PTLOOK
, PN_LEASE_DETAILS_ALL PLD
, FND_USER FU
WHERE PL.LEASE_ID = PIL.LEASE_ID
AND PIHH.INDEX_ID = PIL.INDEX_ID
AND PL.LEASE_ID = PLD.LEASE_ID
AND PIL.ABSTRACTED_BY = FU.USER_ID
AND PTLOOK.LOOKUP_TYPE (+) = 'PN_PAYMENT_TERM_TYPE'
AND PTLOOK.LOOKUP_CODE (+) = PIL.INCREASE_ON