VIEW: PN.PN_LOCATIONS_ITF#

Source

View Text - Preformatted

select BATCH_NAME BATCH_NAME, ENTRY_TYPE ENTRY_TYPE, LOCATION_ID LOCATION_ID, LOCATION_TYPE_LOOKUP_CODE LOCATION_TYPE_LOOKUP_CODE, LOCATION_CODE LOCATION_CODE, BUILDING#1 BUILDING, LEASE_OR_OWNED LEASE_OR_OWNED, FLOOR FLOOR, OFFICE OFFICE, ADDRESS_LINE1 ADDRESS_LINE1, ADDRESS_LINE2 ADDRESS_LINE2, ADDRESS_LINE3 ADDRESS_LINE3, ADDRESS_LINE4 ADDRESS_LINE4, COUNTY COUNTY, CITY CITY, STATE STATE, PROVINCE PROVINCE, ZIP_CODE ZIP_CODE, COUNTRY COUNTRY, ADDRESS_STYLE ADDRESS_STYLE, MAX_CAPACITY MAX_CAPACITY, OPTIMUM_CAPACITY OPTIMUM_CAPACITY, RENTABLE_AREA RENTABLE_AREA, USABLE_AREA USABLE_AREA, ALLOCATE_COST_CENTER_CODE ALLOCATE_COST_CENTER_CODE, UOM_CODE UOM_CODE, PARENT_LOCATION_ID PARENT_LOCATION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ADDR_ATTRIBUTE_CATEGORY ADDR_ATTRIBUTE_CATEGORY, ADDR_ATTRIBUTE1 ADDR_ATTRIBUTE1, ADDR_ATTRIBUTE2 ADDR_ATTRIBUTE2, ADDR_ATTRIBUTE3 ADDR_ATTRIBUTE3, ADDR_ATTRIBUTE4 ADDR_ATTRIBUTE4, ADDR_ATTRIBUTE5 ADDR_ATTRIBUTE5, ADDR_ATTRIBUTE6 ADDR_ATTRIBUTE6, ADDR_ATTRIBUTE7 ADDR_ATTRIBUTE7, ADDR_ATTRIBUTE8 ADDR_ATTRIBUTE8, ADDR_ATTRIBUTE9 ADDR_ATTRIBUTE9, ADDR_ATTRIBUTE10 ADDR_ATTRIBUTE10, ADDR_ATTRIBUTE11 ADDR_ATTRIBUTE11, ADDR_ATTRIBUTE12 ADDR_ATTRIBUTE12, ADDR_ATTRIBUTE13 ADDR_ATTRIBUTE13, ADDR_ATTRIBUTE14 ADDR_ATTRIBUTE14, ADDR_ATTRIBUTE15 ADDR_ATTRIBUTE15, TRANSFERRED_TO_CAD TRANSFERRED_TO_CAD, TRANSFERRED_TO_PN TRANSFERRED_TO_PN, ERROR_MESSAGE ERROR_MESSAGE, SOURCE SOURCE, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, SPACE_TYPE_LOOKUP_CODE SPACE_TYPE_LOOKUP_CODE, GROSS_AREA GROSS_AREA, ASSIGNABLE_AREA ASSIGNABLE_AREA, CLASS CLASS, STATUS_TYPE STATUS_TYPE, SUITE SUITE, COMMON_AREA COMMON_AREA, COMMON_AREA_FLAG COMMON_AREA_FLAG, FUNCTION_TYPE_LOOKUP_CODE FUNCTION_TYPE_LOOKUP_CODE, LOCATION_ALIAS LOCATION_ALIAS, PROPERTY_ID PROPERTY_ID, STANDARD_TYPE_LOOKUP_CODE STANDARD_TYPE_LOOKUP_CODE, ACTIVE_START_DATE ACTIVE_START_DATE, ACTIVE_END_DATE ACTIVE_END_DATE, CHANGE_MODE CHANGE_MODE, CHANGE_DATE CHANGE_DATE, NEW_ACTIVE_START_DATE NEW_ACTIVE_START_DATE, NEW_ACTIVE_END_DATE NEW_ACTIVE_END_DATE, SITE_ID SITE_ID from "PN"."PN_LOCATIONS_ITF"

View Text - HTML Formatted

