BO2_REL_TYPE_VW (SQL View)	Index Back
Distinct BO Relationships This view is used to generate a distinct list of BO Relationship types for a particular BO.

BO2_REL_TYPE_VW

(SQL View)

Distinct BO Relationships

This view is used to generate a distinct list of BO Relationship types for a particular BO.

SELECT DISTINCT BO_ID_2 , REL_TYPE_ID FROM PS_BO_REL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

2 REL_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Relationship Type ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
2	REL_TYPE_ID	Number(12,0)	DECIMAL(12) NOT NULL	Relationship Type ID