ACLCOMPONENTLV2

index back

SELECT A.MENUNAME , A.ITEMNUM , C.LANGUAGE_CD , A.BARNAME , A.ITEMNAME , C.BARLABEL , C.ITEMLABEL , B.ACTIONS , A.PNLGRPNAME , B.MARKET FROM PSMENUITEM A , PSPNLGRPDEFN B , PSMENUITEMLANG C WHERE A.ITEMTYPE = 5 AND A.PNLGRPNAME = B.PNLGRPNAME AND A.MARKET = B.MARKET AND A.MENUNAME=C.MENUNAME AND A.BARNAME=C.BARNAME AND A.ITEMNAME=C.ITEMNAME

  • Related language record for ACLCOMPONENT_V2
  • PeopleSoft Field Name Field Type Column Type Description
    MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).

    Prompt Table: PSMENUDEFN

    ITEMNUM Number(4,0) SMALLINT NOT NULL Item Number
    LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
    BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name
    BARITEMNAME Character(30) VARCHAR2(30) NOT NULL Bar Item Name
    BARLABEL Character(10) VARCHAR2(10) NOT NULL Menu Bar Label
    ITEMLABEL Character(30) VARCHAR2(30) NOT NULL Menu Item Label
    ACTIONS Number(4,0) SMALLINT NOT NULL Actions
    PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    MARKET Character(3) VARCHAR2(3) NOT NULL Market translate values
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19