EODP_PVTDSV_LVW

(SQL View)
 Index Back

Data Source value Prompt LNG

Data Source value Prompt language rec in Pivot filter

SELECT PG.PTPG_DSVALUE , PL.LANGUAGE_CD , QD.DESCR FROM PSPGSETTINGS PG , PSPGCORELANG PL , PSQRYDEFNLANG QD WHERE PG.PTPG_PGRIDNAME = PL.PTPG_PGRIDNAME AND QD.QRYNAME = PG.PTPG_DSVALUE AND QD.LANGUAGE_CD = PL.LANGUAGE_CD UNION SELECT PG.PTPG_DSVALUE , PL.LANGUAGE_CD , PD.DESCR FROM PSPGSETTINGS PG , PSPGCORELANG PL , PSPNLGDEFNLANG PD WHERE PG.PTPG_PGRIDNAME = PL.PTPG_PGRIDNAME AND PD.PNLGRPNAME = PG.PTPG_DSVALUE AND PD.LANGUAGE_CD = PL.LANGUAGE_CD

  • Related Language Record for EODP_PVTDSV_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTPG_DSVALUE Character(30) VARCHAR2(30) NOT NULL Data Source Value

    Prompt Table: %EDITTABLE

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