RBF_AS_FLDV_LNG

(SQL View)
 Index Back

Portal Folders list related la

Portal Folders list related language view

SELECT a.PORTAL_NAME ,a.PORTAL_OBJNAME ,b.LANGUAGE_CD , b.PORTAL_LABEL FROM PSPRSMDEFN a , PSPRSMDEFNLANG b WHERE a.PORTAL_NAME = b.PORTAL_NAME AND a.PORTAL_REFTYPE = b.PORTAL_REFTYPE AND a.PORTAL_OBJNAME = b.PORTAL_OBJNAME AND b.PORTAL_REFTYPE = 'F'

  • Related Language Record for RBF_AS_FLDER_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label