RQ_PROD_DESC_VW

(SQL View)
Index Back

Defect Product view

Quality application Product Description

SELECT A.SETID , A.PRODUCT_ID , A.DESCR , B.R_PRODUCTION_ID FROM PS_PROD_ITEM A , PS_RQ_PRODUCTION B WHERE A.SETID = B.SETID AND A.PRODUCT_ID = B.PRODUCT_ID

  • Related Language Record: RQ_PRDDSCR_LGVW
  • # 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.

    Prompt Table: SP_SETID_NONVW

    2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    3 PRODUCTDESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 R_PRODUCTION_ID Character(15) VARCHAR2(15) NOT NULL Production Identification number for Quality Application