PSTREEMGRNAV_VW

index back

SELECT DISTINCT A.MENUNAME , A.BARNAME , A.ITEMNAME MenuItem , A.ITEMLABEL MenuItemLabel ,A.PNLGRPNAME Component ,B.PNLNAME PanelName , %Substring(B.ITEMNAME,1,18) PageName , B.ITEMLABEL PageLabel FROM PSMENUITEM A , PSPNLGROUP B WHERE A.ITEMTYPE = 5 AND B.HIDDEN = 0 AND B.PNLGRPNAME = A.PNLGRPNAME AND A.MARKET = B.MARKET

PeopleSoft Field Name Field Type Column Type Description
MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).

Prompt Table: PSMENUDEFN

BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name
ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name
ITEMLABEL Character(30) VARCHAR2(30) NOT NULL Menu Item Label
PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
PAGE_NAME Character(18) VARCHAR2(18) NOT NULL Page Name
PAGELABEL Character(30) VARCHAR2(30) NOT NULL Page Label
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19