VIEW: PN.PN_SPACE_ASSIGN_LOC_ITF#

Source

View Text - Preformatted

select 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, 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_ASSIGN_LOC_ITF"

View Text - HTML Formatted

SELECT 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
, 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_ASSIGN_LOC_ITF"