RS_MYSORDERS_VW

(SQL View)
 Index Back

Service Orders View

Service Orders View

SELECT A.BUSINESS_UNIT , A.SO_ID , C.SO_LINE , B.SO_STATUS , A.ASSIGNED_TO , E.SETID , A.CUST_ID , C.DESCR , C.START_DT , C.END_DT , C.PART_TIME_FLG , C.QTY_INTEGER , C.PERIOD_DAYS , C.PROJ_ROLE , D.SO_PRIORITY , A.PROJECT_ID , C.EST_DAYS , C.TASK_TYPE FROM %Table(RS_SO_HDR) A , %Table(RS_SO_STATUS) B , %Table(RS_SO_LINE) C , %Table(RS_SO_PRIORITY) D , %Table(SET_CNTRL_REC) E WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SYSTEM_SOURCE='RS' AND A.SO_ID = B.SO_ID AND B.LASTUPDDTTM = ( SELECT MAX(B1.LASTUPDDTTM) FROM %Table(RS_SO_STATUS) B1 WHERE B1.BUSINESS_UNIT = B.BUSINESS_UNIT AND B1.SO_ID = B.SO_ID) AND B.SO_STATUS NOT IN ('C','D','X') AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.SO_ID = C.SO_ID AND C.SO_LINE_STATUS = 'O' AND B.BUSINESS_UNIT = D.BUSINESS_UNIT AND B.SO_ID = D.SO_ID AND D.LASTUPDDTTM = ( SELECT MAX(D1.LASTUPDDTTM) FROM %Table(RS_SO_PRIORITY) D1 WHERE D1.BUSINESS_UNIT = D.BUSINESS_UNIT AND D1.SO_ID = D.SO_ID) AND E.SETCNTRLVALUE = A.BUSINESS_UNIT AND E.RECNAME = 'CUSTOMER' AND A.EXPRESS_SEARCH_FLG = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
3 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number
4 SO_STATUS Character(1) VARCHAR2(1) NOT NULL Service Order Status
C=Closed
D=Draft
I=In Process
N=New
O=Open
X=Canceled
5 ASSIGNED_TO Character(30) VARCHAR2(30) NOT NULL Assigned To

Prompt Table: RS_OPR_NAME_VW

6 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID
7 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
9 START_DT Date(10) DATE Start Date
10 END_DT Date(10) DATE End Date
11 PART_TIME_FLG Character(1) VARCHAR2(1) NOT NULL Part Time
12 QTY_INTEGER Number(11,0) DECIMAL(11) NOT NULL Quantity Rounded to 0 Decimals
13 PERIOD_DAYS Number(5,0) INTEGER NOT NULL Number of Work Days
14 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
15 SO_PRIORITY Character(10) VARCHAR2(10) NOT NULL Service Order Priority

Prompt Table: RS_PRIORITY_TBL

16 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
17 EST_DAYS Number(5,0) INTEGER NOT NULL Estimated number of days
18 TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Task Category