View: PN_BUILDINGS_V

Product:	PN - Property Manager
Description:	Form view used to view company information.
Implementation/DBA Data:	APPS.PN_BUILDINGS_V

View Text

SELECT LOC.ROWID ROW_ID
, LOC.ORG_ID ORG_ID
, LOC.LOCATION_ID LOCATION_ID
, LOC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LOC.LAST_UPDATED_BY LAST_UPDATED_BY
, LOC.CREATION_DATE CREATION_DATE
, LOC.CREATED_BY CREATED_BY
, LOC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LOC.LOCATION_PARK_ID LOCATION_PARK_ID
, LOC.LOCATION_TYPE_LOOKUP_CODE LOCATION_TYPE_LOOKUP_CODE
, FLV.MEANING LOCATION_TYPE
, LOC.SPACE_TYPE_LOOKUP_CODE SPACE_TYPE_LOOKUP_CODE
, LOC.FUNCTION_TYPE_LOOKUP_CODE FUNCTION_TYPE_LOOKUP_CODE
, LOC.STANDARD_TYPE_LOOKUP_CODE STANDARD_TYPE_LOOKUP_CODE
, LOC.LOCATION_CODE LOCATION_CODE
, LOC.LOCATION_ALIAS LOCATION_ALIAS
, LOC.BUILDING BUILDING
, LOC.LEASE_OR_OWNED LEASE_OR_OWNED
, LOOT.MEANING LEASE_OR_OWNED_TENURE
, LOC.CLASS CLASS
, FNDC.MEANING CLASS_NAME
, LOC.STATUS_TYPE STATUS_TYPE
, FNDS.MEANING STATUS_TYPE_NAME
, LOC.GROSS_AREA GROSS_AREA
, LOC.UOM_CODE UOM_CODE
, LOC.STATUS STATUS
, LOC.PROPERTY_ID PROPERTY_ID
, PROP.PROPERTY_NAME PROPERTY_NAME
, LOC.INTERFACE_FLAG INTERFACE_FLAG
, LOC.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, LOC.ATTRIBUTE1 ATTRIBUTE1
, LOC.ATTRIBUTE2 ATTRIBUTE2
, LOC.ATTRIBUTE3 ATTRIBUTE3
, LOC.ATTRIBUTE4 ATTRIBUTE4
, LOC.ATTRIBUTE5 ATTRIBUTE5
, LOC.ATTRIBUTE6 ATTRIBUTE6
, LOC.ATTRIBUTE7 ATTRIBUTE7
, LOC.ATTRIBUTE8 ATTRIBUTE8
, LOC.ATTRIBUTE9 ATTRIBUTE9
, LOC.ATTRIBUTE10 ATTRIBUTE10
, LOC.ATTRIBUTE11 ATTRIBUTE11
, LOC.ATTRIBUTE12 ATTRIBUTE12
, LOC.ATTRIBUTE13 ATTRIBUTE13
, LOC.ATTRIBUTE14 ATTRIBUTE14
, LOC.ATTRIBUTE15 ATTRIBUTE15
, UOM.UNIT_OF_MEASURE UNIT_OF_MEASURE
, LOC.ADDRESS_ID ADDRESS_ID
, ADDR.ADDRESS_LINE1 ADDRESS_LINE1
, ADDR.ADDRESS_LINE2 ADDRESS_LINE2
, ADDR.ADDRESS_LINE3 ADDRESS_LINE3
, ADDR.ADDRESS_LINE4 ADDRESS_LINE4
, ADDR.COUNTY COUNTY
, ADDR.CITY CITY
, ADDR.STATE STATE
, ADDR.PROVINCE PROVINCE
, ADDR.ZIP_CODE ZIP_CODE
, ADDR.COUNTRY COUNTRY
, TERR.ADDRESS_STYLE ADDRESS_STYLE
, ADDR.TERRITORY_ID TERRITORY_ID
, ADDR.ADDR_ATTRIBUTE_CATEGORY ADDR_ATTRIBUTE_CATEGORY
, ADDR.ADDR_ATTRIBUTE1 ADDR_ATTRIBUTE1
, ADDR.ADDR_ATTRIBUTE2 ADDR_ATTRIBUTE2
, ADDR.ADDR_ATTRIBUTE3 ADDR_ATTRIBUTE3
, ADDR.ADDR_ATTRIBUTE4 ADDR_ATTRIBUTE4
, ADDR.ADDR_ATTRIBUTE5 ADDR_ATTRIBUTE5
, ADDR.ADDR_ATTRIBUTE6 ADDR_ATTRIBUTE6
, ADDR.ADDR_ATTRIBUTE7 ADDR_ATTRIBUTE7
, ADDR.ADDR_ATTRIBUTE8 ADDR_ATTRIBUTE8
, ADDR.ADDR_ATTRIBUTE9 ADDR_ATTRIBUTE9
, ADDR.ADDR_ATTRIBUTE10 ADDR_ATTRIBUTE10
, ADDR.ADDR_ATTRIBUTE11 ADDR_ATTRIBUTE11
, ADDR.ADDR_ATTRIBUTE12 ADDR_ATTRIBUTE12
, ADDR.ADDR_ATTRIBUTE13 ADDR_ATTRIBUTE13
, ADDR.ADDR_ATTRIBUTE14 ADDR_ATTRIBUTE14
, ADDR.ADDR_ATTRIBUTE15 ADDR_ATTRIBUTE15
, TERR.TERRITORY_SHORT_NAME TERRITORY_SHORT_NAME
, PNP_UTIL_FUNC.GET_CONCATENATED_ADDRESS( ADDR.ADDRESS_STYLE
, ADDR.ADDRESS_LINE1
, ADDR.ADDRESS_LINE2
, ADDR.ADDRESS_LINE3
, ADDR.ADDRESS_LINE4
, ADDR.CITY
, ADDR.COUNTY
, ADDR.STATE
, ADDR.PROVINCE
, ADDR.ZIP_CODE
, TERR.TERRITORY_SHORT_NAME ) CONCATENATED_ADDRESS
, DECODE(PLP1.LOCATION_PARK_TYPE
, 'OFFPRK'
, PLP1.LOCATION_PARK_ID
, NULL) OFFICE_PARK_ID
, DECODE(PLP1.LOCATION_PARK_TYPE
, 'OFFPRK'
, PLP1.NAME
, NULL) OFFICE_PARK_NAME
, DECODE(PLP1.LOCATION_PARK_TYPE
, 'REGION'
, PLP1.LOCATION_PARK_ID
, PLP2.LOCATION_PARK_ID) REGION_ID
, DECODE(PLP1.LOCATION_PARK_TYPE
, 'REGION'
, PLP1.NAME
, PLP2.NAME) REGION_NAME
, PNP_UTIL_FUNC.GET_VACANT_AREA(LOC.LOCATION_ID
, LOC.ACTIVE_START_DATE) VACANT_AREA
, PNP_UTIL_FUNC.GET_LOAD_FACTOR(LOC.LOCATION_ID
, LOC.ACTIVE_START_DATE) LOAD_FACTOR
, PNP_UTIL_FUNC.GET_VACANT_AREA_PERCENT(LOC.LOCATION_ID
, LOC.ACTIVE_START_DATE) PRCT_VACANT
, PNP_UTIL_FUNC.GET_UTILIZED_CAPACITY(LOC.LOCATION_ID
, LOC.ACTIVE_START_DATE) UTILIZED_CAPACITY
, PNP_UTIL_FUNC.GET_VACANCY(LOC.LOCATION_ID
, LOC.ACTIVE_START_DATE) VACANCY
, PNP_UTIL_FUNC.GET_OCCUPANCY_PERCENT(LOC.LOCATION_ID
, LOC.ACTIVE_START_DATE) OCCUPANCY
, PNP_UTIL_FUNC.GET_AREA_UTILIZED(LOC.LOCATION_ID
, LOC.ACTIVE_START_DATE) AREA_UTILIZED
, PNP_UTIL_FUNC.GET_FLOORS(LOC.LOCATION_ID
, LOC.ACTIVE_START_DATE) FLOORS
, PNP_UTIL_FUNC.GET_OFFICES(LOC.LOCATION_ID
, LOC.ACTIVE_START_DATE) UNITS
, LOC.ACTIVE_START_DATE ACTIVE_START_DATE
, TO_DATE(DECODE(TO_CHAR(LOC.ACTIVE_END_DATE
, 'MM/DD/YYYY')
, '12/31/4712'
, NULL
, TO_CHAR(LOC.ACTIVE_END_DATE
, 'MM/DD/YYYY'))
, 'MM/DD/YYYY') ACTIVE_END_DATE
, NVL(LOC.OCCUPANCY_STATUS_CODE
, 'Y') OCCUPANCY_STATUS_CODE
, OCST.MEANING OCCUPANCY_STATUS
, NVL(LOC.ASSIGNABLE_EMP
, 'Y') ASSIGNABLE_EMP
, NVL(LOC.ASSIGNABLE_CC
, 'Y') ASSIGNABLE_CC
, NVL(LOC.ASSIGNABLE_CUST
, 'Y') ASSIGNABLE_CUST
, LOC.DISPOSITION_CODE DISPOSITION_CODE
, LTRIM(RTRIM(DISP.MEANING)) DISPOSITION
, LOC.ACC_TREATMENT_CODE ACC_TREATMENT_CODE
, LTRIM(RTRIM(ACCT.MEANING)) ACC_TREATMENT
FROM MTL_UNITS_OF_MEASURE UOM
, PN_ADDRESSES_ALL ADDR
, FND_TERRITORIES_VL TERR
, PN_LOCATION_PARKS PLP1
, PN_LOCATION_PARKS PLP2
, FND_LOOKUPS FLV
, PN_LOCATIONS LOC
, PN_PROPERTIES_ALL PROP
, FND_LOOKUPS FNDC
, FND_LOOKUPS FNDS
, FND_LOOKUPS LOOT
, FND_LOOKUPS OCST
, FND_LOOKUPS DISP
, FND_LOOKUPS ACCT
WHERE LOC.LOCATION_TYPE_LOOKUP_CODE IN ('LAND'
, 'BUILDING')
AND UOM.UOM_CODE (+) = LOC.UOM_CODE
AND ADDR.ADDRESS_ID (+) = LOC.ADDRESS_ID
AND TERR.TERRITORY_CODE (+) = ADDR.COUNTRY
AND PROP.PROPERTY_ID (+) = LOC.PROPERTY_ID
AND FLV.LOOKUP_CODE = LOC.LOCATION_TYPE_LOOKUP_CODE
AND FLV.LOOKUP_TYPE = 'PN_LOCATION_TYPE'
AND PLP1.LOCATION_PARK_ID (+) = LOC.LOCATION_PARK_ID
AND PLP1.LANGUAGE (+) = USERENV('LANG')
AND PLP2.LOCATION_PARK_ID (+) = PLP1.PARENT_LOCATION_PARK_ID
AND PLP2.LANGUAGE (+) = USERENV('LANG')
AND FNDC.LOOKUP_CODE (+) = LOC.CLASS
AND FNDC.LOOKUP_TYPE (+) = 'PN_CLASS_TYPE'
AND FNDS.LOOKUP_CODE (+) = LOC.STATUS_TYPE
AND FNDS.LOOKUP_TYPE (+) = 'PN_STATUS_TYPE'
AND LOOT.LOOKUP_CODE (+) = LOC.LEASE_OR_OWNED
AND LOOT.LOOKUP_TYPE (+) = 'PN_LEASED_OR_OWNED'
AND OCST.LOOKUP_CODE (+) = NVL(LOC.OCCUPANCY_STATUS_CODE
, 'Y')
AND OCST.LOOKUP_TYPE (+) = 'PN_OCCUPANCY_STATUS_CODE'
AND DISP.LOOKUP_CODE (+) = LOC.DISPOSITION_CODE
AND DISP.LOOKUP_TYPE (+) = 'PN_DISPOSITION_CODE'
AND ACCT.LOOKUP_CODE (+) = LOC.ACC_TREATMENT_CODE
AND ACCT.LOOKUP_TYPE (+) = 'PN_ACC_TREATMENT_CODE'

Columns