IN_WO_SCHMAT_VW

(SQL View)
 Index Back

Inv Work Order Partslist View


SELECT a.business_unit_in , 'WM' , a.business_unit , a.wo_id , a.wo_task_id , a.res_ln_nbr , a.inv_item_id , 1 , a.unit_of_measure , a.qty_scheduled , a.qty_scheduled_base , h.shop_id , t.location , t.sched_start_dt , t.sched_start_time , %Dttm(a.wo_mat_need_dt, %TimeIn('00.00.00.000000')) , a.wo_mat_need_dt , t.currency_cd , t.wo_inv_commit_rule , t.wo_reserve_rule FROM PS_WM_WO_TSK t , ps_wm_wo_hdr h , ps_wm_wo_sched_mat a WHERE a.business_unit = t.business_unit AND a.wo_id = t.wo_id AND a.wo_task_id = t.wo_task_id AND a.wo_commit_flag = '1' AND a.qty_scheduled > 0 AND a.floor_stock_flag <> 'Y' AND t.wo_inv_commit_rule IN ('2','4') 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 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
10 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested
11 QTY_REQUESTED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested Base
12 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification
13 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
14 SCHED_START_DT Date(10) DATE Scheduled Start Date
15 SCHED_START_TIME Time(15) TIMESTAMP Schedule Start Time
16 SCHED_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added
17 WO_MAT_NEED_DT Date(10) DATE Work Management Material needed date. This field is used when committing inventory and the needed date
18 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
19 WO_INV_COMMIT_RULE Character(1) VARCHAR2(1) NOT NULL Inventory commit rule, when to commit inventory for Work Management
1=Parts List Creation
2=Pick Plan Creation
3=Work Order Status Change
4=Commit at Reserve
20 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