SPF_SUPINC_WOVW(SQL View) |
Index Back |
---|---|
Supplier Inc Bid ReqId lookupThis view is used as the prompt for REQ_ID field for Supplier Incoming Bid page. |
SELECT DISTINCT O.OPRID , W.WORK_ORDER_ID FROM PS_SPF_BID_LINE B , PS_SPF_WORDERREC W , PSOPRALIAS O WHERE W.BUSINESS_UNIT = B.BUSINESS_UNIT AND W.WORK_ORDER_ID = B.WORK_ORDER_ID AND B.BID_TYP IN ('ENT' ,'SUP') AND B.SPF_BID_STATUS = 'S' AND O.OPRALIASTYPE = 'SPP' AND (O.PERSON_ID = B.SPF_SENT_TO OR O.PERSON_ID = B.SPF_SENT_FROM) AND B.LINE_ROW = ( SELECT MAX(LINE_ROW) FROM PS_SPF_BID_LINE B2 WHERE B2.BUSINESS_UNIT = B.BUSINESS_UNIT AND B2.BID_ID = B.BID_ID) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | WORK_ORDER_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |