BUSINESS_UNITWORK_ORDER_IDSPF_WO_NOPO_VW(SQL View) |
Index Back |
|---|---|
Work order that has no PO.Work orders that are in 'A'pproved status but not yet created a PO. |
| SELECT WO.BUSINESS_UNIT ,WO.WORK_ORDER_ID FROM PS_SPF_WORDERREC WO WHERE WO.WO_STATUS = 'A' AND WO.PO_ID = ' ' AND NOT EXISTS ( SELECT 'X' FROM PS_PO_LINE_SHIP PO WHERE PO.BUSINESS_UNIT = WO.BUSINESS_UNIT AND PO.WORK_ORDER_ID = WO.WORK_ORDER_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | WORK_ORDER_ID |
Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |