SPBULEDDS_NONVW

(SQL View)
 Index Back

Detl and Sum Ledgers for a BU


SELECT A.BUSINESS_UNIT ,A.LEDGER ,B.DESCR FROM PS_BU_LED_TBL A , PS_LED_DEFN_TBL B WHERE (B.LEDGER = A.LEDGER AND B.LEDGER_TYPE = 'D' AND B.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = A.BUSINESS_UNIT AND RECNAME = 'LED_DEFN_TBL')) OR ( B.LEDGER = A.LEDGER AND B.LEDGER_TYPE = 'S' AND EXISTS ( SELECT 'X' FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = A.BUSINESS_UNIT AND SETID = B.SETID AND RECNAME = 'SUMLD_DEFN_VW') )

  • Related Language Record: BU_LED_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description