PTPP_CPPAGE_VW

Return to Index

View: PS_PTPP_CPPAGE_VW

Retrieves Page definitions for use in selecting which pages to keep during the EOPP_CPPROJ AE process.

PlatformView Text
DefaultSELECT DISTINCT A.PROJECTNAME ,B.PORTAL_NAME ,B.PORTAL_CNTPRV_NAM ,B.PORTAL_OBJNAME ,B.PORTAL_LABEL 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_PRODUCT = 'CFAN' AND B.PORTAL_CREF_USGT = 'TARG' AND B.PORTAL_REFTYPE = 'C' AND B.PORTAL_OBJNAME LIKE '%SC_SP%' AND A.OBJECTTYPE = 55

  • Related language record: PTPP_CPPAGE_LVW

    • PeopleSoft Field NameDescription
    PROJECTNAMEProject Name
    PORTAL_NAMEPortal Name
    MSGNODENAMEApplication Message Node Name. Name of the Application Message Node Definition.
    PORTAL_OBJNAMECollection Name
    PORTAL_LABELCollection Label

    Author: PeopleTools

    Return to Index

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