RC_HISTPAGES_VW

(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.DESCR FROM PSPNLGROUP A , PSPNLDEFN 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: RC_HISTPAGE_LVW

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