RB_PR_C_SITE_VW (SQL View)	Index Back
The Contact Customer site view This view returns all the customer-sites the person belongs to.

RB_PR_C_SITE_VW

(SQL View)

The Contact Customer site view

This view returns all the customer-sites the person belongs to.

SELECT A.PERSON_ID , C.BO_ID_PARENT , C.SETID , C.SITE_ID , B.REL_TYPE_ID , C.BO_ID , B.START_DT , B.ROLE_TYPE_ID_1 , B.ROLE_TYPE_ID_2 FROM PS_RD_PERSON A , PS_BO_REL B , PS_RD_SITE C WHERE A.BO_ID = B.BO_ID_1 AND C.BO_ID = B.BO_ID_2 AND B.ROLE_TYPE_ID_1 = 8 AND B.ROLE_TYPE_ID_2 = 3 AND B.REL_TYPE_ID IN (11,12) AND B.START_DT <= %CurrentDateIn AND B.END_DT > %CurrentDateIn

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

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

3 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
Prompt Table: SP_SETID_NONVW

4 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.
Prompt Table: RB_CUST_SITE_VW

5 REL_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Relationship Type ID
Default Value: 12

6 BO_ID_SITE Number(31,0) DECIMAL(31) NOT NULL Business Object ID

7 START_DT Date(10) DATE Start date field to store start date value.

8 ROLE_TYPE_ID_1 Number(12,0) DECIMAL(12) NOT NULL Role Type ID
Default Value: 8

9 ROLE_TYPE_ID_2 Number(12,0) DECIMAL(12) NOT NULL Role Type ID
Default Value: 3

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
2	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. Prompt Table: SP_SETID_NONVW
4	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. Prompt Table: RB_CUST_SITE_VW
5	REL_TYPE_ID	Number(12,0)	DECIMAL(12) NOT NULL	Relationship Type ID Default Value: 12
6	BO_ID_SITE	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID
7	START_DT	Date(10)	DATE	Start date field to store start date value.
8	ROLE_TYPE_ID_1	Number(12,0)	DECIMAL(12) NOT NULL	Role Type ID Default Value: 8
9	ROLE_TYPE_ID_2	Number(12,0)	DECIMAL(12) NOT NULL	Role Type ID Default Value: 3