SAA_RQRUSE_S_VW

(SQL View)
 Index Back

View to select rqrmnt usages

View that selects all requirement usages other than 'ENR', 'SHR', and 'PLNR'.

SELECT RQRMNT_USE_VAL , DESCR FROM PS_RQRMNT_USE_TBL WHERE RQRMNT_USE_VAL <> 'ENR' AND RQRMNT_USE_VAL <> 'SHR' AND RQRMNT_USE_VAL <> 'PLNR'

  • Related Language Record: SAARQRUSEVWLANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RQRMNT_USE_VAL Character(4) VARCHAR2(4) NOT NULL Requirement Usage
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description