EODP_PNLGRP_VW

(SQL View)
 Index Back

Component Prompt View

Component Prompt View

SELECT DISTINCT B.PNLGRPNAME , A.ITEMLABEL FROM PSMENUITEM A , PS_EODP_COMP_REF B WHERE A.PNLGRPNAME= B.PNLGRPNAME AND A.MARKET = ( SELECT MIN(C.MARKET) FROM PSMENUITEM C WHERE A.MENUNAME = C.MENUNAME AND A.BARNAME = C.BARNAME AND A.ITEMNAME = C.ITEMNAME )

  • Related Language Record: EODP_PNLGRP_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    2 ITEMLABEL Character(30) VARCHAR2(30) NOT NULL Menu Item Label