TL_PORTALLBL_LV

(SQL View)
 Index Back

Portal Label View

View against Portal definition that helps bring in the label based on menu name and object name of the portal entry.

SELECT CREF.PORTAL_URI_SEG1 , CREF.PORTAL_OBJNAME , CREFL.PORTAL_LABEL , CREFL.LANGUAGE_CD , PL.PORTAL_LABEL FROM PSPRSMDEFN CREF , PSPRSMDEFNLANG CREFL , PSPRSMDEFN P , PSPRSMDEFNLANG PL WHERE CREF.PORTAL_NAME = 'EMPLOYEE' AND CREF.PORTAL_REFTYPE = 'C' AND CREF.PORTAL_NAME = CREFL.PORTAL_NAME AND CREF.PORTAL_REFTYPE = CREFL.PORTAL_REFTYPE AND CREF.PORTAL_OBJNAME = CREFL.PORTAL_OBJNAME AND CREF.PORTAL_NAME = P.PORTAL_NAME AND P.PORTAL_REFTYPE = 'F' AND CREF.PORTAL_PRNTOBJNAME = P.PORTAL_OBJNAME AND P.PORTAL_NAME = PL.PORTAL_NAME AND P.PORTAL_REFTYPE = PL.PORTAL_REFTYPE AND P.PORTAL_OBJNAME = PL.PORTAL_OBJNAME

  • Related Language Record for TL_PORTALLBL_VW

  • Parent record: TL_PORTALLBL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
    2 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label
    5 PORTAL_LABEL2 Character(30) VARCHAR2(30) NOT NULL Label 2