SP_BULCMB_OPRVW

(SQL View)
 Index Back

BU Ledger Grp for combo edit


SELECT DISTINCT L.OPRID , A.business_unit ,A.ledger_group FROM PS_BU_LED_COMB_TBL A ,ps_sec_ledger_opr l WHERE L.LEDGER_GROUP = A.LEDGER_GROUP

  • Parent record: BU_LED_GRP_TBL

    • # 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_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group