PTCXM_DFLT_LVW

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 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
    LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
    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