PTPP_CPPGLT_VW

index back

Pagelet Objects

Retrieves Pagelet definitions for use in selecting which pagelets to keep during the EOPP_CPPROJ AE process.
SELECT C.PROJECTNAME , B.PORTAL_NAME , B.PORTAL_CNTPRV_NAM , B.PORTAL_OBJNAME , B.PORTAL_LABEL FROM PSPRSMDEFN B , PSPROJECTITEM C WHERE C.OBJECTTYPE = 55 AND B.PORTAL_NAME = C.OBJECTVALUE1 AND B.PORTAL_REFTYPE = C.OBJECTVALUE2 AND B.PORTAL_OBJNAME = C.OBJECTVALUE3 AND B.PORTAL_REFTYPE = 'C' AND B.PORTAL_CREF_USGT = 'HPGC' AND B.PORTAL_OBJNAME NOT LIKE 'PT%' AND B.PORTAL_OBJNAME NOT LIKE 'PA%' AND B.PORTAL_OBJNAME NOT LIKE 'PORTAL%' AND B.OBJECTOWNERID NOT IN ('PPT','ENV','PPTD') AND B.PORTAL_PRODUCT NOT IN ('PT', 'AE', 'PRTL') AND B.PORTAL_CNTPRV_NAM NOT LIKE 'PSFT%'

  • Related language record: PTPP_CPPGLT_LVW
  • 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).
    PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Pagelet Name
    PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Pagelet Label
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19