BO_CUST_SITE_VW

(SQL View)
 Index Back

Role Representatives

SELECT A.BO_ID_1 , A.ROLE_TYPE_ID_1 , A.BO_ID_2 , A.ROLE_TYPE_ID_2 , A.START_DT , A.END_DT , A.BO_REL_ID , C.SETID , C.CUST_STATUS FROM PS_BO_REL A LEFT OUTER JOIN PS_BC C ON C.BO_ID = A.BO_ID_2 , PS_BO_REL_CAT_ITEM B WHERE A.REL_TYPE_ID = B.REL_TYPE_ID AND B.BO_REL_CATEGORY_ID = 4

SELECT A.BO_ID_1 , A.ROLE_TYPE_ID_1 , A.ROLE_TYPE_ID_2 , A.BO_ID_2 , A.START_DT , A.END_DT , A.BO_REL_ID , C.SETID , C.CUST_STATUS FROM PS_BO_REL A , PS_BC C , PS_BO_REL_CAT_ITEM B WHERE A.REL_TYPE_ID = B.REL_TYPE_ID AND B.BO_REL_CATEGORY_ID = 4 AND C.BO_ID (+) = A.BO_ID_2

# 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 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID
3 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
4 BO_ID_SITE Number(31,0) DECIMAL(31) NOT NULL Business Object ID
5 START_DT Date(10) DATE Start date field to store start date value.
6 END_DT Date(10) DATE This field stores the end date values.
7 BO_REL_ID Signed Number(32,0) DECIMAL(31) NOT NULL Relationship ID of a Business Object
8 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
9 CUST_STATUS Character(1) VARCHAR2(1) NOT NULL Customer Status Indicator. BC.CUST_STATUS
A=Active
I=Inactive