RSF_OPR_TREE_VW

(SQL View)
 Index Back

Trees by sales user

Note: There is a clone of RSF_OPR_TREE_VW called RSF_OPR_TREE1VW. If you change RSF_OPR_TREE_VW then you must change RSF_OPR_TREE1VW.

SELECT DISTINCT C.OPRID ,A.TREE_NAME FROM PS_RSF_TR_TEAM A , PS_RSF_OPR_DEF_VW C WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_RSF_TR_TEAM B WHERE A.TREE_NAME = B.TREE_NAME AND A.TERRITORY_ID = B.TERRITORY_ID AND A.PERSON_ID = B.PERSON_ID AND B.EFFDT <= %CurrentDateIn) AND A.PERSON_ID = C.PERSON_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name