EODP_RPT_RE_LVW

(SQL View)
 Index Back

Report Ref Page LNG View


SELECT RP.REPORT_DEFN_ID , RP.RECNAME , RP.FIELDNAME ,'BIP' ,RL.LANGUAGE_CD ,RL.DESCR FROM PS_EODP_REPORT_REF RP LEFT OUTER JOIN PSXPRPTDEFN RD ON RP.REPORT_DEFN_ID = RD.REPORT_DEFN_ID LEFT OUTER JOIN PSXPRPTDEFNLNG RL ON RL.REPORT_DEFN_ID = RD.REPORT_DEFN_ID , PS_EODP_RECFLDDB RF WHERE RP.RECNAME = RF.RECNAME AND RP.FIELDNAME = RF.FIELDNAME UNION SELECT SP.EODP_SQR_NAME , SP.RECNAME , SP.FIELDNAME ,'SQR' ,PF.LANGUAGE_CD ,PF.DESCR FROM PS_EODP_SQR_REF SP LEFT OUTER JOIN PS_PRCSDEFNLANG PF ON SP.EODP_SQR_NAME = PF.PRCSNAME , PS_EODP_RECFLDDB RF WHERE SP.RECNAME = RF.RECNAME AND SP.FIELDNAME = RF.FIELDNAME

  • Related Language Record for EODP_RPT_REF_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: EODP_RPT_RDF_VW

    2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: EODP_RECORD_VW

    3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: EODP_FIELD_VW

    4 EODP_REP_TYPE Character(3) VARCHAR2(3) NOT NULL Report Type
    BIP=BIP
    SQR=SQR
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description