SP_BULGPK_NONVW

(SQL View)
Index Back

Sec Vw - KKLedger Grp for a BU


SELECT A.BUSINESS_UNIT ,A.LEDGER_GROUP ,B.DESCR FROM PS_BU_LED_GRP_TBL A , PS_LED_GRP_TBL B , PS_SET_CNTRL_REC C WHERE B.SETID = C.SETID AND C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.RECNAME = 'LED_GRP_TBL' AND B.LEDGER_GROUP = A.LEDGER_GROUP AND A.LEDGER_TYPE='K'

  • Related Language Record: BU_LGRP_LANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description