View: PN_LOCATIONS_ITF_V

Product:	PN - Property Manager
Description:
Implementation/DBA Data:	APPS.PN_LOCATIONS_ITF_V

View Text

SELECT LOCN.LOCATION_ID LOCATION_ID
, LOCN.LOCATION_TYPE_LOOKUP_CODE LOCATION_TYPE_LOOKUP_CODE
, LOCN.LOCATION_CODE LOCATION_CODE
, LOCN.BUILDING BUILDING
, LOCN.LEASE_OR_OWNED LEASE_OR_OWNED
, LOCN.FLOOR FLOOR
, LOCN.OFFICE OFFICE
, 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
, ADDR.ADDRESS_STYLE ADDRESS_STYLE
, LOCN.MAX_CAPACITY MAX_CAPACITY
, LOCN.OPTIMUM_CAPACITY OPTIMUM_CAPACITY
, LOCN.RENTABLE_AREA RENTABLE_AREA
, LOCN.USABLE_AREA USABLE_AREA
, LOCN.ALLOCATE_COST_CENTER_CODE ALLOCATE_COST_CENTER_CODE
, LOCN.UOM_CODE UOM_CODE
, ( CONT.FIRST_NAME || ' ' || CONT.LAST_NAME ) CONTACT_NAME
, PHON.PHONE_NUMBER CONTACT_PHONE
, CONT.EMAIL_ADDRESS EMAIL_ADDRESS
, LOCN.DESCRIPTION DESCRIPTION
, LOCN.PARENT_LOCATION_ID PARENT_LOCATION_ID
, LOCN.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LOCN.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LOCN.CREATED_BY CREATED_BY
, LOCN.CREATION_DATE CREATION_DATE
, LOCN.LAST_UPDATED_BY LAST_UPDATED_BY
, LOCN.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, LOCN.ATTRIBUTE1 ATTRIBUTE1
, LOCN.ATTRIBUTE2 ATTRIBUTE2
, LOCN.ATTRIBUTE3 ATTRIBUTE3
, LOCN.ATTRIBUTE4 ATTRIBUTE4
, LOCN.ATTRIBUTE5 ATTRIBUTE5
, LOCN.ATTRIBUTE6 ATTRIBUTE6
, LOCN.ATTRIBUTE7 ATTRIBUTE7
, LOCN.ATTRIBUTE8 ATTRIBUTE8
, LOCN.ATTRIBUTE9 ATTRIBUTE9
, LOCN.ATTRIBUTE10 ATTRIBUTE10
, LOCN.ATTRIBUTE11 ATTRIBUTE11
, LOCN.ATTRIBUTE12 ATTRIBUTE12
, LOCN.ATTRIBUTE13 ATTRIBUTE13
, LOCN.ATTRIBUTE14 ATTRIBUTE14
, LOCN.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.ATTRIBUTE1 ADDR_ATTRIBUTE15
, LOCN.ORG_ID ORG_ID
FROM PN_LOCATIONS LOCN
, PN_ADDRESSES_ALL ADDR
, PN_CONTACTS_ALL CONT
, PN_PHONES_ALL PHON
, PN_CONTACT_ASSIGNMENTS_ALL CONA
WHERE LOCN.ADDRESS_ID = ADDR.ADDRESS_ID (+)
AND LOCN.LOCATION_ID = CONA.LOCATION_ID (+)
AND CONA.COMPANY_SITE_ID = CONT.COMPANY_SITE_ID (+)
AND CONT.CONTACT_ID = PHON.CONTACT_ID (+)
AND LEASE_ID IS NULL

Columns