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 Name Field Type Column Type Description
MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).

Prompt Table: PSMENUDEFN

ITEMNUM Number(4,0) SMALLINT NOT NULL Item Number
PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
MARKET Character(3) VARCHAR2(3) NOT NULL Market translate values
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19