RF_UNDR_SVC_VW3 (SQL View)	Index Back
Products Under Service Agreement Line Installed Products view

RF_UNDR_SVC_VW3

(SQL View)

Products Under Service

Agreement Line Installed Products view

SELECT A.SETID , B.AGREEMENT_CODE , B.AGR_RENEWAL_NUM , C.AGREEMENT_LINE , I.INST_PROD_ID , B.BO_ID_CUST , C.START_DT , B.AGRT_STATUS , C.END_DT , I.PRODUCT_ID , I.INV_ITEM_ID , I.BO_ID_CONTACT , I.ROLE_TYPE_ID_CNTCT , I.SERIAL_ID , I.SITE_ID , I.PERSON_ID , I.DEPTID , I.LOCATION , I.ASSETTAG FROM PS_RF_AG_LINE_PROD A , PS_RF_AGREEMENT B , PS_RF_AGREEMENT_LN C , PS_RF_INST_PROD I , PS_SET_CNTRL_REC S WHERE A.SETID = B.SETID AND A.SETID = C.SETID AND A.AGREEMENT_CODE = B.AGREEMENT_CODE AND A.AGREEMENT_CODE = C.AGREEMENT_CODE AND A.AGR_RENEWAL_NUM = B.AGR_RENEWAL_NUM AND A.AGR_RENEWAL_NUM = C.AGR_RENEWAL_NUM AND A.AGREEMENT_LINE = C.AGREEMENT_LINE AND A.PRODUCT_ID = I.PRODUCT_ID AND I.SETID = S.SETID AND S.SETCNTRLVALUE = A.SETID AND S.RECNAME = 'RF_INST_PROD'

# 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)

4 AGREEMENT_LINE Character(10) VARCHAR2(10) NOT NULL This field records the value for the agreement line number

5 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)

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

7 START_DT Date(10) DATE Start date field to store start date value.

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

9 END_DT Date(10) DATE This field stores the end date values.

10 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

11 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

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

14 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the Serial ID of an item or installed product

15 SITE_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

16 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

17 DEPTID Character(15) VARCHAR2(15) NOT NULL Department

18 LOCATION Character(15) VARCHAR2(15) NOT NULL This field stores the Location Code.

19 ASSETTAG Character(40) VARCHAR2(40) NOT NULL Asset Tag

#	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)
4	AGREEMENT_LINE	Character(10)	VARCHAR2(10) NOT NULL	This field records the value for the agreement line number
5	INST_PROD_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the installed product ID (key field)
6	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
7	START_DT	Date(10)	DATE	Start date field to store start date value.
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
9	END_DT	Date(10)	DATE	This field stores the end date values.
10	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
11	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
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
14	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the Serial ID of an item or installed product
15	SITE_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
16	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
17	DEPTID	Character(15)	VARCHAR2(15) NOT NULL	Department
18	LOCATION	Character(15)	VARCHAR2(15) NOT NULL	This field stores the Location Code.
19	ASSETTAG	Character(40)	VARCHAR2(40) NOT NULL	Asset Tag