RF_SOMY_SRH_VW2 (SQL View)	Index Back
My SO Search View Configurable Search View for My Service Order component

RF_SOMY_SRH_VW2

(SQL View)

My SO Search View

Configurable Search View for My Service Order component

SELECT C.BUSINESS_UNIT , C.SO_ID , B.OPRID , D.BO_NAME_DISPLAY , D.BO_NAME_AC , F.BO_NAME_DISPLAY , F.BO_NAME_AC , C.SO_STATUS , C.SO_PRIORITY , C.SO_DATE , C.SITE_ID , G.BO_NAME , C.BO_ID_CUST , C.ROLE_TYPE_ID_CUST , C.BO_ID_CONTACT , C.ROLE_TYPE_ID_CNTCT , C.SYNCID , C.SYNCDTTM FROM PS_RF_SO_HDR C , PS_BO_NAME_PRIM_VW F , PS_RF_SITE_P_NM_VW G , PSOPRALIAS B , PS_BO_NAME_PRIM_VW D WHERE C.BO_ID_CONTACT=F.BO_ID(+) AND C.BUSINESS_UNIT = G.SETCNTRLVALUE(+) AND C.SITE_ID = G.SITE_ID(+) AND B.OPRALIASTYPE = 'PER' AND C.SO_ID IN ( SELECT A.SO_ID FROM PS_RF_SOLN_ASSIGN A WHERE A.PERSON_ID = B.PERSON_ID AND A.PERSON_ID <> ' ' AND C.BUSINESS_UNIT = A.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
Default Value: OPR_DEF_TBL_RB.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 BO_NAME_DISPLAY_1 Character(80) VARCHAR2(80) NOT NULL This field represents the Display Name for a business object

7 BO_NAME_CONTACT_AC Character(50) VARCHAR2(50) NOT NULL Alt-Char Contact Name

8 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

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

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

11 SITE_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.

12 BO_NAME_3 Character(50) VARCHAR2(50) NOT NULL BO Name 3
Prompt Table: RF_SITE_NM_VW

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.

18 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_RB.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	BO_NAME_DISPLAY_1	Character(80)	VARCHAR2(80) NOT NULL	This field represents the Display Name for a business object
7	BO_NAME_CONTACT_AC	Character(50)	VARCHAR2(50) NOT NULL	Alt-Char Contact Name
8	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
9	SO_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	The priority of the service order. H=High L=Low N=Normal U=Urgent
10	SO_DATE	Date(10)	DATE	Stores the Service Order creation date.
11	SITE_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.
12	BO_NAME_3	Character(50)	VARCHAR2(50) NOT NULL	BO Name 3 Prompt Table: RF_SITE_NM_VW
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.
18	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time