APPS.PN_CONTACT_ASSIGN_HISTORY_V
[Home] [Help]
| Product: | PN - Property Manager |
|---|---|
| Description: | |
| Implementation/DBA Data: |
APPS.PN_CONTACT_ASSIGN_HISTORY_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
, TO_NUMBER (NULL) CONTACT_ASSIGN_HISTORY_ID
, TO_NUMBER (NULL) NEW_LEASE_CHANGE_ID
, 'Y' CURRENT_FLAG
FROM PN_COMPANIES_ALL PNC
, FND_LOOKUPS FLV
, PN_COMPANY_SITES_ALL PCS
, PN_CONTACT_ASSIGNMENTS PCA
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 UNION ALL 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.CONTACT_ASSIGN_HISTORY_ID
, PCA.NEW_LEASE_CHANGE_ID
, 'N' CURRENT_FLAG
FROM PN_COMPANIES_ALL PNC
, FND_LOOKUPS FLV
, PN_COMPANY_SITES_ALL PCS
, PN_CONTACT_ASSIGN_HISTORY PCA 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