RSF_OPP_TSK3_VW (SQL View)	Index Back
View for Oppy Task Task view for Oppy Component. Used by Oppy Component.

RSF_OPP_TSK3_VW

(SQL View)

View for Oppy Task

Task view for Oppy Component. Used by Oppy Component.

SELECT C.PERSON_ID_OWNER , C.START_DATE , C.END_DATE , A.TASK_ID , B.OPPORTUNITY_ID , A.RB_TRANSACTION_ID , C.DESCR60 , C.TASK_TYPE , C.TASK_STATUS , C.TASK_PRIORITY , C.DESCRLONG , B.OPPORTUNITY_NAME , D.SALES_USER_NAME , B.NAME1 , B.NAME FROM PS_RB_TSK_TXN A , PS_RSF_OPPORTUNITY B , PS_RB_TSK C , PS_RSF_PERSON_VW D WHERE A.REL_TXN_SYNCID = B.SYNCID AND A.TASK_ID = C.TASK_ID AND A.RB_TRANSACTION_ID = 'OPPRT' AND A.TXN_MARKET = 'GBL' AND C.PERSON_ID_OWNER = D.CONTACT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PERSON_ID_OWNER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
Prompt Table: RB_WORKER_SRCH

2 START_DATE Date(10) DATE Start Date for Gen Standing PO

3 END_DATE Date(10) DATE End date field to store an end date.

4 TASK_ID Number(15,0) DECIMAL(15) NOT NULL TaskIID field. Key for RB_TSK record. Used by Task Management.

5 OPPORTUNITY_ID Character(15) VARCHAR2(15) NOT NULL Opportunity ID

6 RB_TRANSACTION_ID Character(25) VARCHAR2(25) NOT NULL Transaction ID

7 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description

8 TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Copied from Resouce Management (8.1). Added new label id for "Task Type"
Prompt Table: RSF_TSK_TYPE_VW

9 TASK_STATUS Character(4) VARCHAR2(4) NOT NULL Task Status
CMPL=Completed
CNCL=Canceled
INPR=In Progress
OPEN=Open
Default Value: OPEN

10 TASK_PRIORITY Character(4) VARCHAR2(4) NOT NULL Task Priority indicator for Task. Used in Task Management.
Default Value: 3
Prompt Table: RB_TSK_PRTY_VW

11 DESCRLONG Long Character CLOB Long Description

12 OPPORTUNITY_NAME Character(50) VARCHAR2(50) NOT NULL Opportunity Name - User Enters this field in Mixed Case.

13 SALES_USER_NAME Character(50) VARCHAR2(50) NOT NULL Sales User Name field

14 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.

15 NAME Character(50) VARCHAR2(50) NOT NULL Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PERSON_ID_OWNER	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts Prompt Table: RB_WORKER_SRCH
2	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
3	END_DATE	Date(10)	DATE	End date field to store an end date.
4	TASK_ID	Number(15,0)	DECIMAL(15) NOT NULL	TaskIID field. Key for RB_TSK record. Used by Task Management.
5	OPPORTUNITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Opportunity ID
6	RB_TRANSACTION_ID	Character(25)	VARCHAR2(25) NOT NULL	Transaction ID
7	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
8	TASK_TYPE	Character(18)	VARCHAR2(18) NOT NULL	Copied from Resouce Management (8.1). Added new label id for "Task Type" Prompt Table: RSF_TSK_TYPE_VW
9	TASK_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Task Status CMPL=Completed CNCL=Canceled INPR=In Progress OPEN=Open Default Value: OPEN
10	TASK_PRIORITY	Character(4)	VARCHAR2(4) NOT NULL	Task Priority indicator for Task. Used in Task Management. Default Value: 3 Prompt Table: RB_TSK_PRTY_VW
11	DESCRLONG	Long Character	CLOB	Long Description
12	OPPORTUNITY_NAME	Character(50)	VARCHAR2(50) NOT NULL	Opportunity Name - User Enters this field in Mixed Case.
13	SALES_USER_NAME	Character(50)	VARCHAR2(50) NOT NULL	Sales User Name field
14	NAME1	Character(50)	VARCHAR2(50) NOT NULL	Generic 50 character name field for storing names.
15	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name