VIEW: PN.PN_LEASE_OPTIONS_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, LEASE_EXECUTION_DATE LEASE_EXECUTION_DATE, LEASE_TERM LEASE_TERM, LEASE_CLASS LEASE_CLASS, LEASE_RESPONSIBLE_USER LEASE_RESPONSIBLE_USER, LEASE_STATUS LEASE_STATUS, LEASE_TYPE LEASE_TYPE, ESTIMATED_OCCUPANCY_DATE ESTIMATED_OCCUPANCY_DATE, ACTUAL_OCCUPANCY_DATE ACTUAL_OCCUPANCY_DATE, LOCATION_ID LOCATION_ID, LOCATION_TYPE LOCATION_TYPE, LOCATION_NAME LOCATION_NAME, LOCATION_CODE LOCATION_CODE, SPACE_TYPE SPACE_TYPE, REGION REGION, PROPERTY_NAME PROPERTY_NAME, BUILDING_OR_LAND_NAME BUILDING_OR_LAND_NAME, FLOOR_OR_PARCEL_NAME FLOOR_OR_PARCEL_NAME, OFFICE_OR_SECTION_NAME OFFICE_OR_SECTION_NAME, ADDRESS ADDRESS, COUNTY COUNTY, CITY CITY, STATE STATE, PROVINCE PROVINCE, ZIP_CODE ZIP_CODE, COUNTRY COUNTRY, GROSS_AREA GROSS_AREA, RENTABLE_AREA RENTABLE_AREA, USABLE_AREA USABLE_AREA, TENURE TENURE, OPTION_ID OPTION_ID, OPTION_TYPE OPTION_TYPE, OPTION_STATUS OPTION_STATUS, OPTION_TERM OPTION_TERM, REFERENCE REFERENCE, OPTION_NOTICE_REQD OPTION_NOTICE_REQD, OPTION_ACTION_DATE OPTION_ACTION_DATE, OPTION_SIZE OPTION_SIZE, OPTION_COST OPTION_COST, UOM_CODE UOM_CODE, OPTION_AREA_CHANGE OPTION_AREA_CHANGE, OPTION_CURRENCY OPTION_CURRENCY, OPTION_EXER_START_DATE OPTION_EXER_START_DATE, OPTION_EXER_END_DATE OPTION_EXER_END_DATE, OPTION_COMM_DATE OPTION_COMM_DATE, OPTION_EXP_DATE OPTION_EXP_DATE, OPTION_COMMENTS OPTION_COMMENTS, TEN_ATTRIBUTE_CATEGORY TEN_ATTRIBUTE_CATEGORY, TEN_ATTRIBUTE1 TEN_ATTRIBUTE1, TEN_ATTRIBUTE2 TEN_ATTRIBUTE2, TEN_ATTRIBUTE3 TEN_ATTRIBUTE3, TEN_ATTRIBUTE4 TEN_ATTRIBUTE4, TEN_ATTRIBUTE5 TEN_ATTRIBUTE5, TEN_ATTRIBUTE6 TEN_ATTRIBUTE6, TEN_ATTRIBUTE7 TEN_ATTRIBUTE7, TEN_ATTRIBUTE8 TEN_ATTRIBUTE8, TEN_ATTRIBUTE9 TEN_ATTRIBUTE9, TEN_ATTRIBUTE10 TEN_ATTRIBUTE10, TEN_ATTRIBUTE11 TEN_ATTRIBUTE11, TEN_ATTRIBUTE12 TEN_ATTRIBUTE12, TEN_ATTRIBUTE13 TEN_ATTRIBUTE13, TEN_ATTRIBUTE14 TEN_ATTRIBUTE14, TEN_ATTRIBUTE15 TEN_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_LEASE_OPTIONS_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
, LEASE_EXECUTION_DATE LEASE_EXECUTION_DATE
, LEASE_TERM LEASE_TERM
, LEASE_CLASS LEASE_CLASS
, LEASE_RESPONSIBLE_USER LEASE_RESPONSIBLE_USER
, LEASE_STATUS LEASE_STATUS
, LEASE_TYPE LEASE_TYPE
, ESTIMATED_OCCUPANCY_DATE ESTIMATED_OCCUPANCY_DATE
, ACTUAL_OCCUPANCY_DATE ACTUAL_OCCUPANCY_DATE
, LOCATION_ID LOCATION_ID
, LOCATION_TYPE LOCATION_TYPE
, LOCATION_NAME LOCATION_NAME
, LOCATION_CODE LOCATION_CODE
, SPACE_TYPE SPACE_TYPE
, REGION REGION
, PROPERTY_NAME PROPERTY_NAME
, BUILDING_OR_LAND_NAME BUILDING_OR_LAND_NAME
, FLOOR_OR_PARCEL_NAME FLOOR_OR_PARCEL_NAME
, OFFICE_OR_SECTION_NAME OFFICE_OR_SECTION_NAME
, ADDRESS ADDRESS
, COUNTY COUNTY
, CITY CITY
, STATE STATE
, PROVINCE PROVINCE
, ZIP_CODE ZIP_CODE
, COUNTRY COUNTRY
, GROSS_AREA GROSS_AREA
, RENTABLE_AREA RENTABLE_AREA
, USABLE_AREA USABLE_AREA
, TENURE TENURE
, OPTION_ID OPTION_ID
, OPTION_TYPE OPTION_TYPE
, OPTION_STATUS OPTION_STATUS
, OPTION_TERM OPTION_TERM
, REFERENCE REFERENCE
, OPTION_NOTICE_REQD OPTION_NOTICE_REQD
, OPTION_ACTION_DATE OPTION_ACTION_DATE
, OPTION_SIZE OPTION_SIZE
, OPTION_COST OPTION_COST
, UOM_CODE UOM_CODE
, OPTION_AREA_CHANGE OPTION_AREA_CHANGE
, OPTION_CURRENCY OPTION_CURRENCY
, OPTION_EXER_START_DATE OPTION_EXER_START_DATE
, OPTION_EXER_END_DATE OPTION_EXER_END_DATE
, OPTION_COMM_DATE OPTION_COMM_DATE
, OPTION_EXP_DATE OPTION_EXP_DATE
, OPTION_COMMENTS OPTION_COMMENTS
, TEN_ATTRIBUTE_CATEGORY TEN_ATTRIBUTE_CATEGORY
, TEN_ATTRIBUTE1 TEN_ATTRIBUTE1
, TEN_ATTRIBUTE2 TEN_ATTRIBUTE2
, TEN_ATTRIBUTE3 TEN_ATTRIBUTE3
, TEN_ATTRIBUTE4 TEN_ATTRIBUTE4
, TEN_ATTRIBUTE5 TEN_ATTRIBUTE5
, TEN_ATTRIBUTE6 TEN_ATTRIBUTE6
, TEN_ATTRIBUTE7 TEN_ATTRIBUTE7
, TEN_ATTRIBUTE8 TEN_ATTRIBUTE8
, TEN_ATTRIBUTE9 TEN_ATTRIBUTE9
, TEN_ATTRIBUTE10 TEN_ATTRIBUTE10
, TEN_ATTRIBUTE11 TEN_ATTRIBUTE11
, TEN_ATTRIBUTE12 TEN_ATTRIBUTE12
, TEN_ATTRIBUTE13 TEN_ATTRIBUTE13
, TEN_ATTRIBUTE14 TEN_ATTRIBUTE14
, TEN_ATTRIBUTE15 TEN_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_LEASE_OPTIONS_ITF"