PTCXM_DFLT_VW

(SQL View)
 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 Name PeopleSoft Field Type Database Column Type Description
    1 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
    2 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    3 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label
    4 PTCXM_OBJNAME Character(30) VARCHAR2(30) NOT NULL Template Pagelet Name