PTCS_KIB_CMP_VW

index back

SELECT DISTINCT A.PORTAL_URI_SEG2 , B.DESCR FROM PSPRSMDEFN A , PSPNLGRPDEFN B WHERE A.FLUIDMODE='1' AND A.PORTAL_REFTYPE='C' AND A.PORTAL_URI_SEG2<>' ' AND A.PORTAL_URI_SEG2=B.PNLGRPNAME

PeopleSoft Field Name Field Type Column Type Description
PORTAL_URI_SEG2 Character(30) VARCHAR2(30) NOT NULL Component Name
DESCR Character(30) VARCHAR2(30) NOT NULL Description
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20