RDT_BU_TMPL_VW

(SQL View)
 Index Back

Business Unit and Templates

This views Filters the Templates allowed for BU. This uses the Display Template Family, BU and Component Combination to filter the Display Template ID.

SELECT A.DISP_TMPL_FAM_CD , A.BUSINESS_UNIT , A.PNLGRPNAME , B.DISP_TMPL_ID , C.DESCR30 FROM PS_BUS_UNIT_RC_DEF A , PS_BUS_UNIT_RC_RDT B , PS_RDT_TMPL_DEFN C , PS_RDT_TMPL_COMP D WHERE A.DISP_TMPL_FAM_CD = B.DISP_TMPL_FAM_CD AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.DISP_TMPL_ID = C.DISP_TMPL_ID AND B.DISP_TMPL_ID = D.DISP_TMPL_ID AND A.PNLGRPNAME = D.PNLGRPNAME

  • Related Language Record: RDT_BU_TMPL_VWL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DISP_TMPL_FAM_CD Character(30) VARCHAR2(30) NOT NULL Display Template Family Code
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    4 DISP_TMPL_ID Character(30) VARCHAR2(30) NOT NULL Template identifier to define the display template.
    5 DESCR30 Character(30) VARCHAR2(30) NOT NULL Description