RC_HISTPAGE_LVW

(SQL View)
 Index Back

Pages for Event Set Transfers

This view is used to get pages' name and description from Tools tables

SELECT A.PNLNAME , B.LANGUAGE_CD , B.DESCR FROM PSPNLGROUP A , PSPNLDEFNLANG B WHERE (A.PNLGRPNAME = 'RC_CASE' AND A.MARKET = 'GBL' AND A.PNLNAME = B.PNLNAME AND A.HIDDEN = 0) OR (A.PNLNAME = B.PNLNAME AND A.PNLGRPNAME = 'RB_EM_OB' AND A.MARKET = 'GBL' AND A.PNLNAME = 'RB_EM_OB_VIEW')

  • Related Language Record for RC_HISTPAGES_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description