OWNERSHIP_IDPrompt Table: FO_ORD_BRNCH_VW
SO_IDPrompt Table: SP_BU_PC_NONVW
Prompt Table: FO_ORDER_TYPE
FO_ORD_SRCH_VW3(SQL View) |
Index Back |
|---|---|
Order search view |
| SELECT A.OWNERSHIP_ID ,A.SO_ID ,A.BUSINESS_UNIT ,A.USER_ORDER_TYPE ,A.PROJECT_ID ,A.CONTRACT_NUM 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 = 'U' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OWNERSHIP_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Owning Organization
Prompt Table: FO_ORD_BRNCH_VW |
| 2 | SO_ID |
Character(15) | VARCHAR2(15) NOT NULL | Service Order ID |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 4 | USER_ORDER_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
User Order Type
Prompt Table: FO_ORDER_TYPE |
| 5 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 6 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |