BUSINESS_UNITPrompt Table: SP_BU_SP_NONVW
WORK_ORDER_IDSPF_WO_SRCH2_V(SQL View) |
Index Back |
|---|---|
Released Work Order Search VWReturns a list of work orders that have been released where time or progress logs may have been entered. This may include work order status in Pending Terminate, Terminated, Closed, Finalized, or Canceled. Work Order Status of Open, Submitted, Denied, and Approved are not included. |
| SELECT BUSINESS_UNIT , WORK_ORDER_ID FROM PS_SPF_WORDERREC WHERE WO_STATUS IN ('L','C','P','T') AND SERVICE_METHOD IN ('R','D') OR WORK_ORDER_ID IN ( SELECT W2.WORK_ORDER_ID FROM PS_SPF_WORDERREC W2 WHERE W2.WO_STATUS = 'N' AND W2.ACT_END_DT > W2.START_DATE) |
| # | 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_SP_NONVW |
| 2 | WORK_ORDER_ID |
Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |