Product: | PN - Property Manager |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PN_LEASE_CONTACT_ASSIGN_V |
SELECT PCA.ROWID
, PCA.CONTACT_ASSIGNMENT_ID
, PCA.LAST_UPDATE_DATE
, PCA.LAST_UPDATED_BY
, PCA.CREATION_DATE
, PCA.CREATED_BY
, PCA.LAST_UPDATE_LOGIN
, PCA.COMPANY_ID
, PNC.NAME COMPANY_NAME
, PCA.COMPANY_SITE_ID
, PCS.NAME SITE_NAME
, PCS.LEASE_ROLE_TYPE LEASE_ROLE_TYPE
, FLV.MEANING LEASE_ROLE
, PCA.LEASE_ID
, PCA.LEASE_CHANGE_ID
, PCA.LOCATION_ID
, PCA.STATUS
, PCA.ATTRIBUTE_CATEGORY
, PCA.ATTRIBUTE1
, PCA.ATTRIBUTE2
, PCA.ATTRIBUTE3
, PCA.ATTRIBUTE4
, PCA.ATTRIBUTE5
, PCA.ATTRIBUTE6
, PCA.ATTRIBUTE7
, PCA.ATTRIBUTE8
, PCA.ATTRIBUTE9
, PCA.ATTRIBUTE10
, PCA.ATTRIBUTE11
, PCA.ATTRIBUTE12
, PCA.ATTRIBUTE13
, PCA.ATTRIBUTE14
, PCA.ATTRIBUTE15
, PCA.ORG_ID
, 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
FROM PN_COMPANIES_ALL PNC
, FND_LOOKUPS FLV
, PN_COMPANY_SITES_ALL PCS
, PN_CONTACT_ASSIGNMENTS PCA
, PN_ADDRESSES_ALL ADDR
, FND_TERRITORIES_VL TERR
WHERE PCA.LEASE_ID IS NOT NULL
AND PCA.LOCATION_ID IS NULL
AND PCS.COMPANY_SITE_ID = PCA.COMPANY_SITE_ID
AND FLV.LOOKUP_CODE = PCS.LEASE_ROLE_TYPE
AND FLV.LOOKUP_TYPE = 'PN_LEASE_ROLE_TYPE'
AND PNC.COMPANY_ID = PCA.COMPANY_ID
AND PNC.COMPANY_ID = PCS.COMPANY_ID
AND PCS.ADDRESS_ID = ADDR.ADDRESS_ID (+)
AND ADDR.COUNTRY = TERR.TERRITORY_CODE (+)