SP_BULCMB_CLSVW

(SQL View)
 Index Back

BU Ledger Grp for combo edit


SELECT DISTINCT F.OPRCLASS , A.business_unit ,A.ledger_group FROM PS_BU_LED_COMB_TBL A , PS_SEC_LEDGER_CLS F WHERE F.LEDGER_GROUP = A.LEDGER_GROUP

  • Parent record: BU_LED_GRP_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group