PTPG_PGVW_VWLNG

index back

PVG Viewer View


SELECT DISTINCT A.PTPG_PGRIDNAME ,B.PTPG_DSVALUE ,A.LANGUAGE_CD ,C.PTPVG_VIEWDESCR ,A.PTPG_PGRIDTITLE FROM PSPGCORELANG A , PSPGSETTINGS B , PSPGVIEWOPTLANG C WHERE A.PTPG_PGRIDNAME=B.PTPG_PGRIDNAME AND A.PTPG_PGRIDNAME=C.PTPG_PGRIDNAME AND A.LANGUAGE_CD=C.LANGUAGE_CD

  • Related language record for PTPG_PGVW_VW
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PTPG_PGRIDNAMECharacter(30)VARCHAR2(30) NOT NULLPivot Grid Name (see PSPGCORE).
    PTPG_DSNAMECharacter(30)VARCHAR2(30) NOT NULLData Source Name
    LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
    PTPVG_VIEWDESCRCharacter(254)VARCHAR2(254) NOT NULLView Description
    PTPG_PGRIDTITLECharacter(30)VARCHAR2(30) NOT NULLPivot Grid Title
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19