SPF_CLIINC_WOVW

(SQL View)
 Index Back

Srv Coord Inc Bid wo lookup

This view is used as the prompt for WORK_ORDER_ID field for Service Coordinator Bid page.

SELECT DISTINCT O.OPRID , R.WORK_ORDER_ID FROM PS_SPF_BID_LINE B , PS_SPF_WORDERREC R , PSOPRALIAS O WHERE R.BUSINESS_UNIT = B.BUSINESS_UNIT AND R.WORK_ORDER_ID = B.WORK_ORDER_ID AND (B.BID_TYP = 'ENT' OR B.BID_TYP = 'SUP') AND B.SPF_BID_STATUS = 'S' AND O.OPRALIASTYPE = 'SPP' AND O.PERSON_ID = B.SPF_SENT_TO 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