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 NameField TypeColumn TypeDescription
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
MENUNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Name (see PSMENUDEFN).
ITEMNAMECharacter(30)VARCHAR2(30) NOT NULLItem Name
PNLGRPNAMECharacter(18)VARCHAR2(18) NOT NULLComponent Name
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19