XREF_MENU_VW

index back

Records used on menus


select a.searchrecname, b.menuname, c.itemname, a.pnlgrpname from pspnlgrpdefn a, psmenuitem b, pspnlgroup c where a.pnlgrpname = b.pnlgrpname and a.pnlgrpname = c.pnlgrpname and a.market = b.market and a.market = c.market

PeopleSoft Field Name Field Type Column Type Description
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name
PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19