IUT_TQTY_RCV_VW

(SQL View)
Index Back

Get IUT Totqty received

08/04/04 PWF Data Model Change: Change to IN_DEMAND from SHIP_INF_INV

SELECT DISTINCT SUM(IUT.QTY_STD) , IUT.UNIT_MEASURE_STD , INV.REQ_ID , INV.SOURCE_BUS_UNIT , INV.INTERUNIT_ID , INV.INTERUNIT_LINE FROM PS_INV_RECV_LN IUT , PS_IN_DEMAND INV WHERE IUT.INTERUNIT_ID = INV.INTERUNIT_ID AND IUT.INTERUNIT_LINE = INV.INTERUNIT_LINE AND IUT.BUSINESS_UNIT = INV.DESTIN_BU AND IUT.SOURCE_BUS_UNIT = INV.BUSINESS_UNIT AND IUT.INV_ITEM_ID = INV.INV_ITEM_ID AND INV.IN_FULFILL_STATE >='50' GROUP BY IUT.UNIT_MEASURE_STD, INV.REQ_ID, INV.SOURCE_BUS_UNIT, INV.INTERUNIT_ID, INV.INTERUNIT_LINE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TOT_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Total Quantity
2 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
3 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
4 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
5 INTERUNIT_ID Character(10) VARCHAR2(10) NOT NULL InterUnit Order ID
6 INTERUNIT_LINE Number(5,0) INTEGER NOT NULL InterUnit Order Line