BUSINESS_UNITBOOKSP_REV_BK_NONVW(SQL View) |
Index Back |
|---|---|
Non Security View/AM REV BKs |
| SELECT A.BUSINESS_UNIT , A.BOOK FROM PS_BU_BOOK_TBL A WHERE A.REVALUE_FLG = 'Y' 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 |