RSF_QS_N_VW

(SQL View)
 Index Back

Opp Count - New Segments

A view of all opportunities for new segments.

SELECT A.PERSON_ID , B.PIPELINE_SEGMENT FROM PS_RD_PERSON A , PS_RSF_SEGMENT B WHERE B.STATUS = 'A' AND B.PIPELINE_SEGMENT NOT IN ( SELECT C.PIPELINE_SEGMENT FROM PS_RSF_QS C WHERE C.PERSON_ID = A.PERSON_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

Prompt Table: RSF_SUSER

2 PIPELINE_SEGMENT Character(15) VARCHAR2(15) NOT NULL Segment corresponds to sales stage.