BUSINESS_UNITWO_TYPEPrompt Table: WM_WO_TYPE
IN_SW_WOTYPE_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT C.BUSINESS_UNIT_IN ,A.WO_TYPE ,A.DESCR FROM PS_WM_WO_TYPE A ,PS_SET_CNTRL_REC B ,PS_BUS_UNIT_TBL_WM C WHERE A.SETID = B.SETID AND B.REC_GROUP_ID = 'WM_03' AND B.RECNAME = 'WM_WO_TYPE' AND B.SETCNTRLVALUE = C.BUSINESS_UNIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | WO_TYPE |
Character(5) | VARCHAR2(5) NOT NULL |
Work Order Type
Prompt Table: WM_WO_TYPE |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |