FO_RF_SRCH_VW (SQL View)	Index Back
Order search view

FO_RF_SRCH_VW

(SQL View)

Order search view

SELECT A.BUSINESS_UNIT ,A.SO_ID ,A.DESCR ,A.USER_ORDER_TYPE ,C.NAME1 ,A.CUST_ID ,A.OWNERSHIP_ID ,B.SO_STATUS ,A.ASSIGNED_TO ,A.PROJECT_ID FROM PS_RS_SO_HDR A , PS_RS_SO_STATUS B , PS_CUSTOMER C 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 B1 WHERE B.BUSINESS_UNIT = B1.BUSINESS_UNIT AND B.SO_ID = B1.SO_ID) AND C.SETID = ( SELECT SC.SETID FROM PS_SET_CNTRL_REC SC WHERE SC.SETCNTRLVALUE = A.BUSINESS_UNIT AND SC.REC_GROUP_ID = 'FS_23' AND SC.RECNAME = 'CUSTOMER') AND A.CUST_ID = C.CUST_ID AND A.SYSTEM_SOURCE = 'STF' AND EXISTS ( SELECT 'x' FROM PS_FO_EVENT_LS_HDR Z WHERE Z.FO_EVENT_LST = A.FO_EVENT_LST) AND B.SO_STATUS = 'U' AND EXISTS ( SELECT 'X' FROM PS_FO_SO_LINE_MTCH D WHERE D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.SO_ID = A.SO_ID AND D.FO_FUN_UCONS = 'Y')

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 USER_ORDER_TYPE Character(5) VARCHAR2(5) NOT NULL User Order Type
Prompt Table: FO_ORDER_TYPE

5 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
Prompt Table: FO_CUST_AL_SCH3

6 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.
Prompt Table: FO_CUST_AL_SRCH

7 OWNERSHIP_ID Character(30) VARCHAR2(30) NOT NULL Owning Organization
Prompt Table: SP_BR_FO_NONVW

8 FO_ORDER_STATUS Character(1) VARCHAR2(1) NOT NULL Order Status
D=Draft
E=Ended
F=Filled
U=Unfilled

9 ASSIGNED_TO Character(30) VARCHAR2(30) NOT NULL Assigned To

10 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

#	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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	USER_ORDER_TYPE	Character(5)	VARCHAR2(5) NOT NULL	User Order Type Prompt Table: FO_ORDER_TYPE
5	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1 Prompt Table: FO_CUST_AL_SCH3
6	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. Prompt Table: FO_CUST_AL_SRCH
7	OWNERSHIP_ID	Character(30)	VARCHAR2(30) NOT NULL	Owning Organization Prompt Table: SP_BR_FO_NONVW
8	FO_ORDER_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Order Status D=Draft E=Ended F=Filled U=Unfilled
9	ASSIGNED_TO	Character(30)	VARCHAR2(30) NOT NULL	Assigned To
10	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField