RC_CSEINPRD_VW3

(SQL View)
Index Back

SELECT DISTINCT A.SETID , A.SETID , A.BO_ID_CUST , D.SETID , D.AGREEMENT_CODE , D.AGR_RENEWAL_NUM , D.AGREEMENT_LINE , A.PRODUCT_ID , A.INST_PROD_ID , C.DESCR , A.SERIAL_ID FROM PS_RF_INST_PROD A , PS_RF_INST_PROD_ST B , PS_PROD_ITEM C , PS_RF_UNDER_SVC D WHERE A.SETID = B.SETID AND A.INST_PROD_ID = B.INST_PROD_ID AND B.INST_PROD_STATUS <> 'UNI' AND C.SETID = ( SELECT SC.SETID FROM PS_SET_CNTRL_REC SC WHERE SC.SETCNTRLVALUE = A.SETID AND SC.RECNAME = 'PROD_ITEM') AND A.PRODUCT_ID = C.PRODUCT_ID AND A.INST_PROD_ID = D.INST_PROD_ID

  • Related Language Record: RC_CSEINPRDLVW3
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID_PRODUCT Character(5) VARCHAR2(5) NOT NULL Product SetID
    2 SETID_CUSTOMER Character(5) VARCHAR2(5) NOT NULL Customer SetID
    3 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
    4 SETID_ENTL Character(5) VARCHAR2(5) NOT NULL SetID
    5 AGREEMENT_CODE Character(30) VARCHAR2(30) NOT NULL This field represents the agreement code (name) for an agreement
    6 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)
    7 AGREEMENT_LINE Character(10) VARCHAR2(10) NOT NULL This field records the value for the agreement line number
    8 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    9 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)
    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    11 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the Serial ID of an item or installed product