SP_LGRP2AC_LANG

(SQL View)
Index Back

Sec Vw - All Ledger Groups


SELECT DISTINCT l.oprclass ,a.setid ,a.ledger_group ,a.language_cd ,a.descr FROM ps_led_grp_lang a ,PS_SEC_LEDGER_CLS l WHERE l.ledger_group = a.ledger_group

  • Related Language Record for SP_LGRP2A_CLSVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRCLASS2 Character(30) VARCHAR2(30) NOT NULL Operator Class
    2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    3 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description