WM_QTY_ISSUE_VW(SQL View) |
Index Back |
|---|---|
WM qty issued to WOGet the quantity issued to the WO from the Inventory demand table. |
| SELECT A.BUSINESS_UNIT , A.DEMAND_SOURCE , A.SOURCE_BUS_UNIT , A.ORDER_NO , A.ORDER_INT_LINE_NO , A.SCHED_LINE_NBR , A.INV_ITEM_ID , A.DEMAND_LINE_NO , A.QTY_SHIPPED , A.SHIP_DTTM , A.PICK_BATCH_ID , A.QTY_ALLOCATED , A.RESERVE_STATUS , A.QTY_SHIP_BASE , A.QTY_ALLOC_BASE FROM PS_IN_DEMAND A , PS_WM_WO_SCHED_MAT B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT_IN AND A.SOURCE_BUS_UNIT = B.BUSINESS_UNIT AND A.ORDER_NO = B.WO_ID AND A.ORDER_INT_LINE_NO = B.WO_TASK_ID AND A.SCHED_LINE_NBR = B.RES_LN_NBR AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.DEMAND_LINE_NO = 1 AND A.DEMAND_SOURCE = 'WM' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT_IN |
Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 2 | DEMAND_SOURCE |
Character(2) | VARCHAR2(2) NOT NULL |
Demand Source
IN=Material Request OM=Sales Order PL=Planning Requisition PO=Purchase Order PR=Purchasing Requisition RT=Material Return SF=Production Request WM=Work Order |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | WO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Work Order Identification |
| 5 | WO_TASK_ID |
Number(5,0) | INTEGER NOT NULL | Task Number |
| 6 | RES_LN_NBR |
Number(5,0) | INTEGER NOT NULL | Resource Line No. |
| 7 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 8 | DEMAND_LINE_NO |
Number(4,0) | SMALLINT NOT NULL | Demand Line No |
| 9 | QTY_SHIPPED | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Shipped |
| 10 | SHIP_DTTM | DateTime(26) | TIMESTAMP | Ship Date/Time |
| 11 | PICK_BATCH_ID | Number(10,0) | DECIMAL(10) NOT NULL | Pick Batch ID |
| 12 | QTY_ALLOCATED | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Allocated quantity |
| 13 | RESERVE_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Reservation Status
10=Pending 11=Unreserved 12=Shortage, Rules Not Met 15=Reserved, Rules Not Met 21=Shortage, Line Rule Met 22=Reserved, Line Rule Met 31=Shortage, All Rules Met 32=Reserved, All Rules Met 40=Reserve Run 99=Invalid |
| 14 | QTY_SHIP_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Ship Base |
| 15 | QTY_ALLOC_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity allocation |