PNLNAMEPAGE_SECTION_IDSECTION_STATE_IDRDT_EMB_ST_VW(SQL View) |
Index Back |
|---|---|
View on RDT_TMPL_STATE record.This view is used for the structure to cache the display templates. |
| SELECT A.PNLNAME , A.PAGE_SECTION_ID , A.SECTION_STATE_ID , A.DISP_TMPL_ID , A.PNLGRPNAME , A.MARKET , A.SORT_ORDER_NUM , A.DEFAULT_STATE_FLG , C.MESSAGE_SET_NBR , C.MESSAGE_NBR , B.APPCLASSREF FROM PS_RDT_CFG_SECTION D , PS_RDT_TMPL_STATE A , PS_RDT_CFG_STATE B , PS_RDT_LABEL_REF C WHERE D.LAYOUT_TYPE = 'EMB' AND D.PNLGRPNAME = A.PNLGRPNAME AND D.MARKET = A.MARKET AND D.PNLNAME = A.PNLNAME AND D.PAGE_SECTION_ID = A.PAGE_SECTION_ID AND A.PNLGRPNAME = B.PNLGRPNAME AND A.MARKET = B.MARKET AND A.PNLNAME = B.PNLNAME AND A.PAGE_SECTION_ID = B.PAGE_SECTION_ID AND A.SECTION_STATE_ID = B.SECTION_STATE_ID AND A.LABEL_REF_ID = C.LABEL_REF_ID AND A.VISIBLE_FLG = 'Y' AND EXISTS ( SELECT 'X' FROM PS_RDT_TMPL_FLD_ST WHERE A.DISP_TMPL_ID = PS_RDT_TMPL_FLD_ST.DISP_TMPL_ID AND A.PNLGRPNAME = PS_RDT_TMPL_FLD_ST.PNLGRPNAME AND A.MARKET = PS_RDT_TMPL_FLD_ST.MARKET AND A.PNLNAME = PS_RDT_TMPL_FLD_ST.PNLNAME AND A.PAGE_SECTION_ID = PS_RDT_TMPL_FLD_ST.PAGE_SECTION_ID AND A.SECTION_STATE_ID = PS_RDT_TMPL_FLD_ST.SECTION_STATE_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PNLNAME |
Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). |
| 2 | PAGE_SECTION_ID |
Character(15) | VARCHAR2(15) NOT NULL | Section Identifier defined for the section (various types of group boxes or grouping of fields) in the configurable component. |
| 3 | SECTION_STATE_ID |
Character(15) | VARCHAR2(15) NOT NULL | Field to identify the embedded tab (applicable for group box with embedded tabs) |
| 4 | DISP_TMPL_ID | Character(30) | VARCHAR2(30) NOT NULL | Template identifier to define the display template. |
| 5 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 6 | MARKET | Character(3) | VARCHAR2(3) NOT NULL | Market |
| 7 | SORT_ORDER_NUM | Number(3,0) | SMALLINT NOT NULL | Field to capture the sort order number. |
| 8 | DEFAULT_STATE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Flag to determine if this tab is the default tab or not. |
| 9 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 10 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 11 | APPCLASSREF | Character(30) | VARCHAR2(30) NOT NULL | Application Class ID Reference |