BUSINESS_UNITPrompt Table: SP_BU_PC_NONVW
SO_IDPrompt Table: FO_ORDER_TYPE
Prompt Table: FO_ORD_BRNCH_VW
D=Draft
E=Ended
F=Filled
U=Unfilled
FO_ORD_SRCH_VW2(SQL View) |
Index Back |
|---|---|
Order search view |
| SELECT A.BUSINESS_UNIT ,A.SO_ID ,A.USER_ORDER_TYPE ,A.OWNERSHIP_ID ,B.SO_STATUS ,A.ASSIGNED_TO ,A.PROJECT_ID FROM PS_RS_SO_HDR A , PS_RS_SO_STATUS B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SO_ID = B.SO_ID AND B.LASTUPDDTTM = ( SELECT MAX(LASTUPDDTTM) FROM PS_RS_SO_STATUS C WHERE B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.SO_ID = C.SO_ID) AND A.SYSTEM_SOURCE = 'STF' AND B.SO_STATUS IN ('U','F') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 2 | SO_ID |
Character(15) | VARCHAR2(15) NOT NULL | Service Order ID |
| 3 | USER_ORDER_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
User Order Type
Prompt Table: FO_ORDER_TYPE |
| 4 | OWNERSHIP_ID | Character(30) | VARCHAR2(30) NOT NULL |
Owning Organization
Prompt Table: FO_ORD_BRNCH_VW |
| 5 | FO_ORDER_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Order Status
D=Draft E=Ended F=Filled U=Unfilled |
| 6 | ASSIGNED_TO | Character(30) | VARCHAR2(30) NOT NULL | Assigned To |
| 7 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |