PTAL_FREF_PVW

index back

Folder Prompt


SELECT PORTAL_NAME , PORTAL_OBJNAME , PORTAL_LABEL FROM %Table(PSPRSMDEFN) WHERE PORTAL_REFTYPE = 'F' AND PORTAL_OBJNAME NOT IN ('PORTAL_BASE_DATA', 'PORTAL_HP_TAB', 'PORTAL_PAGELETS', 'MYFAVORITES') AND PORTAL_PRNTOBJNAME NOT IN ('PORTAL_BASE_DATA', 'PORTAL_HP_TAB', 'PORTAL_PAGELETS') AND (PORTAL_PRODUCT <> 'CFAN' OR PORTAL_PRNTOBJNAME = 'CO_NAVIGATION_COLLECTIONS')

  • Related language record: PTAL_FREF_LVW
  • PeopleSoft Field Name Field Type Column Type Description
    PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
    PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19