BUSINESS_UNITINV_ITEM_IDPL_AGG_PAR_VW(SQL View) |
Index Back |
|---|---|
Demand Family Item View03/23/97 SCC CN#EPNT083-FQ9NK: Add %substring to support all platofrms. 12/05/97 CN# PL750-DI-GPENN-64 New view for 7.5 to enter aggregate demand items and aggregate demand component items for forecast consumption in planning. 5/28/99 RT: Modified for Item Attribute Modifications |
| SELECT BUSINESS_UNIT , INV_ITEM_ID FROM PS_BU_ITEMS_INV A WHERE A.INVENTORY_ITEM = 'N' AND A.SOURCE_CODE = '6' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |