PANELNAMETL_TAB_PAGE2_VW(SQL View) |
Index Back |
|---|---|
Tab Definition DetailGet component and page details using Portal Name and Portal Object Name |
| SELECT DISTINCT %Substring(PNL.PNLNAME, 1, 18) , PNL.ITEMLABEL FROM PSPNLGROUP PNL , PSMENUITEM MNU , PSPRSMDEFN POR , PSPNLGRPDEFN GRP , PSPNLFIELD PFLD WHERE PNL.PNLGRPNAME=MNU.PNLGRPNAME AND POR.PORTAL_REFTYPE='C' AND PNL.PNLGRPNAME=GRP.PNLGRPNAME AND PNL.MARKET=GRP.MARKET AND POR.PORTAL_URI_SEG1=MNU.MENUNAME AND POR.PORTAL_URI_SEG2=GRP.PNLGRPNAME AND POR.PORTAL_URI_SEG2=MNU.PNLGRPNAME AND POR.PORTAL_URI_SEG3=GRP.MARKET AND PNL.PNLNAME = PFLD.PNLNAME AND PFLD.SUBPNLNAME = 'TL_TABFRAMEWRK_SP' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PANELNAME |
Character(18) | VARCHAR2(18) NOT NULL | Panelname |
| 2 | PAGELABEL | Character(30) | VARCHAR2(30) NOT NULL | Page Label |