BUSINESS_UNITPrompt Table: SP_BU_WM_NONVW
STATUS_CD01=Open
02=Awaiting Schedule
03=Scheduled
04=Work In Progress
05=Complete
06=Closed
07=Canceled
08=On Hold
09=Work Order Created
WM_OPNSR_STS_VW(SQL View) |
Index Back |
|---|---|
Open SR Status View |
| SELECT A.BUSINESS_UNIT , B.STATUS_CD , B.DESCR50_MIXED , B.DESCR , B.INTERNAL_STATUS , B.STATUS_CD_HDR , B.INITIAL_STATUS_SW FROM PS_BUS_UNIT_TBL_WR A , PS_WM_STATUS B WHERE B.SETID = ( SELECT I.SETID FROM PS_SET_CNTRL_REC I WHERE I.SETCNTRLVALUE = A.BUSINESS_UNIT AND I.REC_GROUP_ID = 'WM_07' AND I.RECNAME = 'WM_STATUS') AND B.WO_STATUS_TYPE = '3' AND B.INTERNAL_STATUS IN ('01','04') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_WM_NONVW |
| 2 | STATUS_CD |
Character(4) | VARCHAR2(4) NOT NULL | User defined Status Code |
| 3 | DESCR50_MIXED | Character(50) | VARCHAR2(50) NOT NULL | Description 50 characters, mixed case |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | INTERNAL_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Internal Status
01=Open 02=Awaiting Schedule 03=Scheduled 04=Work In Progress 05=Complete 06=Closed 07=Canceled 08=On Hold 09=Work Order Created |
| 6 | STATUS_CD_HDR | Character(4) | VARCHAR2(4) NOT NULL | Header Status |
| 7 | INITIAL_STATUS_SW | Character(1) | VARCHAR2(1) NOT NULL | Initial Status field switch |