RSF_CNTLDCNV_VW

(SQL View)
 Index Back

to get the contact for lead

store the all contact for the Lead

SELECT DISTINCT A.BO_ID_CONTACT , D.ROLE_TYPE_ID_CNTCT , A.BUSINESS_UNIT FROM PS_RSF_LEAD A , PS_RSF_LE_CONTACTS D WHERE A.BO_ID_CONTACT > 0 AND A.BO_ID_CONTACT = D.BO_ID_CONTACT AND ( EXISTS ( SELECT A.BO_ID_CONTACT FROM PS_RSF_LE_CONTACTS B WHERE A.BO_ID_CONTACT = B.BO_ID_CONTACT) OR EXISTS ( SELECT BO_ID_CONTACT FROM PS_RSF_OPP_CONTACT C WHERE A.BO_ID_CONTACT = C.BO_ID_CONTACT) OR EXISTS ( SELECT BO_ID_CONTACT FROM PS_RSF_OPPORTUNITY E WHERE A.BO_ID_CONTACT = E.BO_ID_CONTACT)) GROUP BY A.BO_ID_CONTACT, D.ROLE_TYPE_ID_CNTCT, A.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
2 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit