RB_TSK_DELES_VW

(SQL View)
 Index Back

Delegate View

View for retrieving Tasks delegated to Sales Team from the Task Delegate record.

SELECT A.PERSON_ID , C.BO_ID , D.BO_NAME_DISPLAY , B.TEAM_ID , B.PERSON_ID , A.READONLY , A.TASK_TYPE FROM PS_RB_TSK_DELEGATE A , PS_RSF_TEAM_MBRS B , PS_RD_PERSON C , PS_BO_NAME D WHERE A.TSK_DELEGATE_TYPE = 'S' AND A.TASK_LIST = 'MT' AND A.TSK_DELEGATE_ID = B.TEAM_ID AND C.PERSON_ID = A.PERSON_ID AND D.BO_ID = C.BO_ID AND A.START_DT <= %CurrentDateIn AND A.END_DT >= %CurrentDateIn UNION SELECT A.TASK_LIST , C.BO_ID , D.BO_NAME_DISPLAY , B.TEAM_ID , B.PERSON_ID , A.READONLY , A.TASK_TYPE FROM PS_RB_TSK_DELEGATE A , PS_RSF_TEAM_MBRS B , PS_RD_PERSON C , PS_BO_NAME D WHERE A.TSK_DELEGATE_TYPE = 'S' AND (A.TASK_LIST <> 'MT' OR A.TASK_LIST <> 'DT') AND A.TSK_DELEGATE_ID = B.TEAM_ID AND C.PERSON_ID = A.TASK_LIST AND D.BO_ID = C.BO_ID AND A.START_DT <= %CurrentDateIn AND A.END_DT >= %CurrentDateIn

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
2 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
3 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
4 TEAM_ID Character(15) VARCHAR2(15) NOT NULL Sales Team ID
5 PERSON_ID_MBR Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
6 READONLY Character(1) VARCHAR2(1) NOT NULL Read Only
7 TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Copied from Resouce Management (8.1). Added new label id for "Task Type"