RB_TD_CAT_DT_VW (SQL View)	Index Back
Display Template View This view fetches all the Display Templates associated with the component specified for the Action Category.

RB_TD_CAT_DT_VW

(SQL View)

Display Template View

This view fetches all the Display Templates associated with the component specified for the Action Category.

SELECT A.ACTION_CAT_ID , B.DISP_TMPL_ID , C.DESCR30 FROM PS_RB_TD_ACT_CAT A ,PS_RDT_TMPL_COMP B , PS_RDT_TMPL_DEFN C WHERE B.PNLGRPNAME = A.PNLGRPNAME AND C.DISP_TMPL_ID = B.DISP_TMPL_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ACTION_CAT_ID Character(10) VARCHAR2(10) NOT NULL This is the key field for the Action Category Definition record.

2 DISP_TMPL_ID Character(30) VARCHAR2(30) NOT NULL Template identifier to define the display template.
Prompt Table: RDT_TMPL_DEFN

3 DESCR30 Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ACTION_CAT_ID	Character(10)	VARCHAR2(10) NOT NULL	This is the key field for the Action Category Definition record.
2	DISP_TMPL_ID	Character(30)	VARCHAR2(30) NOT NULL	Template identifier to define the display template. Prompt Table: RDT_TMPL_DEFN
3	DESCR30	Character(30)	VARCHAR2(30) NOT NULL	Description