RF_INSP_AGR2_VW (SQL View)	Index Back
Agreement lines - Act Agrmts Lists agreement lines on Active Agreements - Used as agreement prompt table in Preventive Maintenance.

RF_INSP_AGR2_VW

(SQL View)

Agreement lines - Act Agrmts

Lists agreement lines on Active Agreements - Used as agreement prompt table in Preventive Maintenance.

SELECT DISTINCT A.SETID ,E.INST_PROD_ID , A.AGREEMENT_CODE , A.AGR_RENEWAL_NUM , B.AGREEMENT_LINE FROM PS_RF_AGREEMENT A , PS_RF_AGREEMENT_LN B , PS_RF_UNDER_SVC E WHERE A.SETID = B.SETID AND A.AGREEMENT_CODE = B.AGREEMENT_CODE AND A.AGR_RENEWAL_NUM = B.AGR_RENEWAL_NUM AND A.AGRT_STATUS = '005' AND B.SETID = E.SETID AND B.AGREEMENT_CODE = E.AGREEMENT_CODE AND B.AGR_RENEWAL_NUM = E.AGR_RENEWAL_NUM AND B.AGREEMENT_LINE = E.AGREEMENT_LINE AND EXISTS ( SELECT 1 FROM PS_RF_SERVICE C WHERE C.SETID = ( SELECT D.SETID FROM PS_SET_CNTRL_REC D WHERE D.SETCNTRLVALUE = A.SETID AND D.RECNAME = 'RF_SERVICE') AND C.SERVICE_ID=B.SERVICE_ID AND C.PRVNT_MNTC_FLAG = '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 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)

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

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

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

#	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	INST_PROD_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the installed product ID (key field)
3	AGREEMENT_CODE	Character(30)	VARCHAR2(30) NOT NULL	This field represents the agreement code (name) for an agreement
4	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)
5	AGREEMENT_LINE	Character(10)	VARCHAR2(10) NOT NULL	This field records the value for the agreement line number