RD_CST_SITE_CNT (SQL View)	Index Back
Customer Site Retrieving all sites that have the same contact with its parent

RD_CST_SITE_CNT

(SQL View)

Customer Site

Retrieving all sites that have the same contact with its parent

SELECT A.BO_ID_1 , A.BO_ID_2 , B.BO_ID_1 , B.BO_REL_ID FROM PS_BO_REL A , PS_BO_REL B WHERE A.REL_TYPE_ID IN (4, 17, 513, 514) AND B.REL_TYPE_ID IN (11,12) AND A.BO_ID_2 = B.BO_ID_2 AND A.START_DT <= %CurrentDateIn AND A.END_DT > %CurrentDateIn AND B.START_DT <= %CurrentDateIn AND B.END_DT > %CurrentDateIn

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 BO_ID_CNTCT Number(31,0) DECIMAL(31) NOT NULL This field represents the business object ID for a Contact

4 BO_REL_ID Signed Number(32,0) DECIMAL(31) NOT NULL Relationship ID of a Business Object

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
2	BO_ID_SITE	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID
3	BO_ID_CNTCT	Number(31,0)	DECIMAL(31) NOT NULL	This field represents the business object ID for a Contact
4	BO_REL_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Relationship ID of a Business Object