PTPP_CREF_PVW

Return to Index

View: PS_PTPP_CREF_PVW

Content Reference Prompt

PlatformView Text
DefaultSELECT A.PORTAL_NAME , A.PORTAL_OBJNAME , A.PORTAL_LABEL , A.PORTAL_PRNTOBJNAME , B.PORTAL_LABEL FROM PSPRSMDEFN A , PSPRSMDEFN B WHERE A.PORTAL_REFTYPE = 'C' AND A.PORTAL_CREF_URLT NOT IN('UMPG','UPTM','UPHP') AND A.PORTAL_CREF_USGT = 'TARG' AND A.PORTAL_PRNTOBJNAME NOT IN ('PORTAL_USERS' ,'PORTAL_TEMPLATES', 'PORTAL_TEMPLATE_PAGELETS') AND B.PORTAL_NAME = A.PORTAL_NAME AND B.PORTAL_OBJNAME = A.PORTAL_PRNTOBJNAME AND B.PORTAL_REFTYPE = 'F'

  • Related language record: PTPP_CREF_LVW

    • PeopleSoft Field NameDescription
    PORTAL_NAMEPortal Name
    PORTAL_OBJNAMEContent Reference Name
    PTPP_CREF_LABELContent Reference Label
    PORTAL_PRNTOBJNAMEParent Name
    PTPP_FLDR_LABELParent Label

    Author: PeopleTools

    Return to Index

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