RSF_OPP_CP_X_VW (SQL View)	Index Back
OppCompetitor left join w xlat Used in Opportunity report for display of competitor's 'involment' (when present)

RSF_OPP_CP_X_VW

(SQL View)

OppCompetitor left join w xlat

Used in Opportunity report for display of competitor's 'involment' (when present)

SELECT A.OPPORTUNITY_ID , A.PRODUCT_ID , A.CUST_ID , A.DESCR100 , B.BO_NAME , E.XLATLONGNAME FROM PS_RD_COMPANY_VW B , PS_RSF_OPP_COMP A , PSXLATITEM E WHERE A.INVOLVMENT = E.FIELDVALUE (+) AND E.FIELDNAME = 'INVOLVMENT' AND %EffdtCheck(PSXLATITEM D, E, %CurrentDateIn) AND A.BO_ID_CUST = B.BO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
Prompt Table: RSF_OPP_C_PRD_V

3 CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID

4 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

5 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

6 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPPORTUNITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Opportunity ID
2	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID Prompt Table: RSF_OPP_C_PRD_V
3	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer ID
4	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
5	BO_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
6	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name