SPA_PL_WO_V

(SQL View)
 Index Back

Workorders for PLog lines


SELECT DISTINCT (A.WO_CONID) , A.TE_TEMPLATE_ID , A.BUSINESS_UNIT , B.DESCR , A.WORK_ORDER_ID , A.JOB_TITLE FROM PS_SPF_WORDERREC A , PS_BUS_UNIT_TBL_FS B WHERE ((A.WO_STATUS IN ('L','C','T')) OR (A.WO_STATUS = 'N' AND EXISTS ( SELECT '*' FROM PS_SPF_WO_HISTORY H WHERE H.BUSINESS_UNIT = A.BUSINESS_UNIT AND H.WORK_ORDER_ID = A.WORK_ORDER_ID AND H.WO_STATUS = 'L'))) AND A.SERVICE_METHOD = 'D' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
2 TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Project Template
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID
6 JOB_TITLE Character(50) VARCHAR2(50) NOT NULL Job Title