SP_KLEDBD_NONVW

(SQL View)
 Index Back

Budget Ledger Type 0 Vw


SELECT B.BUSINESS_UNIT , A.LEDGER FROM PS_LED_GRP_LED_TBL A , PS_BU_LED_TBL B , PS_SET_CNTRL_REC C WHERE A.LEDGER = B.LEDGER AND A.LEDGER_GROUP=B.LEDGER_GROUP AND A.SETID = C.SETID AND C.SETCNTRLVALUE = B.BUSINESS_UNIT AND C.RECNAME = 'LED_GRP_LED_TBL' AND A.LEDGER_TYPE_KK='0'

# 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