RB_SCONT_OPP_VW (SQL View)	Index Back
Opportunity contact for slsrep Pulls back all the contacts for an opportuntiy, for each sales rep on the team of the opportuntiy

RB_SCONT_OPP_VW

(SQL View)

Opportunity contact for slsrep

Pulls back all the contacts for an opportuntiy, for each sales rep on the team of the opportuntiy

SELECT O.OPPORTUNITY_ID , O.CUST_SETID , C.CONTACT_ID , S.PERSON_ID , C.BO_ID_CONTACT , O.BO_ID_CUST , O.NAME1 , C.CONTACT_NAME , P.SYNCID FROM PS_RSF_OPPORTUNITY O , PS_RSF_OPP_SLSREP S , PS_RSF_OPP_CONTACT C , PS_RD_PERSON P WHERE O.OPPORTUNITY_ID = S.OPPORTUNITY_ID AND O.OPPORTUNITY_ID = C.OPPORTUNITY_ID AND P.PERSON_ID = C.CONTACT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPPORTUNITY_ID Character(15) VARCHAR2(15) NOT NULL Opportunity ID

2 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer Setid

3 PERSON_ID_CONT Character(15) VARCHAR2(15) NOT NULL Person ID

4 PERSON_ID_SLSREP Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

5 BO_ID_1 Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID 1

6 BO_ID_2 Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID 2

7 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.

8 NAME Character(50) VARCHAR2(50) NOT NULL Name

9 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPPORTUNITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Opportunity ID
2	CUST_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer Setid
3	PERSON_ID_CONT	Character(15)	VARCHAR2(15) NOT NULL	Person ID
4	PERSON_ID_SLSREP	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
5	BO_ID_1	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID 1
6	BO_ID_2	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID 2
7	NAME1	Character(50)	VARCHAR2(50) NOT NULL	Generic 50 character name field for storing names.
8	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
9	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.