SP_REV_BK_CLSVW

(SQL View)
 Index Back

Permit Security VW/AM REV BKs


SELECT A.BUSINESS_UNIT , A.BOOK FROM PS_BU_BOOK_TBL A , PS_SP_BOOK_CLSVW B , PS_SET_CNTRL_REC H WHERE A.REVALUE_FLG = 'Y' AND A.BUSINESS_UNIT = H.SETCNTRLVALUE AND H.RECNAME = 'SP_BOOK_CLSVW' AND B.SETID = H.SETID AND A.BOOK = B.BOOK AND NOT EXISTS ( SELECT 'X' FROM PS_SET_CNTRL_REC D , PS_LED_GRP_TBL E , PS_LED_GRP_LED_TBL F WHERE A.DISTRIBUTION_SW='Y' AND D.RECNAME = 'LED_GRP_TBL' AND D.SETCNTRLVALUE = A.BUSINESS_UNIT_GL AND E.SETID = D.SETID AND E.LEDGER_GROUP = A.LEDGER_GROUP AND F.SETID = E.SETID AND F.LEDGER_GROUP = E.LEDGER_GROUP AND (E.LEDGERS_SYNC = 'Y' AND F.PRIMARY_LEDGER <> 'Y' AND (F.LEDGER = A.LEDGER OR A.LEDGER = ' ')) )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name