KSEC_LED_BD_VW1

(SQL View)
 Index Back

Budget Ledger Type 0


SELECT C.SETID , 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 C.SETCNTRLVALUE = B.BUSINESS_UNIT 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 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger