RO_COMPNCNT_VW

(SQL View)
Index Back

CRM Company

This view is used as a filter in the BO Search for Order Capture.

SELECT DISTINCT A.BO_ID FROM PS_RD_COMPANY A , PS_BO_REL B WHERE A.BO_ID = B.BO_ID_2 AND B.REL_TYPE_ID NOT IN (9, 10, 74, 75)

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