EODP_QRYDSC_LVW

(SQL View)
 Index Back

Query Description View

Query Description View

SELECT A.EODP_QUERYNAME , B1.LANGUAGE_CD , B1.DESCR FROM PS_EODP_QRY_REF A , PSQRYDEFN B , PSQRYDEFNLANG B1 WHERE A.EODP_QUERYNAME = B.QRYNAME AND B.QRYNAME = B1.QRYNAME UNION SELECT A.EODP_QUERYNAME , B1.LANGUAGE_CD , B1.DESCR FROM PS_EODP_QRY_REF A , PSCONQRSDEFN B , PSCONQRSDEFNLAN B1 WHERE A.EODP_QUERYNAME = B.CONQRSNAME AND B.CONQRSNAME = B1.CONQRSNAME UNION SELECT A.EODP_QUERYNAME , B1.LANGUAGE_CD , B1.DESCR FROM PS_EODP_QRY_REF A , PSCPQDEFN B , PSCPQDEFN_LANG B1 WHERE A.EODP_QUERYNAME = B.CPQNAME AND B.CPQNAME = B1.CPQNAME

  • Related Language Record for EODP_QRYDSCR_VW

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