TL_TAB_PAGE_VW

(SQL View)
 Index Back

Tab Definition Detail

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

SELECT POR.PORTAL_NAME , POR.PORTAL_OBJNAME , POR.PORTAL_LABEL , MNU.MENUNAME , MNU.BARNAME , MNU.ITEMNAME , MNU.ITEMLABEL , MNU.PNLGRPNAME , MNU.MARKET , %Substring(PNL.PNLNAME, 1, 18) , PNL.ITEMLABEL , PNL.SUBITEMNUM 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 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 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
5 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name
6 ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name
7 ITEMLABEL Character(30) VARCHAR2(30) NOT NULL Menu Item Label
8 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
9 MARKET Character(3) VARCHAR2(3) NOT NULL Market
10 PANELNAME Character(18) VARCHAR2(18) NOT NULL Panelname
11 PAGELABEL Character(30) VARCHAR2(30) NOT NULL Page Label
12 SUBITEMNUM Number(4,0) SMALLINT NOT NULL Sub Item Number