VIEW: PN.PN_SPACE_ASSIGN_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, SPACE_TYPE SPACE_TYPE, 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, RENTABLE_AREA RENTABLE_AREA, USABLE_AREA USABLE_AREA, ASSIGNABLE_AREA ASSIGNABLE_AREA, COMMON_AREA COMMON_AREA, PERSON_ID PERSON_ID, EMPLOYEE_NAME EMPLOYEE_NAME, COST_CENTER COST_CENTER, EMPLOYEE_NUMBER EMPLOYEE_NUMBER, EMPLOYEE_TYPE EMPLOYEE_TYPE, EMPLOYEE_CATEGORY EMPLOYEE_CATEGORY, EMPLOYEE_POSITION EMPLOYEE_POSITION, EMPLOYEE_PROJECT_NUMBER EMPLOYEE_PROJECT_NUMBER, EMPLOYEE_TASK_NUMBER EMPLOYEE_TASK_NUMBER, EMPLOYEE_ASSIGNED_AREA EMPLOYEE_ASSIGNED_AREA, EMPLOYEE_VACANT_AREA EMPLOYEE_VACANT_AREA, EMPLOYEE_ASSIGNED_FROM EMPLOYEE_ASSIGNED_FROM, EMPLOYEE_ASSIGNED_TO EMPLOYEE_ASSIGNED_TO, CUSTOMER_NAME CUSTOMER_NAME, CUSTOMER_SITE CUSTOMER_SITE, CUSTOMER_CATEGORY CUSTOMER_CATEGORY, CUSTOMER_ACCOUNT CUSTOMER_ACCOUNT, CUSTOMER_PROJECT_NUMBER CUSTOMER_PROJECT_NUMBER, CUSTOMER_TASK_NUMBER CUSTOMER_TASK_NUMBER, CUSTOMER_ASSIGNED_AREA CUSTOMER_ASSIGNED_AREA, CUSTOMER_VACANT_AREA CUSTOMER_VACANT_AREA, CUSTOMER_ASSIGNED_FROM CUSTOMER_ASSIGNED_FROM, CUSTOMER_ASSIGNED_TO CUSTOMER_ASSIGNED_TO, 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_SPACE_ASSIGN_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
, SPACE_TYPE SPACE_TYPE
, 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
, RENTABLE_AREA RENTABLE_AREA
, USABLE_AREA USABLE_AREA
, ASSIGNABLE_AREA ASSIGNABLE_AREA
, COMMON_AREA COMMON_AREA
, PERSON_ID PERSON_ID
, EMPLOYEE_NAME EMPLOYEE_NAME
, COST_CENTER COST_CENTER
, EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, EMPLOYEE_TYPE EMPLOYEE_TYPE
, EMPLOYEE_CATEGORY EMPLOYEE_CATEGORY
, EMPLOYEE_POSITION EMPLOYEE_POSITION
, EMPLOYEE_PROJECT_NUMBER EMPLOYEE_PROJECT_NUMBER
, EMPLOYEE_TASK_NUMBER EMPLOYEE_TASK_NUMBER
, EMPLOYEE_ASSIGNED_AREA EMPLOYEE_ASSIGNED_AREA
, EMPLOYEE_VACANT_AREA EMPLOYEE_VACANT_AREA
, EMPLOYEE_ASSIGNED_FROM EMPLOYEE_ASSIGNED_FROM
, EMPLOYEE_ASSIGNED_TO EMPLOYEE_ASSIGNED_TO
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_SITE CUSTOMER_SITE
, CUSTOMER_CATEGORY CUSTOMER_CATEGORY
, CUSTOMER_ACCOUNT CUSTOMER_ACCOUNT
, CUSTOMER_PROJECT_NUMBER CUSTOMER_PROJECT_NUMBER
, CUSTOMER_TASK_NUMBER CUSTOMER_TASK_NUMBER
, CUSTOMER_ASSIGNED_AREA CUSTOMER_ASSIGNED_AREA
, CUSTOMER_VACANT_AREA CUSTOMER_VACANT_AREA
, CUSTOMER_ASSIGNED_FROM CUSTOMER_ASSIGNED_FROM
, CUSTOMER_ASSIGNED_TO CUSTOMER_ASSIGNED_TO
, 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_SPACE_ASSIGN_LEASE_ITF"