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.

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