EODP_PNLLBL_VW

(SQL View)
 Index Back

Page label view

Data Privacy Framework: Page label view

SELECT A.PNLNAME ,COALESCE (B.ITEMLABEL ,C.MESSAGE_TEXT ,A.PNLNAME ) FROM (PS_EODP_COMP_REF A LEFT OUTER JOIN PSPNLGROUP B ON A.PNLGRPNAME=B.PNLGRPNAME AND A.PNLNAME=B.PNLNAME) ,PSMSGCATDEFN C WHERE A.PNLGRPNAME <>'BLANK_DP' AND A.PNLNAME ='SEARCH_PAGE_DP' AND C.MESSAGE_SET_NBR=18111 AND C.MESSAGE_NBR=28090 UNION SELECT A.PNLNAME ,COALESCE (B.ITEMLABEL ,C.MESSAGE_TEXT ,A.PNLNAME ) FROM (PS_EODP_COMP_REF A LEFT OUTER JOIN PSPNLGROUP B ON A.PNLGRPNAME=B.PNLGRPNAME AND A.PNLNAME=B.PNLNAME) ,PSMSGCATDEFN C WHERE A.PNLGRPNAME <>'BLANK_DP' AND A.PNLNAME ='PROMPT_PAGE_DP' AND C.MESSAGE_SET_NBR=18111 AND C.MESSAGE_NBR=25815 UNION SELECT A.PNLNAME ,A.DESCR FROM PSPNLDEFN A , PS_EODP_COMP_REF B WHERE A.PNLNAME=B.PNLNAME AND NOT EXISTS ( SELECT 'X' FROM PSPNLGROUP X WHERE X.PNLNAME=A.PNLNAME) AND B.PNLGRPNAME='BLANK_DP' UNION SELECT A.PNLNAME ,A.ITEMLABEL FROM PSPNLGROUP A , PS_EODP_COMP_REF B WHERE A.PNLGRPNAME=B.PNLGRPNAME AND A.PNLNAME=B.PNLNAME

  • Related Language Record: EODP_PNLLBL_LVW

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