PTBR_CSSPTN_LVW

(SQL View)
Index Back

Theme CSS Pattern Prompt - Lan


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 = 4 AND A.CONTNAME LIKE 'PTBR_CSSPTN_%'

  • Related Language Record for PTBR_CSSPTN_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