DISP_TMPL_FAM_CD_PDISP_TMPL_IDLANGUAGE_CDRDT_TMPL_DFN_PL(SQL View) |
Index Back |
|---|---|
Display Template ViewThis view returns all display templates assigned to a particular family. |
| SELECT A.DISP_TMPL_FAM_CD , A.DISP_TMPL_ID , C.LANGUAGE_CD , C.DESCR30 FROM PS_RDT_TMPL_DEFN A ,PS_RDT_TMPL_COMP B , PS_RDT_TMPL_DEFN_L C WHERE A.DISP_TMPL_ID=B.DISP_TMPL_ID AND A.DISP_TMPL_ID=C.DISP_TMPL_ID AND B.PNLGRPNAME='RF_INST_PRODUCT' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DISP_TMPL_FAM_CD_P |
Character(30) | VARCHAR2(30) NOT NULL | Display Template Family Code |
| 2 | DISP_TMPL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Template identifier to define the display template. |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR30 | Character(30) | VARCHAR2(30) NOT NULL | Description |