RSF_TR_REO_O_VW

(SQL View)
 Index Back

Territory - Reorg Opps. View


SELECT A.TREE_NAME ,A.TERRITORY_ID ,C.PERSON_ID_MANAGER ,A.PERSON_ID ,A.OPPORTUNITY_ID ,B.OPPORTUNITY_NAME ,A.PRIMARY_FLG ,B.NAME1 ,B.EST_CLOSE_DT ,A.PCT_ALLOC ,B.OPPORTUNITY_STATUS FROM PS_RSF_OPP_SLSREP A , PS_RSF_OPPORTUNITY B , PS_RSF_ACC_FROM_VW C WHERE A.OPPORTUNITY_ID = B.OPPORTUNITY_ID AND B.OPPORTUNITY_STATUS IN('0','3') AND A.PERSON_ID = B.PERSON_ID AND A.PRIMARY_FLG = 'Y' AND B.PERSON_ID = C.FROM_USER AND B.PERSON_ID = A.PERSON_ID AND A.TREE_NAME = C.TREE_NAME AND A.TREE_NAME = B.TREE_NAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FROM_TREE Character(18) VARCHAR2(18) NOT NULL Current Tree Name
2 FROM_TERRITORY Character(20) VARCHAR2(20) NOT NULL Current Territory
3 PERSON_ID_MANAGER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
4 FROM_SALES_REP Character(15) VARCHAR2(15) NOT NULL Current Sales Representative
5 OPPORTUNITY_ID Character(15) VARCHAR2(15) NOT NULL Opportunity ID
6 OPPORTUNITY_NAME Character(50) VARCHAR2(50) NOT NULL Opportunity Name - User Enters this field in Mixed Case.
7 PRIMARY_FLG Character(1) VARCHAR2(1) NOT NULL This is a flag which takes yes or no values and indicates whether the row is primary.
N=No
Y=Yes
8 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.
9 EST_CLOSE_DT Date(10) DATE Estimated Close Date of an Opportunity
10 PCT_ALLOC Number(3,0) SMALLINT NOT NULL Allocation Percentage
11 OPPORTUNITY_STATUS Character(1) VARCHAR2(1) NOT NULL Opportunity Status. The values are XLat Values
0=Open
1=Closed - Lost
2=Closed - Won
3=Inactive