PTCXM_DFCREF_VW

(SQL View)
 Index Back

Template Pagelet 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 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_DFCRF_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