This view is used for Opportunity Exchange module to provide the list all valid partners in Opportunity Exchange
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT TO_NUMBER(A.ORIG_SYSTEM_REFERENCE) PARTNER_ID , A.PARTNER_PARTY_NAME PARTNER_NAME , A.PARTNER_PARTY_ID PARTY_ID , A.LEAD_SHARING_STATUS LEAD_SHARING_STATUS , A.LEAD_SHARE_APPR_FLAG LEAD_SHARE_APPR_FLAG , A.PARTNER_ID PV_PARTNER_ID , C. ADDRESS1 , C. ADDRESS2 , C. ADDRESS3 , C. ADDRESS4 , C. CITY , C. POSTAL_CODE , C. STATE , C. PROVINCE , C. COUNTY , C. COUNTRY FROM PV_PARTNERS_V A , HZ_PARTY_SITES B , HZ_LOCATIONS C WHERE A.PARTNER_PARTY_ID = B.PARTY_ID AND B.STATUS IN ('A' , 'I') AND B.LOCATION_ID = C.LOCATION_ID AND NVL(A.ORIG_SYSTEM_TYPE , 'ZZ') ='LEAD_EXCHANGE'