View: PN_PLAND_V

Product:	PN - Property Manager
Description:
Implementation/DBA Data:	APPS.PN_PLAND_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_CODE LOCATION_CODE
, LOC.LOCATION_TYPE_LOOKUP_CODE LOCATION_TYPE_LOOKUP_CODE
, LOC.BUILDING BUILDING
, LOC.STATUS STATUS
, LOC.PROPERTY_ID PROPERTY_ID
, 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
, 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.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
, 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
, LOC.ORG_ID ORG_ID
FROM PN_ADDRESSES_ALL ADDR
, FND_TERRITORIES_VL TERR
, FND_LOOKUPS FLV
, PN_LOCATIONS LOC
, PN_PROPERTIES_ALL PROP
WHERE LOC.LOCATION_TYPE_LOOKUP_CODE = 'LAND'
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 LOC.ACTIVE_START_DATE = (SELECT LOC1.ACTIVE_START_DATE
FROM PN_LOCATIONS LOC1
WHERE LOC1.LOCATION_ID = LOC.LOCATION_ID
AND ROWNUM < 2)

Columns