RSF_TR_OPPU_VW

(SQL View)
 Index Back

Reassign Unassigned opp

View for unassigned opportunity for territory reassignment.

SELECT A.TREE_NAME , A.TERRITORY_ID , A.PERSON_ID , A.OPPORTUNITY_ID , A.OPPORTUNITY_NAME , 'Y' , A.NAME1 , A.EST_CLOSE_DT , 100 , A.OPPORTUNITY_STATUS , A.TREE_NAME , A.TERRITORY_ID , A.ROW_ADDED_DTTM , A.ROW_LASTMANT_DTTM FROM PS_RSF_OPPORTUNITY A WHERE A.OPPORTUNITY_STATUS IN('0','3') AND NOT EXISTS ( SELECT 'X' FROM PS_RSF_OPP_SLSREP WHERE OPPORTUNITY_ID = A.OPPORTUNITY_ID)

# 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 FROM_SALES_REP Character(15) VARCHAR2(15) NOT NULL Current Sales Representative
4 OPPORTUNITY_ID Character(15) VARCHAR2(15) NOT NULL Opportunity ID
5 OPPORTUNITY_NAME Character(50) VARCHAR2(50) NOT NULL Opportunity Name - User Enters this field in Mixed Case.
6 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
7 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.
8 EST_CLOSE_DT Date(10) DATE Estimated Close Date of an Opportunity
9 PCT_ALLOC Number(3,0) SMALLINT NOT NULL Allocation Percentage
10 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
11 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
12 TERRITORY_ID Character(20) VARCHAR2(20) NOT NULL Territory ID
13 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
14 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.