PTPP_CPNODE_VW

 index back

SELECT DISTINCT A.PROJECTNAME , B.PORTAL_NAME , B.PORTAL_CNTPRV_NAM FROM PSPROJECTITEM A , PSPRSMDEFN B WHERE A.OBJECTVALUE1 = B.PORTAL_NAME AND A.OBJECTVALUE2 = B.PORTAL_REFTYPE AND A.OBJECTVALUE3 = B.PORTAL_OBJNAME AND B.PORTAL_REFTYPE = 'C' AND A.OBJECTTYPE = 55 AND B.PORTAL_CNTPRV_NAM NOT IN ('LOCAL_NODE', ' ')

PeopleSoft Field Name Field Type Column Type Description
PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).
PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20