PTPP_CPPGLT_LVW

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 , D.LANGUAGE_CD , D.PORTAL_LABEL FROM PSPRSMDEFN B , PSPROJECTITEM C , PSPRSMDEFNLANG D 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_NAME = D.PORTAL_NAME AND B.PORTAL_REFTYPE = D.PORTAL_REFTYPE AND B.PORTAL_OBJNAME = D.PORTAL_OBJNAME 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 for PTPP_CPPGLT_VW
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PROJECTNAMECharacter(30)VARCHAR2(30) NOT NULLProject Name (see PSPROJECTDEFN).
    PORTAL_NAMECharacter(30)VARCHAR2(30) NOT NULLPortal Name (see PSPRDMDEFN).
    MSGNODENAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
    PORTAL_OBJNAMECharacter(30)VARCHAR2(30) NOT NULLPagelet Name
    LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
    PORTAL_LABELCharacter(30)VARCHAR2(30) NOT NULLPagelet Label
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19