RDT_TMPLCMPVW3L(SQL View) |
Index Back |
---|---|
Configured Components ViewThis view is the search view for the Display Template Details component. |
SELECT B.DISP_TMPL_ID , B.PNLGRPNAME , B.MARKET , A.LANGUAGE_CD , A.DESCR30 FROM PS_RDT_TMPL_DEFN_L A , PS_RDT_TMPL_COMP B , PS_RDT_TMPL_DEFN D WHERE D.DISP_TMPL_ID = A.DISP_TMPL_ID AND B.DISP_TMPL_ID = A.DISP_TMPL_ID |
# | 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 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
5 | DESCR30 | Character(30) | VARCHAR2(30) NOT NULL | Description |