PTCXM_DFLT_LVW

(SQL View)
 Index Back

TemplatePagelet Srch Lang 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 ,C1.LANGUAGE_CD ,C1.PORTAL_LABEL FROM PSPRSMDEFN C ,PSPRSMDEFNLANG C1 , PS_PTCXM_DISPLAY E WHERE C.PORTAL_NAME = C1.PORTAL_NAME AND C.PORTAL_OBJNAME = C1.PORTAL_OBJNAME AND 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 for PTCXM_DFLT_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label