FO_ORDR_PUB_VW(SQL View) |
Index Back |
|---|
| SELECT A.SO_LINE , A.SO_LINE_STATUS , B.SO_ID , B.USER_ORDER_TYPE , C.COUNTRY , C.STATE , C.CITY , A. FO_JOBTITLE , B. OWNERSHIP_ID , B.BUSINESS_UNIT , A. DESCR , A.START_DT , A.END_DT , A. CONFIDENCE_CD , B.SERVICE_OPRID FROM PS_RS_SO_LINE A , PS_RS_SO_HDR B , PS_FO_CUST_ADDR_VW C , PS_SET_CNTRL_REC D , PS_RS_SO_STATUS E WHERE A.SHOW_IN_SELFSERV = 'Y' AND A.SO_ID = B.SO_ID AND A.SO_LINE_STATUS <> 'A' AND A.SO_LINE_STATUS <> 'C' AND D.RECNAME = 'CUSTOMER' AND D.SETCNTRLVALUE = A.BUSINESS_UNIT AND D.SETID = C.SETID AND A.CUST_ID = C.CUST_ID AND A.ADDRESS_SEQ_NUM = C.ADDRESS_SEQ_NUM AND E.SO_ID = B.SO_ID AND E.SO_STATUS <> 'F' AND E.LASTUPDDTTM = ( SELECT MAX(G.LASTUPDDTTM) FROM PS_RS_SO_STATUS G WHERE G.SO_ID = A.SO_ID AND G.BUSINESS_UNIT = A.BUSINESS_UNIT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SO_LINE | Number(3,0) | SMALLINT NOT NULL | Line Number |
| 2 | SO_FO_LINE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Resource Request Status
A=Filled C=Canceled O=Unfilled |
| 3 |  SO_ID |
Character(15) | VARCHAR2(15) NOT NULL | Service Order ID |
| 4 | USER_ORDER_TYPE |
Character(5) | VARCHAR2(5) NOT NULL |
User Order Type
Prompt Table: FO_ORDER_TYPE |
| 5 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Default Value: INSTALLATION.COUNTRY Prompt Table:
COUNTRY_TBL
|
| 6 | STATE |
Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_NAMES_TBL |
| 7 | CITY |
Character(30) | VARCHAR2(30) NOT NULL | City |
| 8 | FO_JOBTITLE | Character(9) | VARCHAR2(9) NOT NULL | Job Title Code |
| 9 | OWNERSHIP_ID | Character(30) | VARCHAR2(30) NOT NULL | Owning Organization |
| 10 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 11 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 12 | START_DT | Date(10) | DATE | Start Date |
| 13 | END_DT | Date(10) | DATE | End Date |
| 14 | CONFIDENCE_CD | Character(2) | VARCHAR2(2) NOT NULL |
Confidence
AL=Advanced BL=Beginner IL=Intermediate NI=Not Investigated |
| 15 | SERVICE_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Service Operator |