EOPM_CMPN2_VWL

(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.LANGUAGE_CD ,B.DESCR FROM PSMENUITEM A , PSPNLGDEFNLANG B WHERE A.ITEMTYPE = 5 AND A.PNLGRPNAME = B.PNLGRPNAME

  • Related Language Record for EOPM_CMPN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description