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 NameField TypeColumn TypeDescription
PRCSINSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
DESCR60Character(60)VARCHAR2(60) NOT NULLDescription
KEYLISTCharacter(254)VARCHAR2(254) NOT NULLKeyList
MARKETCharacter(3)VARCHAR2(3) NOT NULLMarket translate values
MENUNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Name (see PSMENUDEFN).
PNLGRPNAMECharacter(18)VARCHAR2(18) NOT NULLComponent Name
PNLNAMECharacter(30)VARCHAR2(30) NOT NULLPage Name (see PSPNLDEFN).
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19