PTCS_KIB_CMP_VW

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
1 PORTAL_URI_SEG2 Character(30) VARCHAR2(30) NOT NULL Component Name
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description