CTI_CMPNT_LNG

(SQL View)
Index Back

CTI Components Prompt view

Date Initials Issue Description 022301 dms SP2 (F-CJORGENS-9) CTI Integration

SELECT m1.menuname , m1.barname , m1.pnlgrpname , m.language_cd , m.itemlabel FROM PSMENUITEMlang m , PSMENUITEM m1 WHERE m.menuname = m1.menuname AND m.barname = m1.barname AND m.itemname = m1.itemname AND m1.itemtype = 5

  • Related Language Record for CTI_CMPNT_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
    2 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name
    3 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description