IN_WO_ISS_VW

(SQL View)
 Index Back

Work Order Issues View


SELECT business_unit , demand_source , source_bus_unit , order_no , order_int_line_no , sched_line_nbr , inv_item_id , seq_nbr , serial_id , inv_lot_id , container_id , storage_area , stor_level_1 , stor_level_2 , stor_level_3 , stor_level_4 , unit_measure_pick , staged_date , qty_picked , qty_picked_conv , qty_base , qty_shipped , qty_shipped_conv , qty_ship_base , last_qty_ship , last_qty_ship_base , pick_batch_id , process_instance , dt_timestamp FROM PS_DEMAND_PHYS_INV WHERE demand_source = 'WM'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business 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 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus 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 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
9 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID

Default Value: INSTALLATION_IN.DFLT_SERIAL_ID

Prompt Table: %EDITTABLE20

10 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID

Default Value: INSTALLATION_IN.DFLT_INV_LOT_ID

Prompt Table: %EDITTABLE19

11 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID

Prompt Table: %EDITTABLE18

12 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area

Prompt Table: %EDITTABLE10

13 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1

Prompt Table: %EDITTABLE11

14 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2

Prompt Table: %EDITTABLE12

15 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3

Prompt Table: %EDITTABLE13

16 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4

Prompt Table: %EDITTABLE14

17 UNIT_MEASURE_PICK Character(3) VARCHAR2(3) NOT NULL Phys Location Unit of Measure

Prompt Table: %EDITTABLE21

18 STAGED_DATE Date(10) DATE Staged Date

Default Value: INSTALLATION_IN.DFLT_STAGED_DATE

19 QTY_PICKED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Picked
20 QTY_PICKED_CONV Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Picked in Phys Loc UOM
21 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity
22 QTY_SHIPPED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
23 QTY_SHIPPED_CONV Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
24 QTY_SHIP_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Ship Base
25 LAST_QTY_SHIP Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Last Shipped
26 LAST_QTY_SHIP_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Used to save the last value of quantity shipped from the Shipping Issues Panel in Standard UOM at the DEMAND_PHYS_INV and SHIP_INF_INV level. Default to the quantity picked from the Express Issues Panel or for cases where auto ship equals 'Y'.
27 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID
28 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
29 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp