PTPP_CPPGLT_LVW

Return to Index

View: PS_PTPP_CPPGLT_LVW

Retrieves Pagelet definitions for use in selecting which pagelets to keep during the EOPP_CPPROJ AE process.

PlatformView Text
DefaultSELECT 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 NameDescription
    PROJECTNAMEProject Name
    PORTAL_NAMEPortal Name
    MSGNODENAMEApplication Message Node Name. Name of the Application Message Node Definition.
    PORTAL_OBJNAMEPagelet Name
    LANGUAGE_CDLanguage Code translate values
    PORTAL_LABELPagelet Label

    Author: PeopleTools

    Return to Index

    © Go-Faster Consultancy Ltd.  Last updated 24 July 2010