View: PN_PROPERTIES_V

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

View Text

SELECT PROP.ORG_ID ORG_ID
, PROP.ROWID ROW_ID
, PROP.PROPERTY_ID PROPERTY_ID
, PROP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PROP.LAST_UPDATED_BY LAST_UPDATED_BY
, PROP.CREATION_DATE CREATION_DATE
, PROP.CREATED_BY CREATED_BY
, PROP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROP.PROPERTY_NAME PROPERTY_NAME
, PROP.PROPERTY_CODE PROPERTY_CODE
, PROP.LOCATION_PARK_ID LOCATION_PARK_ID
, PROP.ZONE ZONE
, FNDZ.MEANING ZONE_NAME
, PROP.DISTRICT DISTRICT
, PROP.COUNTRY COUNTRY
, PROP.DESCRIPTION DESCRIPTION
, PROP.PORTFOLIO PORTFOLIO
, FNDP.MEANING PORTFOLIO_NAME
, PROP.TENURE TENURE
, FNDT.MEANING TENURE_NAME
, PROP.CLASS CLASS
, FNDC.MEANING CLASS_NAME
, PROP.PROPERTY_STATUS PROPERTY_STATUS
, FNDS.MEANING PROPERTY_STATUS_NAME
, PROP.CONDITION CONDITION
, FNDD.MEANING CONDITION_NAME
, PROP.ACTIVE_PROPERTY ACTIVE_PROPERTY
, PROP.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PROP.ATTRIBUTE1 ATTRIBUTE1
, PROP.ATTRIBUTE2 ATTRIBUTE2
, PROP.ATTRIBUTE3 ATTRIBUTE3
, PROP.ATTRIBUTE4 ATTRIBUTE4
, PROP.ATTRIBUTE5 ATTRIBUTE5
, PROP.ATTRIBUTE6 ATTRIBUTE6
, PROP.ATTRIBUTE7 ATTRIBUTE7
, PROP.ATTRIBUTE8 ATTRIBUTE8
, PROP.ATTRIBUTE9 ATTRIBUTE9
, PROP.ATTRIBUTE10 ATTRIBUTE10
, PROP.ATTRIBUTE11 ATTRIBUTE11
, PROP.ATTRIBUTE12 ATTRIBUTE12
, PROP.ATTRIBUTE13 ATTRIBUTE13
, PROP.ATTRIBUTE14 ATTRIBUTE14
, PROP.ATTRIBUTE15 ATTRIBUTE15
, TERR.TERRITORY_SHORT_NAME TERRITORY_SHORT_NAME
, 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
FROM PN_PROPERTIES PROP
, FND_TERRITORIES_VL TERR
, PN_LOCATION_PARKS PLP1
, PN_LOCATION_PARKS PLP2
, FND_LOOKUPS FNDZ
, FND_LOOKUPS FNDP
, FND_LOOKUPS FNDT
, FND_LOOKUPS FNDC
, FND_LOOKUPS FNDS
, FND_LOOKUPS FNDD
WHERE TERR.TERRITORY_CODE (+) = PROP.COUNTRY
AND PLP1.LOCATION_PARK_ID (+) = PROP.LOCATION_PARK_ID
AND PLP1.LANGUAGE (+)= USERENV('LANG')
AND PLP2.LOCATION_PARK_ID (+)= PLP1.PARENT_LOCATION_PARK_ID
AND PLP2.LANGUAGE (+)= USERENV('LANG')
AND FNDZ.LOOKUP_CODE (+) = PROP.ZONE
AND FNDZ.LOOKUP_TYPE (+) = 'PN_ZONE_TYPE'
AND FNDP.LOOKUP_CODE (+) = PROP.PORTFOLIO
AND FNDP.LOOKUP_TYPE (+) = 'PN_PORTFOLIO_TYPE'
AND FNDT.LOOKUP_CODE (+) = PROP.TENURE
AND FNDT.LOOKUP_TYPE (+) = 'PN_LEASED_OR_OWNED'
AND FNDC.LOOKUP_CODE (+) = PROP.CLASS
AND FNDC.LOOKUP_TYPE (+) = 'PN_CLASS_TYPE'
AND FNDS.LOOKUP_CODE (+) = PROP.PROPERTY_STATUS
AND FNDS.LOOKUP_TYPE (+) = 'PN_STATUS_TYPE'
AND FNDD.LOOKUP_CODE (+) = PROP.CONDITION
AND FNDD.LOOKUP_TYPE (+) = 'PN_CONDITION_TYPE'

Columns