RDT_TMPL_FAM_IP (SQL View)	Index Back
Display Template Family View This view returns all display template families of the Installed Product component. Used in Installed Product configuration page.

RDT_TMPL_FAM_IP

(SQL View)

Display Template Family View

This view returns all display template families of the Installed Product component. Used in Installed Product configuration page.

SELECT DISTINCT A.DISP_TMPL_FAM_CD , A.DESCR , A.COMMENTS254 FROM PS_RDT_TMPL_FAMILY A , PS_RDT_TMPL_DEFN B , PS_RDT_TMPL_OPT C WHERE B.DISP_TMPL_FAM_CD = A.DISP_TMPL_FAM_CD AND C.DISP_TMPL_ID = B.DISP_TMPL_ID AND C.PNLGRPNAME='RF_INST_PRODUCT'

Related Language Record: RDT_TMPL_FAM_L

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description

3 COMMENTS254 Character(254) VARCHAR2(254) NOT NULL Shorter comment field (i.e. shorter than a long character) for situations where the longer field size is not necessary (especially if there's already another Long Char field in the record)

#	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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	COMMENTS254	Character(254)	VARCHAR2(254) NOT NULL	Shorter comment field (i.e. shorter than a long character) for situations where the longer field size is not necessary (especially if there's already another Long Char field in the record)