PTCXM_DFLT_VW

index back

TemplatePagelet Search View

The view includes the portal objects that use dynamic template and have been set up in Context Manager either through Assign Template or Default Template.
SELECT DISTINCT C.PORTAL_NAME ,C.PORTAL_OBJNAME ,C.PORTAL_LABEL ,E.PTCXM_OBJNAME FROM PSPRSMDEFN C , PS_PTCXM_DISPLAY E WHERE C.PORTAL_NAME = E.PORTAL_NAME AND C.PORTAL_REFTYPE = 'C' AND (C.PORTAL_OBJNAME = E.PORTAL_OBJNAME OR (C.PORTAL_OBJNAME <> E.PTCXM_OBJNAME AND E.PORTAL_OBJNAME = 'PORTAL_ROOT_OBJECT' AND ((C.PORTAL_TEMPL_NAME = 'PTCXM_DYNAMIC_CON_TEMPLATE') OR ((C.PORTAL_TEMPL_NAME = ' ') AND EXISTS ( SELECT V.PORTAL_CNTPRV_NAM FROM PSPRDMCNTPRV V WHERE V.PORTAL_NAME = C.PORTAL_NAME AND V.PORTAL_CNTPRV_NAM = C.PORTAL_CNTPRV_NAM AND V.PORTAL_TEMPL_NAME = 'PTCXM_DYNAMIC_CON_TEMPLATE' )) OR ((C.PORTAL_TEMPL_NAME = ' ') AND EXISTS ( SELECT X.MSGNODENAME FROM PSMSGNODEDEFN X , PSPRDMCNTPRV Y WHERE X.LOCALDEFAULTFLG ='Y' AND X.MSGNODENAME = Y.PORTAL_CNTPRV_NAM AND Y.PORTAL_TEMPL_NAME='PTCXM_DYNAMIC_CON_TEMPLATE')) OR ((C.PORTAL_TEMPL_NAME = ' ') AND EXISTS ( SELECT Z.PORTAL_NAME FROM PSPRDMDEFN Z WHERE Z.PORTAL_NAME = C.PORTAL_NAME AND Z.PORTAL_TEMPL_NAME='PTCXM_DYNAMIC_CON_TEMPLATE')))))

  • Related language record: PTCXM_DFLT_LVW
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PORTAL_NAMECharacter(30)VARCHAR2(30) NOT NULLPortal Name (see PSPRDMDEFN).
    PORTAL_OBJNAMECharacter(30)VARCHAR2(30) NOT NULLPortal Object Name
    PORTAL_LABELCharacter(30)VARCHAR2(30) NOT NULLPortal Label
    PTCXM_OBJNAMECharacter(30)VARCHAR2(30) NOT NULLTemplate Pagelet Name
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19