WM_EIP_MAT_VW(SQL View) |
Index Back |
|---|---|
Work Order Material ScheduleWork Order Management Material Schedule |
| SELECT B.BUSINESS_UNIT , B.WO_ID , B.WO_TASK_ID , B.RES_LN_NBR , B.USED_QTY , B.QTY_SCHEDULED , B.WO_MAT_NEED_DT , B.BUSINESS_UNIT_IN , B.INV_ITEM_ID , B.EST_UNIT_COST , B.UNIT_OF_MEASURE , CASE WHEN A.PICK_BATCH_ID IS NULL THEN 0 ELSE A.PICK_BATCH_ID END , CASE WHEN A.PICKLIST_LINE_NO IS NULL THEN 0 ELSE A.PICKLIST_LINE_NO END FROM PS_WM_WO_SCHED_MAT B LEFT OUTER JOIN PS_IN_DEMAND A ON 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 |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT |
| 2 | WO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Work Order Identification |
| 3 | WO_TASK_ID |
Number(5,0) | INTEGER NOT NULL | Task Number |
| 4 | RES_LN_NBR |
Number(5,0) | INTEGER NOT NULL |
Resource Line No.
Default Value: WM_WO_TSK.LAST_SCHEDLN_MAT |
| 5 | USED_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Work Order Management Used quantity. |
| 6 | QTY_SCHEDULED | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity Scheduled |
| 7 | WO_MAT_NEED_DT | Date(10) | DATE |
Work Management Material needed date. This field is used when committing inventory and the needed date
Default Value: WM_WO_TSK.SCHED_START_DT |
| 8 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 9 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: %EDITTABLE3 |
| 10 | EST_UNIT_COST | Number(21,5) | DECIMAL(20,5) NOT NULL | Estimated unit cost |
| 11 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage Default Value: MASTER_ITEM_TBL.UNIT_MEASURE_STD Prompt Table: %EDIT_UOM |
| 12 | PICK_BATCH_ID | Number(10,0) | DECIMAL(10) NOT NULL | Pick Batch ID |
| 13 | PICKLIST_LINE_NO | Number(7,0) | INTEGER NOT NULL | Pick List Sorting Line Number |