EOPM_CMPN_VW

(SQL View)
 Index Back

PUM Component Prompt

PUM Automated security Update: prompt view to prompt by components associated with a menu within a permission list.

SELECT DISTINCT A.PNLGRPNAME ,B.DESCR ,A.MENUNAME FROM PSMENUITEM A , PSPNLGRPDEFN B WHERE A.ITEMTYPE = 5 AND A.PNLGRPNAME = B.PNLGRPNAME

  • Related Language Record: EOPM_CMPN2_VWL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).

    Prompt Table: PSMENUDEFN