PMN_URLLINKS_VW

index back

SELECT P.PRCSINSTANCE , R.DESCR60 , S.KEYLIST , S.MARKET , S.MENUNAME , S.PNLGRPNAME , S.PNLNAME FROM PSPRCSRQST P , PS_PRCSDEFN Q , PS_PRCSDEFNURL R , PS_PRCSRQSTURL S WHERE P.PRCSTYPE = Q.PRCSTYPE AND P.PRCSNAME = Q.PRCSNAME AND P.PRCSTYPE = R.PRCSTYPE AND P.PRCSNAME = R.PRCSNAME AND S.PRCSINSTANCE = P.PRCSINSTANCE AND S.SEQNO = R.SEQNO

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