PTPP_CPPAGE_LVW

Return to Index

View: PS_PTPP_CPPAGE_LVW

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 ,C.LANGUAGE_CD ,C.PORTAL_LABEL FROM PSPROJECTITEM A , PSPRSMDEFN B , PSPRSMDEFNLANG C WHERE A.OBJECTVALUE1 = B.PORTAL_NAME AND A.OBJECTVALUE2 = B.PORTAL_REFTYPE AND A.OBJECTVALUE3 = B.PORTAL_OBJNAME AND B.PORTAL_NAME = C.PORTAL_NAME AND B.PORTAL_REFTYPE = C.PORTAL_REFTYPE AND B.PORTAL_OBJNAME = C.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 for PTPP_CPPAGE_VW

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

    Author: PeopleTools

    Return to Index

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