Product: | PN - Property Manager |
---|---|
Description: | Form view for table PN_INDEX_LEASES_ALL |
Implementation/DBA Data: | APPS.PN_INDEX_LEASES_V |
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')
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