IN_WO_DMDWO_VW

(SQL View)
 Index Back

Inv Work Order In_Demand View


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.pick_batch_id , a.pick_release_id , a.release_instance , a.in_fulfill_state , a.unit_of_measure , a.qty_requested , a.qty_allocated , a.qty_shipped , a.sched_dttm , a.hold_flag , h.shop_id , t.location , t.wo_reserve_rule FROM ps_wm_wo_tsk t , ps_wm_wo_hdr h , PS_IN_DEMAND a WHERE a.demand_source = 'WM' AND a.in_fulfill_state = '10' AND a.qty_requested_base - a.qty_ship_base > 0 AND a.source_bus_unit = t.business_unit AND a.order_no = t.wo_id AND a.order_int_line_no = t.wo_task_id AND t.internal_status NOT IN ('05','06','07') AND h.business_unit = t.business_unit AND h.wo_id = t.wo_id

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.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 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
5 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
6 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
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 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID
10 PICK_RELEASE_ID Number(10,0) DECIMAL(10) NOT NULL Pick Release ID
11 RELEASE_INSTANCE Number(10,0) DECIMAL(10) NOT NULL 08/2004 rcw: Order Release Instance
12 IN_FULFILL_STATE Character(2) VARCHAR2(2) NOT NULL Inventory Fulfillment State
10=Pending
20=Unfulfilled
30=Releasable
40=Released
50=Confirmed
60=Shipped
70=Depleted
90=Canceled
13 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
14 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested
15 QTY_ALLOCATED Signed Number(17,4) DECIMAL(15,4) NOT NULL Allocated quantity
16 QTY_SHIPPED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
17 SCHED_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added
18 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
N=Hold
Y=Hold

Y/N Table Edit

19 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification
20 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
21 WO_RESERVE_RULE Character(1) VARCHAR2(1) NOT NULL Work Order Reservation rule
1=Parts List Creation
2=Pick Plan Creation
3=Work Order Status Change
4=Batch Reserve Only