EODP_PNLGRP_LVW

(SQL View)
 Index Back

Component Prompt View

Component Prompt View

SELECT DISTINCT B.PNLGRPNAME , A1.LANGUAGE_CD , A1.ITEMLABEL FROM PSMENUITEM A , PS_EODP_COMP_REF B , PSMENUITEMLANG A1 WHERE A.PNLGRPNAME= B.PNLGRPNAME AND A.MARKET = ( SELECT MIN(C.MARKET) FROM PSMENUITEM C WHERE A.MENUNAME = C.MENUNAME AND A.BARNAME = C.BARNAME AND A.ITEMNAME = C.ITEMNAME ) AND A.MENUNAME = A1.MENUNAME AND A.BARNAME = A1.BARNAME AND A.ITEMNAME = A1.ITEMNAME

  • Related Language Record for EODP_PNLGRP_VW

  • Parent Record Of EODP_CMPDESC_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 ITEMLABEL Character(30) VARCHAR2(30) NOT NULL Menu Item Label