RF_BO_SOLD_CONT

(SQL View)
 Index Back

Sold To Contacts

This record is a view which contains the details on Sold to Contacts for a Business Object

SELECT A.BO_ID_2 , A.ROLE_TYPE_ID_2 , A.BO_ID_1 , A.ROLE_TYPE_ID_1 , A.BO_REL_ID , A.REL_TYPE_ID , B.BO_NAME , CASE WHEN C.BO_REL_CATEGORY_ID = 13 THEN 'Y' ELSE 'N' END FROM PS_BO_REL_CUR_VW A , PS_BO B , PS_BO_REL_CAT_ITEM C WHERE A.BO_ID_1 = B.BO_ID AND C.REL_TYPE_ID = A.REL_TYPE_ID AND (C.BO_REL_CATEGORY_ID = 12 AND NOT EXISTS ( SELECT 1 FROM PS_BO_REL_CAT_ITEM D , PS_BO_REL_CUR_VW E WHERE A.BO_ID_1 = E.BO_ID_1 AND D.REL_TYPE_ID = A.REL_TYPE_ID AND D.REL_TYPE_ID = E.REL_TYPE_ID AND D.BO_REL_CATEGORY_ID = 13) OR C.BO_REL_CATEGORY_ID = 13)

# 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_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
3 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
4 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
5 BO_REL_ID Signed Number(32,0) DECIMAL(31) NOT NULL Relationship ID of a Business Object
6 REL_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Relationship Type ID
7 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL The individual contact name associated with a given bank/counterparty.
8 PRIMARY_IND Character(1) VARCHAR2(1) NOT NULL Flag that indicates whether or not it is Primary
N=No
Y=Yes