NEW_BUSINESS_UNITNEW_BOOKNEW_GRP_ASSET_IDBK_GRP_AST_VW(SQL View) |
Index Back |
|---|---|
Group Asset at Book Lvl |
| SELECT b.business_unit, b.book, b.asset_id FROM PS_ASSET A, ps_book B, ps_bu_book_tbl C WHERE a.business_unit = b.business_unit AND a.asset_id = b.asset_id AND a.group_asset_flag = 'G' AND b.business_unit = c.business_unit AND b.book = c.book AND c.group_proc_sw = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | NEW_BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | New Business Unit |
| 2 | NEW_BOOK |
Character(10) | VARCHAR2(10) NOT NULL | New Book |
| 3 | NEW_GRP_ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | New Group Asset ID |