RF_AGREESRC2_VW (SQL View)	Index Back
Agreement Search View Agreement Component Search View

RF_AGREESRC2_VW

(SQL View)

Agreement Search View

Agreement Component Search View

SELECT A.SETID , A.AGREEMENT_CODE , A.AGR_RENEWAL_NUM , C.BO_NAME , C.BO_NAME_AC , D.BO_NAME , D.BO_NAME_AC , A.AGRT_STATUS , A.AGREEMENT_CATEGORY , A.BO_ID_CUST , A.ROLE_TYPE_ID_CUST , A.BO_ID_CONTACT , A.ROLE_TYPE_ID_CNTCT FROM PS_RF_AGREEMENT A , PS_BO_NAME C , PS_BO_NAME D WHERE AGR_TEMPLATE_ID = ' ' AND C.BO_ID(+) = A.BO_ID_CUST AND C.PRIMARY_IND(+) = 'Y' AND D.BO_ID(+) = A.BO_ID_CONTACT AND D.PRIMARY_IND(+) = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_RB.SETID
Prompt Table: SP_SETID_NONVW

2 AGREEMENT_CODE Character(30) VARCHAR2(30) NOT NULL This field represents the agreement code (name) for an agreement

3 AGR_RENEWAL_NUM Number(4,0) SMALLINT NOT NULL This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal)
Default Value: 1

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

5 BO_NAME_AC Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

6 BO_NAME_2 Character(50) VARCHAR2(50) NOT NULL BO Name 2

7 BO_NAME_CONTACT_AC Character(50) VARCHAR2(50) NOT NULL Alt-Char Contact Name

8 AGRT_STATUS Character(3) VARCHAR2(3) NOT NULL This field represents the agreement status value.
001=Pending
002=Pending Activation
003=Action Required
005=Active
009=Closed
Default Value: 005

9 AGREEMENT_CATEGORY Character(1) VARCHAR2(1) NOT NULL Field for defining the Category for the Agreement, to be used in the Agreement Header Record.
1=External
2=Internal
3=External - No Pricing

10 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.

11 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer

12 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.

13 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW
2	AGREEMENT_CODE	Character(30)	VARCHAR2(30) NOT NULL	This field represents the agreement code (name) for an agreement
3	AGR_RENEWAL_NUM	Number(4,0)	SMALLINT NOT NULL	This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal) Default Value: 1
4	BO_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
5	BO_NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
6	BO_NAME_2	Character(50)	VARCHAR2(50) NOT NULL	BO Name 2
7	BO_NAME_CONTACT_AC	Character(50)	VARCHAR2(50) NOT NULL	Alt-Char Contact Name
8	AGRT_STATUS	Character(3)	VARCHAR2(3) NOT NULL	This field represents the agreement status value. 001=Pending 002=Pending Activation 003=Action Required 005=Active 009=Closed Default Value: 005
9	AGREEMENT_CATEGORY	Character(1)	VARCHAR2(1) NOT NULL	Field for defining the Category for the Agreement, to be used in the Agreement Header Record. 1=External 2=Internal 3=External - No Pricing
10	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
11	ROLE_TYPE_ID_CUST	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the customer
12	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
13	ROLE_TYPE_ID_CNTCT	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the contact