RDT_TMPLCOMPVW3

(SQL View)
 Index Back

Configured Components View

This view is the search view for the Display Template Details component.

SELECT B.DISP_TMPL_ID , B.PNLGRPNAME , B.MARKET , A.DESCR30 , A.DISP_TMPL_FAM_CD FROM PS_RDT_TMPL_DEFN A , PS_RDT_TMPL_COMP B , PS_RDT_TMPL_OPT C WHERE B.DISP_TMPL_ID = A.DISP_TMPL_ID AND C.DISP_TMPL_ID = B.DISP_TMPL_ID AND C.PNLGRPNAME = B.PNLGRPNAME AND C.MARKET = B.MARKET

  • Related Language Record: RDT_TMPLCMPVW3L

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DISP_TMPL_ID Character(30) VARCHAR2(30) NOT NULL Template identifier to define the display template.
    2 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

    Prompt Table: RDT_CFG_COMP_VW

    3 MARKET Character(3) VARCHAR2(3) NOT NULL Market

    Default Value: GBL

    4 DESCR30 Character(30) VARCHAR2(30) NOT NULL Description
    5 DISP_TMPL_FAM_CD Character(30) VARCHAR2(30) NOT NULL Display Template Family Code

    Prompt Table: RDT_TMPL_FAM3VW