ACLCOMPCREF_VW

index back

SELECT A.MENUNAME , A.ITEMNUM , A.PNLGRPNAME , B.MARKET FROM PSMENUITEM A , PSPNLGRPDEFN B WHERE A.ITEMTYPE = 5 AND A.PNLGRPNAME = B.PNLGRPNAME AND A.MARKET = B.MARKET

PeopleSoft Field NameField TypeColumn TypeDescription
MENUNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Name (see PSMENUDEFN).

Prompt Table: PSMENUDEFN

ITEMNUMNumber(4,0)SMALLINT NOT NULLItem Number
PNLGRPNAMECharacter(18)VARCHAR2(18) NOT NULLComponent Name
MARKETCharacter(3)VARCHAR2(3) NOT NULLMarket translate values
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19