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 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