SELECT BATCH_NAME BATCH_NAME
, ENTRY_TYPE ENTRY_TYPE
, LOCATION_ID LOCATION_ID
, LOCATION_TYPE_LOOKUP_CODE LOCATION_TYPE_LOOKUP_CODE
, LOCATION_CODE LOCATION_CODE
, BUILDING#1 BUILDING
, LEASE_OR_OWNED LEASE_OR_OWNED
, FLOOR FLOOR
, OFFICE OFFICE
, ADDRESS_LINE1 ADDRESS_LINE1
, ADDRESS_LINE2 ADDRESS_LINE2
, ADDRESS_LINE3 ADDRESS_LINE3
, ADDRESS_LINE4 ADDRESS_LINE4
, COUNTY COUNTY
, CITY CITY
, STATE STATE
, PROVINCE PROVINCE
, ZIP_CODE ZIP_CODE
, COUNTRY COUNTRY
, ADDRESS_STYLE ADDRESS_STYLE
, MAX_CAPACITY MAX_CAPACITY
, OPTIMUM_CAPACITY OPTIMUM_CAPACITY
, RENTABLE_AREA RENTABLE_AREA
, USABLE_AREA USABLE_AREA
, ALLOCATE_COST_CENTER_CODE ALLOCATE_COST_CENTER_CODE
, UOM_CODE UOM_CODE
, PARENT_LOCATION_ID PARENT_LOCATION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ADDR_ATTRIBUTE_CATEGORY ADDR_ATTRIBUTE_CATEGORY
, ADDR_ATTRIBUTE1 ADDR_ATTRIBUTE1
, ADDR_ATTRIBUTE2 ADDR_ATTRIBUTE2
, ADDR_ATTRIBUTE3 ADDR_ATTRIBUTE3
, ADDR_ATTRIBUTE4 ADDR_ATTRIBUTE4
, ADDR_ATTRIBUTE5 ADDR_ATTRIBUTE5
, ADDR_ATTRIBUTE6 ADDR_ATTRIBUTE6
, ADDR_ATTRIBUTE7 ADDR_ATTRIBUTE7
, ADDR_ATTRIBUTE8 ADDR_ATTRIBUTE8
, ADDR_ATTRIBUTE9 ADDR_ATTRIBUTE9
, ADDR_ATTRIBUTE10 ADDR_ATTRIBUTE10
, ADDR_ATTRIBUTE11 ADDR_ATTRIBUTE11
, ADDR_ATTRIBUTE12 ADDR_ATTRIBUTE12
, ADDR_ATTRIBUTE13 ADDR_ATTRIBUTE13
, ADDR_ATTRIBUTE14 ADDR_ATTRIBUTE14
, ADDR_ATTRIBUTE15 ADDR_ATTRIBUTE15
, TRANSFERRED_TO_CAD TRANSFERRED_TO_CAD
, TRANSFERRED_TO_PN TRANSFERRED_TO_PN
, ERROR_MESSAGE ERROR_MESSAGE
, SOURCE SOURCE
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SPACE_TYPE_LOOKUP_CODE SPACE_TYPE_LOOKUP_CODE
, GROSS_AREA GROSS_AREA
, ASSIGNABLE_AREA ASSIGNABLE_AREA
, CLASS CLASS
, STATUS_TYPE STATUS_TYPE
, SUITE SUITE
, COMMON_AREA COMMON_AREA
, COMMON_AREA_FLAG COMMON_AREA_FLAG
, FUNCTION_TYPE_LOOKUP_CODE FUNCTION_TYPE_LOOKUP_CODE
, LOCATION_ALIAS LOCATION_ALIAS
, PROPERTY_ID PROPERTY_ID
, STANDARD_TYPE_LOOKUP_CODE STANDARD_TYPE_LOOKUP_CODE
, ACTIVE_START_DATE ACTIVE_START_DATE
, ACTIVE_END_DATE ACTIVE_END_DATE
, CHANGE_MODE CHANGE_MODE
, CHANGE_DATE CHANGE_DATE
, NEW_ACTIVE_START_DATE NEW_ACTIVE_START_DATE
, NEW_ACTIVE_END_DATE NEW_ACTIVE_END_DATE
, SITE_ID SITE_ID
FROM "PN"."PN_LOCATIONS_ITF"