IN_SW_ITMSH2_VW(SQL View) |
Index Back |
---|---|
IN_SW_ITMSHT_VWIN_SW_ITMSHT_VW |
SELECT A2.BUSINESS_UNIT , A2.INV_ITEM_ID , SUM(A2.QTY_REQUESTED_BASE - A2.QTY_ALLOC_BASE - A2.QTY_BACKORDER_BASE - A2.QTY_SHIP_BASE) QTY_AVAILABLE FROM PS_IN_DEMAND A2 GROUP BY A2.BUSINESS_UNIT , A2.INV_ITEM_ID |
# | 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 |
3 | QTY_AVAILABLE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Available |