RC_PROD_W_V1

(SQL View)
Index Back

Product prompt

Prompt on all products for the selected product group covered in the warranty.

SELECT DISTINCT A.SETID ,B.WARRANTY_NAME ,A.PRODUCT_GROUP ,A.PRODUCT_ID ,B.DESCR FROM PS_PROD_PGRP_LNK A ,PS_RC_PROD_W_VW B WHERE A.SETID=B.SETID AND A.PRODUCT_ID=B.PRODUCT_ID

  • Related Language Record: RC_PROD_WLV1
  • # 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.
    2 WARRANTY_NAME Character(40) VARCHAR2(40) NOT NULL This field is used to store the name of the warranty.
    3 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group
    4 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description