RSF_OPNCASE_VW (SQL View)	Index Back
Sales tasks view Sales task view for term evaluation of open tasks.

RSF_OPNCASE_VW

(SQL View)

Sales tasks view

Sales task view for term evaluation of open tasks.

SELECT DISTINCT A.BO_ID_CUST , A.ROLE_TYPE_ID_CUST , E.SETID FROM PS_RC_CASE A , PS_BC E WHERE A.RC_STATUS = 'OPEN' AND A.BO_ID_CUST > 0 AND E.BO_ID = A.BO_ID_CUST AND ( EXISTS ( SELECT BO_ID_CUST FROM PS_RSF_LEAD B WHERE A.BO_ID_CUST = B.BO_ID_CUST) OR EXISTS ( SELECT BO_ID_CUST FROM PS_RSF_OPPORTUNITY C WHERE A.BO_ID_CUST = C.BO_ID_CUST))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.

2 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer

3 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
2	ROLE_TYPE_ID_CUST	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the customer
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.