PC_LGRP_LANG

(SQL View)
Index Back

Ledger Grps for a BU RLR


select a.business_unit ,a.ledger_group ,b.LANGUAGE_CD ,b.descr from PS_BU_LED_GRP_TBL a , PS_LED_GRP_LANG b where b.setid = ( select setid from ps_set_cntrl_rec c where c.setcntrlvalue = a.business_unit and c.recname = 'LED_GRP_TBL') and b.ledger_group = a.ledger_group

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
2 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description