Product: | PN - Property Manager |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PN_LOCATION_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
FROM PN_COMPANIES_ALL PNC
, FND_LOOKUPS FLV
, PN_COMPANY_SITES_ALL PCS
, PN_CONTACT_ASSIGNMENTS PCA
WHERE PCA.LOCATION_ID IS NOT NULL AND PCA.LEASE_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