CR_QRYDEFNX_LVW

(SQL View)
 Index Back

Rel Lang View for Query View

Related Language View for view that selects a distinct list of Queries from PSQRYDEFN.

SELECT DISTINCT A.QRYNAME , B.LANGUAGE_CD , A.DESCR FROM PSQRYDEFN A , PSQRYDEFNLANG B WHERE A.QRYNAME = B.QRYNAME

  • Related Language Record for CR_QRYDEFN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description