GB_QUERY_VW

(SQL View)
Index Back

Group Build Query View


SELECT DISTINCT A.QRYNAME , A.DESCR FROM PSQRYDEFN A , PSQRYRECORD B WHERE A.OPRID = B.OPRID AND A.QRYNAME = B.QRYNAME AND A.OPRID = ' ' AND B.RECNAME = 'GB_QRY_LINK_VW'

  • Related Language Record: GB_QUERY_VW_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description