View: PN_COMPANY_SITES_V

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

View Text

SELECT CSITE.ROWID ROW_ID
, CSITE.COMPANY_SITE_ID COMPANY_SITE_ID
, CSITE.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CSITE.LAST_UPDATED_BY LAST_UPDATED_BY
, CSITE.CREATION_DATE CREATION_DATE
, CSITE.CREATED_BY CREATED_BY
, CSITE.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CSITE.NAME NAME
, CSITE.COMPANY_ID COMPANY_ID
, CSITE.ENABLED_FLAG ENABLED_FLAG
, CSITE.COMPANY_SITE_CODE COMPANY_SITE_CODE
, CSITE.LEASE_ROLE_TYPE LEASE_ROLE_TYPE
, CSITE.ADDRESS_ID ADDRESS_ID
, CSITE.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CSITE.ATTRIBUTE1 ATTRIBUTE1
, CSITE.ATTRIBUTE2 ATTRIBUTE2
, CSITE.ATTRIBUTE3 ATTRIBUTE3
, CSITE.ATTRIBUTE4 ATTRIBUTE4
, CSITE.ATTRIBUTE5 ATTRIBUTE5
, CSITE.ATTRIBUTE6 ATTRIBUTE6
, CSITE.ATTRIBUTE7 ATTRIBUTE7
, CSITE.ATTRIBUTE8 ATTRIBUTE8
, CSITE.ATTRIBUTE9 ATTRIBUTE9
, CSITE.ATTRIBUTE10 ATTRIBUTE10
, CSITE.ATTRIBUTE11 ATTRIBUTE11
, CSITE.ATTRIBUTE12 ATTRIBUTE12
, CSITE.ATTRIBUTE13 ATTRIBUTE13
, CSITE.ATTRIBUTE14 ATTRIBUTE14
, CSITE.ATTRIBUTE15 ATTRIBUTE15
, 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.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.ADDRESS_STYLE ADDRESS_STYLE
, TERR.TERRITORY_SHORT_NAME TERRITORY_SHORT_NAME
, RLOOK.MEANING LEASE_ROLE
, 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
, CSITE.ORG_ID ORG_ID
FROM FND_TERRITORIES_VL TERR
, PN_ADDRESSES_ALL ADDR
, FND_LOOKUPS RLOOK
, PN_COMPANY_SITES CSITE
WHERE CSITE.ADDRESS_ID = ADDR.ADDRESS_ID (+)
AND ADDR.COUNTRY = TERR.TERRITORY_CODE (+)
AND RLOOK.LOOKUP_TYPE = 'PN_LEASE_ROLE_TYPE'
AND RLOOK.LOOKUP_CODE = CSITE.LEASE_ROLE_TYPE

Columns