RF_MAT_SRCH_VW2 (SQL View)	Index Back
Material Search View This is the Search record for the Material Orders component.

RF_MAT_SRCH_VW2

(SQL View)

Material Search View

This is the Search record for the Material Orders component.

SELECT DISTINCT A.BUSINESS_UNIT , A.SO_ID , B.OPRID , D.BO_NAME_DISPLAY , D.BO_NAME_AC , C.SO_STATUS , E.SOACTIVITY_STATUS , C.SO_PRIORITY , C.SO_DATE , A.SO_LINE , A.INV_ITEM_ID , A.REQ_ID , C.BO_ID_CUST , C.ROLE_TYPE_ID_CUST , C.BO_ID_CONTACT , C.ROLE_TYPE_ID_CNTCT , A.SYNCID FROM PS_RF_MATERIAL_DTL A , PSOPRALIAS B , PS_RF_SO_HDR C , PS_RF_SO_LINE E , PS_BO_NAME_PRIM_VW D WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND C.SO_ID = A.SO_ID AND E.BUSINESS_UNIT = C.BUSINESS_UNIT AND E.SO_ID = C.SO_ID AND E.SO_LINE = A.SO_LINE AND D.BO_ID = C.BO_ID_CUST AND B.OPRALIASTYPE = 'PER' AND C.SO_ID IN ( SELECT F.SO_ID FROM PS_RF_SOLN_ASSIGN F WHERE F.PERSON_ID = B.PERSON_ID AND F.PERSON_ID <> ' ' AND C.BUSINESS_UNIT = F.BUSINESS_UNIT ) AND C.BO_ID_CUST = D.BO_ID

# 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_RF_NONVW

2 SO_ID Character(10) VARCHAR2(10) NOT NULL Service Order ID
Prompt Table: RF_SO_HDR

3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

4 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

5 BO_NAME_AC Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

6 SO_STATUS Character(1) VARCHAR2(1) NOT NULL This field is used to store the Service Order Header Status.
C=Complete
D=Closed
O=Open
X=Canceled

7 SOACTIVITY_STATUS Character(3) VARCHAR2(3) NOT NULL Service Order Activity (line) Status.
CAN=Canceled
CLO=Closed
COM=Completed
OAC=Accepted
OER=En Route
OHA=Hold Assignment
OHC=Hold Customer
OHP=Hold Part
OOS=On Site
OPA=Assigned
ORJ=Rejected

8 SO_PRIORITY Character(1) VARCHAR2(1) NOT NULL The priority of the service order.
H=High
L=Low
N=Normal
U=Urgent

9 SO_DATE Date(10) DATE Stores the Service Order creation date.

10 SO_LINE Number(3,0) SMALLINT NOT NULL Stores the Service Order line number.
Prompt Table: RF_SO_LINE_VW4

11 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

12 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID

13 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.

14 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer

15 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.

16 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact

17 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

#	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_RF_NONVW
2	SO_ID	Character(10)	VARCHAR2(10) NOT NULL	Service Order ID Prompt Table: RF_SO_HDR
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object
5	BO_NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
6	SO_STATUS	Character(1)	VARCHAR2(1) NOT NULL	This field is used to store the Service Order Header Status. C=Complete D=Closed O=Open X=Canceled
7	SOACTIVITY_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Service Order Activity (line) Status. CAN=Canceled CLO=Closed COM=Completed OAC=Accepted OER=En Route OHA=Hold Assignment OHC=Hold Customer OHP=Hold Part OOS=On Site OPA=Assigned ORJ=Rejected
8	SO_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	The priority of the service order. H=High L=Low N=Normal U=Urgent
9	SO_DATE	Date(10)	DATE	Stores the Service Order creation date.
10	SO_LINE	Number(3,0)	SMALLINT NOT NULL	Stores the Service Order line number. Prompt Table: RF_SO_LINE_VW4
11	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
12	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
13	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
14	ROLE_TYPE_ID_CUST	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the customer
15	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
16	ROLE_TYPE_ID_CNTCT	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the contact
17	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.