EODP_SQR_RC_LVW

(SQL View)
 Index Back

Query Records Temp Table

Sensitive Data Framework: Query Records Temp Table

SELECT SR.EODP_SQR_NAME ,SF.RECNAME ,SF.FIELDNAME ,SR.EODP_RUNCNTLCMP ,PL.LANGUAGE_CD , PL.DESCR , NI.PORTAL_NAVPATH FROM PS_EODP_SQR_REF SF , PS_EODP_NAVLANG NI , PS_EODP_SQR_RUNCNT SR LEFT OUTER JOIN PSPNLGDEFNLANG PL ON PL.PNLGRPNAME = SR.EODP_RUNCNTLCMP WHERE NI.PORTAL_NAME = SR.PORTAL_NAME AND NI.PORTAL_REFTYPE = SR.PORTAL_REFTYPE AND NI.PORTAL_OBJNAME = SR.PORTAL_OBJNAME AND SF.EODP_SQR_NAME = SR.EODP_SQR_NAME AND NI.LANGUAGE_CD = PL.LANGUAGE_CD

  • Related Language Record for EODP_SQR_RCT_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).
    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_RUNCNTLCMP Character(18) VARCHAR2(18) NOT NULL Run Control Component Name
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 PORTAL_NAVPATH Long Character CLOB Navigation Path