RF_INSP_AGR_VW

(SQL View)
 Index Back

Installed Products - Act Agrmt

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

SELECT DISTINCT A.SETID , E.INST_PROD_ID , A.AGREEMENT_CODE , B.AGREEMENT_LINE , B.AGRT_LN_STATUS 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 AGREEMENT_LINE Character(10) VARCHAR2(10) NOT NULL This field records the value for the agreement line number
5 AGRT_LN_STATUS Character(3) VARCHAR2(3) NOT NULL Field for Storing the Agreement Line Status
001=1-Pending
005=2-Active
009=3-Closed