IN_SW_ITMSH2_VW

(SQL View)
Index Back

IN_SW_ITMSHT_VW

IN_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