SPR_LOSD_WO

(SQL View)
Index Back

SELECT DISTINCT W.BUSINESS_UNIT ,W.WORK_ORDER_ID ,W.START_DATE ,W.END_DATE ,W.WO_CONID ,W.VENDOR_ID ,D.DEPTID FROM PS_SPF_WORDERREC W ,PS_SPF_WOPO_DISTRB D WHERE W.BUSINESS_UNIT = D.BUSINESS_UNIT AND W.WORK_ORDER_ID = D.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
3 START_DATE Date(10) DATE Start Date for Gen Standing PO
4 END_DATE Date(10) DATE End Date
5 WO_CONID Character(15) VARCHAR2(15) NOT NULL Service Provider's ID assigned on work order
6 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
7 DEPTID Character(10) VARCHAR2(10) NOT NULL Department