PTBR_IMG_LVW

(SQL View)
 Index Back

Image Prompt - Lang


SELECT DISTINCT A.CONTNAME , B.LANGUAGE_CD , B.DESCR FROM %Table(PSCONTDEFN) A , %Table(PSCONTDEFNLANG) B WHERE A.CONTNAME =B.CONTNAME AND A.ALTCONTNUM = B.ALTCONTNUM AND A.CONTTYPE = 1

  • Related Language Record for PTBR_IMG_PVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONTNAME Character(30) VARCHAR2(30) NOT NULL Content Name
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description