eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: PN.PN_SPACE_UTIL_LEASE_ITF#

Source

View Text - Preformatted


select LEASE_ID LEASE_ID, LEASE_NAME LEASE_NAME, LEASE_NUMBER LEASE_NUMBER, LEASE_COMMENCEMENT_DATE LEASE_COMMENCEMENT_DATE, LEASE_TERMINATION_DATE LEASE_TERMINATION_DATE, LOCATION_ID LOCATION_ID, LOCATION_TYPE LOCATION_TYPE, LOCATION_NAME LOCATION_NAME, LOCATION_CODE LOCATION_CODE, RENTABLE_AREA RENTABLE_AREA, USABLE_AREA USABLE_AREA, ASSIGNABLE_AREA ASSIGNABLE_AREA, COMMON_AREA COMMON_AREA, MAXIMUM_OCCUPANCY MAXIMUM_OCCUPANCY, OPTIMUM_OCCUPANCY OPTIMUM_OCCUPANCY, MAXIMUM_VACANCY MAXIMUM_VACANCY, OPTIMUM_VACANCY OPTIMUM_VACANCY, USAGE_TYPE USAGE_TYPE, VACANT_AREA VACANT_AREA, ASSIGNED_AREA ASSIGNED_AREA, UTILIZED UTILIZED, PROPERTY_CODE PROPERTY_CODE, PROPERTY_NAME PROPERTY_NAME, BUILDING_LOCATION_CODE BUILDING_LOCATION_CODE, BUILDING_OR_LAND_NAME BUILDING_OR_LAND_NAME, FLOOR_LOCATION_CODE FLOOR_LOCATION_CODE, FLOOR_OR_PARCEL_NAME FLOOR_OR_PARCEL_NAME, OFFICE_LOCATION_CODE OFFICE_LOCATION_CODE, OFFICE_OR_SECTION_NAME OFFICE_OR_SECTION_NAME, LOC_ATTRIBUTE_CATEGORY LOC_ATTRIBUTE_CATEGORY, LOC_ATTRIBUTE1 LOC_ATTRIBUTE1, LOC_ATTRIBUTE2 LOC_ATTRIBUTE2, LOC_ATTRIBUTE3 LOC_ATTRIBUTE3, LOC_ATTRIBUTE4 LOC_ATTRIBUTE4, LOC_ATTRIBUTE5 LOC_ATTRIBUTE5, LOC_ATTRIBUTE6 LOC_ATTRIBUTE6, LOC_ATTRIBUTE7 LOC_ATTRIBUTE7, LOC_ATTRIBUTE8 LOC_ATTRIBUTE8, LOC_ATTRIBUTE9 LOC_ATTRIBUTE9, LOC_ATTRIBUTE10 LOC_ATTRIBUTE10, LOC_ATTRIBUTE11 LOC_ATTRIBUTE11, LOC_ATTRIBUTE12 LOC_ATTRIBUTE12, LOC_ATTRIBUTE13 LOC_ATTRIBUTE13, LOC_ATTRIBUTE14 LOC_ATTRIBUTE14, LOC_ATTRIBUTE15 LOC_ATTRIBUTE15, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, REQUEST_ID REQUEST_ID from "PN"."PN_SPACE_UTIL_LEASE_ITF"

View Text - HTML Formatted

SELECT LEASE_ID LEASE_ID
, LEASE_NAME LEASE_NAME
, LEASE_NUMBER LEASE_NUMBER
, LEASE_COMMENCEMENT_DATE LEASE_COMMENCEMENT_DATE
, LEASE_TERMINATION_DATE LEASE_TERMINATION_DATE
, LOCATION_ID LOCATION_ID
, LOCATION_TYPE LOCATION_TYPE
, LOCATION_NAME LOCATION_NAME
, LOCATION_CODE LOCATION_CODE
, RENTABLE_AREA RENTABLE_AREA
, USABLE_AREA USABLE_AREA
, ASSIGNABLE_AREA ASSIGNABLE_AREA
, COMMON_AREA COMMON_AREA
, MAXIMUM_OCCUPANCY MAXIMUM_OCCUPANCY
, OPTIMUM_OCCUPANCY OPTIMUM_OCCUPANCY
, MAXIMUM_VACANCY MAXIMUM_VACANCY
, OPTIMUM_VACANCY OPTIMUM_VACANCY
, USAGE_TYPE USAGE_TYPE
, VACANT_AREA VACANT_AREA
, ASSIGNED_AREA ASSIGNED_AREA
, UTILIZED UTILIZED
, PROPERTY_CODE PROPERTY_CODE
, PROPERTY_NAME PROPERTY_NAME
, BUILDING_LOCATION_CODE BUILDING_LOCATION_CODE
, BUILDING_OR_LAND_NAME BUILDING_OR_LAND_NAME
, FLOOR_LOCATION_CODE FLOOR_LOCATION_CODE
, FLOOR_OR_PARCEL_NAME FLOOR_OR_PARCEL_NAME
, OFFICE_LOCATION_CODE OFFICE_LOCATION_CODE
, OFFICE_OR_SECTION_NAME OFFICE_OR_SECTION_NAME
, LOC_ATTRIBUTE_CATEGORY LOC_ATTRIBUTE_CATEGORY
, LOC_ATTRIBUTE1 LOC_ATTRIBUTE1
, LOC_ATTRIBUTE2 LOC_ATTRIBUTE2
, LOC_ATTRIBUTE3 LOC_ATTRIBUTE3
, LOC_ATTRIBUTE4 LOC_ATTRIBUTE4
, LOC_ATTRIBUTE5 LOC_ATTRIBUTE5
, LOC_ATTRIBUTE6 LOC_ATTRIBUTE6
, LOC_ATTRIBUTE7 LOC_ATTRIBUTE7
, LOC_ATTRIBUTE8 LOC_ATTRIBUTE8
, LOC_ATTRIBUTE9 LOC_ATTRIBUTE9
, LOC_ATTRIBUTE10 LOC_ATTRIBUTE10
, LOC_ATTRIBUTE11 LOC_ATTRIBUTE11
, LOC_ATTRIBUTE12 LOC_ATTRIBUTE12
, LOC_ATTRIBUTE13 LOC_ATTRIBUTE13
, LOC_ATTRIBUTE14 LOC_ATTRIBUTE14
, LOC_ATTRIBUTE15 LOC_ATTRIBUTE15
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, REQUEST_ID REQUEST_ID
FROM "PN"."PN_SPACE_UTIL_LEASE_ITF"