SELECT CPA.CUSTOMER_PRODUCT_ID , CON.CONTACT_TYPE , BCON.CONTACT_NAME , BCON.CONTACT_PHONE , BCON.CONTACT_EMAIL FROM CS_CUSTOMER_PRODUCTS_ALL CPA , CS_CONTACTS CON , BIC_CONTACTS_V BCON WHERE CPA.CUSTOMER_PRODUCT_ID = CON.SOURCE_OBJECT_ID AND CON.SOURCE_OBJECT_CODE = 'CP' AND CON.CONTACT_ID = BCON.PARTY_ID WITH READ ONLY