PMN_CURLINKS_VW

index back

SELECT R.PRCSINSTANCE , M.ITEMLABEL , R.KEYLIST , R.MARKET , R.MENUNAME , R.PNLGRPNAME , R.PNLNAME FROM PSPNLGROUP D , PS_PRCSRQSTURL R , PSMENUITEM M WHERE D.PNLGRPNAME = R.PNLGRPNAME AND D.MARKET = R.MARKET AND D.PNLNAME = R.PNLNAME AND R.SEQNO = 0 AND M.PNLGRPNAME = R.PNLGRPNAME AND M.MENUNAME = R.MENUNAME AND M.PNLGRPNAME = D.PNLGRPNAME AND M.MARKET = D.MARKET

PeopleSoft Field Name Field Type Column Type Description
PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
KEYLIST Character(254) VARCHAR2(254) NOT NULL KeyList
MARKET Character(3) VARCHAR2(3) NOT NULL Market translate values
MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19