EODP_RPT_RD_LVW

(SQL View)
 Index Back

Language view Report defn

Language view Report defn prompt record in filter

SELECT RD.REPORT_DEFN_ID ,RL.LANGUAGE_CD , RL.DESCR FROM PSXPRPTDEFN RD LEFT OUTER JOIN PSXPRPTDEFNLNG RL ON RD.REPORT_DEFN_ID = RL.REPORT_DEFN_ID WHERE RD.DS_TYPE IN ('CQR','QRY') UNION SELECT SP.EODP_SQR_NAME ,PF.LANGUAGE_CD , PF.DESCR FROM PS_EODP_SQR_REF SP LEFT OUTER JOIN PS_PRCSDEFNLANG PF ON SP.EODP_SQR_NAME = PF.PRCSNAME

  • Related Language Record for EODP_RPT_RDF_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL Report Name (see PSXPRPTDEFN).

    Prompt Table: PSXPRPTDEFN

    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description