SP_BULNKK_OPRVW

(SQL View)
 Index Back

Sec Vw - Det Led for BU no KK

This view exludes commitment control detail ledgers

SELECT L.OPRID , A.BUSINESS_UNIT , A.LEDGER , B.DESCR FROM PS_BU_LED_TBL A , PS_LED_DEFN_TBL B , PS_LED_TMPLT_TBL D , PS_SET_CNTRL_REC C ,PS_SEC_LEDGER_OPR L WHERE B.SETID = C.SETID AND C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.RECNAME = 'LED_DEFN_TBL' AND B.LEDGER = A.LEDGER AND B.LEDGER_TYPE = 'D' AND D.DEFAULT_LEDGER NOT IN ('C', 'U', 'R') AND B.LEDGER_TEMPLATE = D.LEDGER_TEMPLATE AND L.LEDGER = A.LEDGER

  • Related Language Record: BU_LED_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description