View: PN_OFFICES_V

Product:	PN - Property Manager
Description:	Public view used to view Location information.
Implementation/DBA Data:	APPS.PN_OFFICES_V

View Text

SELECT LOC.ROWID ROW_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_TYPE_LOOKUP_CODE LOCATION_TYPE_LOOKUP_CODE
, FLV.MEANING LOCATION_TYPE
, LOC.SPACE_TYPE_LOOKUP_CODE SPACE_TYPE_LOOKUP_CODE
, LST.MEANING SPACE_TYPE
, LOC.FUNCTION_TYPE_LOOKUP_CODE FUNCTION_TYPE_LOOKUP_CODE
, FUN.MEANING FUNCTION_TYPE
, LOC.STANDARD_TYPE_LOOKUP_CODE STANDARD_TYPE_LOOKUP_CODE
, STD.MEANING STANDARD_TYPE
, LOC.LOCATION_CODE LOCATION_CODE
, LOC.LOCATION_ALIAS LOCATION_ALIAS
, LOC.BUILDING BUILDING
, LOC.FLOOR FLOOR
, LOC.OFFICE OFFICE
, LOC.MAX_CAPACITY MAX_CAPACITY
, LOC.OPTIMUM_CAPACITY OPTIMUM_CAPACITY
, LOC.RENTABLE_AREA RENTABLE_AREA
, LOC.USABLE_AREA USABLE_AREA
, LOC.ASSIGNABLE_AREA ASSIGNABLE_AREA
, LOC.COMMON_AREA COMMON_AREA
, LOC.SUITE SUITE
, LOC.PARENT_LOCATION_ID PARENT_LOCATION_ID
, FLR.PARENT_LOCATION_ID BUILDING_ID
, LOC.STATUS STATUS
, 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
, PNP_UTIL_FUNC.GET_VACANT_AREA(LOC.LOCATION_ID
, LOC.ACTIVE_START_DATE) VACANT_AREA
, PNP_UTIL_FUNC.GET_UTILIZED_CAPACITY(LOC.LOCATION_ID
, LOC.ACTIVE_START_DATE) UTILIZED_CAPACITY
, PNP_UTIL_FUNC.GET_OFFICE_VACANCY(LOC.LOCATION_ID
, LOC.ACTIVE_START_DATE) VACANCY
, PNP_UTIL_FUNC.GET_OFFICE_SECONDARY_AREA (LOC.LOCATION_ID
, LOC.ACTIVE_START_DATE) SECONDARY_CIRCULATION
, LOC.COMMON_AREA_FLAG COMMON_AREA_FLAG
, 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
, LOC.BOOKABLE_FLAG BOOKABLE_FLAG
, 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 FND_LOOKUPS FLV
, FND_LOOKUPS LST
, PN_LOCATIONS_ALL FLR
, PN_LOCATIONS LOC
, FND_LOOKUPS FUN
, FND_LOOKUPS STD
, FND_LOOKUPS LOOT
, FND_LOOKUPS OCST
, FND_LOOKUPS DISP
, FND_LOOKUPS ACCT
WHERE LOC.LOCATION_TYPE_LOOKUP_CODE IN ( 'OFFICE'
, 'SECTION')
AND FLV.LOOKUP_CODE = LOC.LOCATION_TYPE_LOOKUP_CODE
AND FLV.LOOKUP_TYPE = 'PN_LOCATION_TYPE'
AND FLR.LOCATION_ID = LOC.PARENT_LOCATION_ID
AND LOC.ACTIVE_START_DATE BETWEEN FLR.ACTIVE_START_DATE
AND TO_DATE(NVL(TO_CHAR(FLR.ACTIVE_END_DATE
, 'MM/DD/YYYY')
, '12/31/4712')
, 'MM/DD/YYYY')
AND LST.LOOKUP_CODE (+) = LOC.SPACE_TYPE_LOOKUP_CODE
AND LST.LOOKUP_TYPE (+) = DECODE(LOC.LOCATION_TYPE_LOOKUP_CODE
, 'OFFICE'
, 'PN_SPACE_TYPE'
, 'SECTION'
, 'PN_PARCEL_TYPE')
AND FUN.LOOKUP_CODE (+) = LOC.FUNCTION_TYPE_LOOKUP_CODE
AND FUN.LOOKUP_TYPE (+) = 'PN_FUNCTION_TYPE'
AND STD.LOOKUP_CODE (+) = LOC.STANDARD_TYPE_LOOKUP_CODE
AND STD.LOOKUP_TYPE (+) = 'PN_STANDARD_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