IN_WO_PRMT_VW(SQL View) |
Index Back |
|---|---|
Demand Order Release ViewThis view is used by the Order Release secondary panel to initially fetch all rows meeting the selection criteria on the picking plan run control panel. NOTE: There is a Sybase version of the viewtext associated with this record. If it is modified, please be sure to modify the platform-specific viewtext for Sybase. |
| SELECT A.BUSINESS_UNIT , A.BUSINESS_UNIT , B.SHOP_ID , B.SHOP_ID , A.WO_ID , A.WO_ID , A.WO_TASK_ID , A.WO_TASK_ID , %Substring(B.DESCR254,1,60) FROM PS_WM_WO_TSK A , PS_WM_WO_HDR B WHERE A.INTERNAL_STATUS NOT IN ('05','06','07') AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.WO_ID = A.WO_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_WO | Character(5) | VARCHAR2(5) NOT NULL | Business Unit Work Order |
| 2 | TO_SOURCE_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | 12/10/02 NRA (CN#PL880-1): Defined |
| 3 | SL_SHOP_ID | Character(10) | VARCHAR2(10) NOT NULL | Shop |
| 4 | TO_SHOP_ID | Character(10) | VARCHAR2(10) NOT NULL | Shop ID |
| 5 | SL_ORDER_NO | Character(10) | VARCHAR2(10) NOT NULL | Order Number selection |
| 6 | TO_ORDER_NO | Character(10) | VARCHAR2(10) NOT NULL | Order Number selection |
| 7 | SL_ORDER_INT_LINE | Number(5,0) | INTEGER NOT NULL | Order Line selection |
| 8 | TO_ORDER_INT_LINE | Number(5,0) | INTEGER NOT NULL | Order Line selection |
| 9 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |