RO_RSF_LOPP_LVW (SQL View)	Index Back
Related Language-SFA Lead/Oppy Get all Captures related to a Lead/Oppy

RO_RSF_LOPP_LVW

(SQL View)

Related Language-SFA Lead/Oppy

Get all Captures related to a Lead/Oppy

SELECT DISTINCT B.LEAD_ID ,B.OPPORTUNITY_ID ,C.LANGUAGE_CD ,C.DESCR50 FROM PS_RO_HEADER A , PS_RO_ASSOCIATION B ,PS_RO_HEADER_LANG C WHERE A.CAPTURE_ID=B.CAPTURE_ID AND A.CAPTURE_ID=C.CAPTURE_ID AND B.TYPE IN ('SL','ROPP')

Related Language Record for RO_RSF_LOPPY_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LEAD_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation, this field uniquely identifies a Sales Lead.

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

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LEAD_ID	Character(15)	VARCHAR2(15) NOT NULL	Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
2	OPPORTUNITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Opportunity ID
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50