VIEW: APPS.PN_CONTACT_ASSIGNMENTS_V

Source

View Text - Preformatted

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 ,(con.first_name || ' '|| con.last_name) contact_name ,pcs.ADDRESS_ID ,pca.ORG_ID FROM pn_contacts_all con, pn_companies_all pnc, fnd_lookups flv, pn_company_sites_all pcs, pn_contact_assignments pca WHERE pca.lease_id IS NOT 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 con.company_site_id (+) = pca.company_site_id and con.primary_flag (+) = 'Y'

View Text - HTML Formatted

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
, (CON.FIRST_NAME || ' '|| CON.LAST_NAME) CONTACT_NAME
, PCS.ADDRESS_ID
, PCA.ORG_ID
FROM PN_CONTACTS_ALL CON
, PN_COMPANIES_ALL PNC
, FND_LOOKUPS FLV
, PN_COMPANY_SITES_ALL PCS
, PN_CONTACT_ASSIGNMENTS PCA
WHERE PCA.LEASE_ID IS NOT 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 CON.COMPANY_SITE_ID (+) = PCA.COMPANY_SITE_ID
AND CON.PRIMARY_FLAG (+) = 'Y'