EODP_PNLLBL_LVW

(SQL View)
 Index Back

Page label view

Data Privacy Framework: Page label view

SELECT A.PNLNAME ,A.LANGUAGE_CD ,COALESCE (B.ITEMLABEL ,C.MESSAGE_TEXT) FROM (PS_EODP_CMPRF_LANG A LEFT OUTER JOIN PSPNLGROUPLANG B ON A.PNLGRPNAME=B.PNLGRPNAME AND A.PNLNAME=B.PNLNAME AND A.LANGUAGE_CD=B.LANGUAGE_CD) ,PSMSGCATLANG C WHERE A.PNLGRPNAME<>' ' AND C.MESSAGE_SET_NBR=18111 AND C.MESSAGE_NBR=28090 AND C.LANGUAGE_CD=A.LANGUAGE_CD UNION SELECT A.PNLNAME ,A.LANGUAGE_CD ,COALESCE (B.ITEMLABEL ,C.MESSAGE_TEXT) FROM (PS_EODP_CMPRF_LANG A LEFT OUTER JOIN PSPNLGROUPLANG B ON A.PNLGRPNAME=B.PNLGRPNAME AND A.PNLNAME=B.PNLNAME AND A.LANGUAGE_CD=B.LANGUAGE_CD) ,PSMSGCATLANG C WHERE A.PNLGRPNAME<>' ' AND C.MESSAGE_SET_NBR=18111 AND C.MESSAGE_NBR=25815 AND C.LANGUAGE_CD=A.LANGUAGE_CD UNION SELECT A.PNLNAME ,A.LANGUAGE_CD ,A.DESCR FROM PSPNLDEFNLANG A , PS_EODP_CMPRF_LANG B WHERE A.PNLNAME=B.PNLNAME AND A.LANGUAGE_CD=B.LANGUAGE_CD AND NOT EXISTS ( SELECT 'X' FROM PSPNLGROUP X WHERE X.PNLNAME=A.PNLNAME)

  • Related Language Record for EODP_PNLLBL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 ITEMLABEL Character(30) VARCHAR2(30) NOT NULL Menu Item Label