EODP_QRYDSCR_VW

(SQL View)
 Index Back

Query Description View

Query Description View

SELECT A.EODP_QUERYNAME , B.DESCR FROM PS_EODP_QRY_REF A , PSQRYDEFN B WHERE A.EODP_QUERYNAME = B.QRYNAME UNION SELECT A.EODP_QUERYNAME , B.DESCR FROM PS_EODP_QRY_REF A , PSCONQRSDEFN B WHERE A.EODP_QUERYNAME = B.CONQRSNAME UNION SELECT A.EODP_QUERYNAME , B.DESCR FROM PS_EODP_QRY_REF A , PSCPQDEFN B WHERE A.EODP_QUERYNAME = B.CPQNAME

  • Related Language Record: EODP_QRYDSC_LVW

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