RSF_ACC_TO_VW1 (SQL View)	Index Back
To Rep Security View to show only active sales reps to whom I have security access.

RSF_ACC_TO_VW1

(SQL View)

To Rep Security

View to show only active sales reps to whom I have security access.

SELECT DISTINCT R.REORG_ID , A.TREE_NAME , A.PERSON_ID , B.BO_NAME FROM PS_RSF_TR_TEAM A , PS_RD_PERSON P , PS_BO_NAME B ,PS_RSF_SUSER_A_VW S ,PSTREENODE X , PS_RSF_TR_REORG R WHERE A.PERSON_ID = P.PERSON_ID AND P.BO_ID = B.BO_ID AND B.PRIMARY_IND = 'Y' AND A.PERSON_ID = S.PERSON_ID AND A.TREE_NAME <> ' ' AND A.TREE_NAME = X.TREE_NAME AND A.TERRITORY_ID = X.TREE_NODE AND X.EFFDT = R.EFFDT_TO AND X.TREE_NAME = R.TO_TREE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 REORG_ID Character(15) VARCHAR2(15) NOT NULL Reorganization ID

2 TO_TREE Character(18) VARCHAR2(18) NOT NULL New Tree Name

3 TO_SALES_REP Character(15) VARCHAR2(15) NOT NULL New Sales Representative

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	REORG_ID	Character(15)	VARCHAR2(15) NOT NULL	Reorganization ID
2	TO_TREE	Character(18)	VARCHAR2(18) NOT NULL	New Tree Name
3	TO_SALES_REP	Character(15)	VARCHAR2(15) NOT NULL	New Sales Representative
4	BO_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object