IUT_SHIPPED_VW(SQL View) |
Index Back |
|---|---|
Get IUT Shipped05/27/04 PWF Change reference from sched_line_no to sched_line_nbr |
| SELECT DISTINCT INV.REQ_ID , INV.INTERUNIT_ID , INV.INTERUNIT_LINE , INV.BUSINESS_UNIT , INV.SOURCE_BUS_UNIT , SUM(PHYS.QTY_SHIP_BASE) , ITM.UNIT_MEASURE_STD , ITM.INV_ITEM_ID , ITM.LOT_CONTROL , ITM.SERIAL_CONTROL , ITM.SHIP_SERIAL_CNTRL FROM PS_MASTER_ITEM_TBL ITM , PS_DEMAND_PHYS_INV PHYS , PS_IN_DEMAND INV , PS_SET_CNTRL_REC SC WHERE SC.RECNAME = 'MASTER_ITEM_TBL' AND SC.SETCNTRLVALUE = INV.BUSINESS_UNIT AND PHYS.BUSINESS_UNIT = INV.BUSINESS_UNIT AND PHYS.DEMAND_SOURCE = INV.DEMAND_SOURCE AND PHYS.SOURCE_BUS_UNIT = INV.SOURCE_BUS_UNIT AND PHYS.ORDER_NO = INV.ORDER_NO AND PHYS.ORDER_INT_LINE_NO = INV.ORDER_INT_LINE_NO AND PHYS.SCHED_LINE_NBR = INV.SCHED_LINE_NBR AND PHYS.DEMAND_LINE_NO = INV.DEMAND_LINE_NO AND PHYS.INV_ITEM_ID = INV.INV_ITEM_ID AND PHYS.QTY_PICKED > 0 AND INV.INTERUNIT_ID <>' ' AND ITM.SETID = SC.SETID AND INV.INV_ITEM_ID = ITM.INV_ITEM_ID AND INV.INTERUNIT_FLG = 'Y' AND INV.IN_FULFILL_STATE='70' AND INV.INTERUNIT_STAT = 'I' GROUP BY INV.REQ_ID, INV.INTERUNIT_ID, INV.INTERUNIT_LINE, INV.BUSINESS_UNIT, INV.SOURCE_BUS_UNIT, INV.QTY_SHIP_BASE, ITM.UNIT_MEASURE_STD, ITM.INV_ITEM_ID, ITM.LOT_CONTROL, ITM.SERIAL_CONTROL, ITM.SHIP_SERIAL_CNTRL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REQ_ID | Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 2 | INTERUNIT_ID | Character(10) | VARCHAR2(10) NOT NULL | InterUnit Order ID |
| 3 | INTERUNIT_LINE | Number(5,0) | INTEGER NOT NULL | InterUnit Order Line |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | SOURCE_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Source Bus Unit |
| 6 | TOT_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Quantity |
| 7 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 8 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 9 | LOT_CONTROL | Character(1) | VARCHAR2(1) NOT NULL |
Lot Control
N=N Y=Y |
| 10 | SERIAL_CONTROL | Character(1) | VARCHAR2(1) NOT NULL |
Serial Control
N=N Y=Y |
| 11 | SHIP_SERIAL_CNTRL | Character(1) | VARCHAR2(1) NOT NULL | Shipping Serial Control |