TL_ALRT_PAGE_VW

(SQL View)
 Index Back

TL Alert Page Vw (Folder stru)

Get component and page details using Portal Name and Portal Object Name

SELECT POR.PORTAL_NAME , POR.PORTAL_OBJNAME , POR.PORTAL_LABEL , MNU.ITEMNAME , MNU.ITEMLABEL , %Substring(PNL.PNLNAME, 1, 18) FROM PSPNLGROUP PNL , PSMENUITEM MNU , PSPRSMDEFN POR WHERE PNL.PNLGRPNAME=MNU.PNLGRPNAME AND POR.PORTAL_REFTYPE='C' AND POR.PORTAL_URI_SEG1=MNU.MENUNAME AND POR.PORTAL_URI_SEG2=PNL.PNLGRPNAME AND POR.PORTAL_URI_SEG2=MNU.PNLGRPNAME AND POR.PORTAL_URI_SEG3=PNL.MARKET AND PNL.SUBITEMNUM = ( SELECT MIN(SUBITEMNUM) FROM PSPNLGROUP PG WHERE PG.PNLGRPNAME = PNL.PNLGRPNAME AND PG.MARKET=PNL.MARKET)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
2 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
3 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label
4 ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name
5 ITEMLABEL Character(30) VARCHAR2(30) NOT NULL Menu Item Label
6 PANELNAME Character(18) VARCHAR2(18) NOT NULL Panelname