GP_MT_CR_LNG

(SQL View)
 Index Back

RelLang for Rec in a Component

RelLang record for recordnames per component.

SELECT DISTINCT PG.PNLGRPNAME , PF.RECNAME , RD.LANGUAGE_CD , RD.RECDESCR FROM PSPNLGROUP PG , PSPNLFIELD PF , PSRECDEFNLANG RD WHERE RD.RECNAME = PF.RECNAME AND PF.ASSOCFIELDNUM = 0 AND PF.PNLNAME<>' ' AND (PF.PNLNAME = PG.PNLNAME OR PF.PNLNAME IN ( SELECT PF1.SUBPNLNAME FROM PSPNLGROUP PG1 , PSPNLFIELD PF1 WHERE PG1.PNLGRPNAME = PG.PNLGRPNAME AND PF1.PNLNAME = PG1.PNLNAME))

  • Related Language Record for GP_MT_CREC_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description