IN_ITMSHT_VW(SQL View) |
Index Back |
|---|---|
IN_ITMSHT_VWIN_ITMSHT_VW |
| SELECT A2.BUSINESS_UNIT ,A2.INV_ITEM_ID FROM PS_IN_DEMAND A2 , PS_BU_ITEMS_INV B2 WHERE A2.BUSINESS_UNIT = B2.BUSINESS_UNIT AND A2.INV_ITEM_ID = B2.INV_ITEM_ID GROUP BY A2.BUSINESS_UNIT ,A2.INV_ITEM_ID HAVING SUM(A2.QTY_REQUESTED_BASE-A2.QTY_ALLOC_BASE- A2.QTY_BACKORDER_BASE)> MAX(B2.QTY_AVAILABLE) |
| # | 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 |