BO_ID_CUSTBO_ID_CONTACTRB_BC_REP_VW03(SQL View) |
Index Back |
|---|---|
RB_BC_REP_VIEWCRM Common Object: ...................................... |
| SELECT A.BO_ID , B.BO_ID_1 , C.BO_NAME ,D.BO_NAME FROM PS_BC A , PS_BO_REL B , PS_BO C , PS_BO D ,PS_BO_ROLE E WHERE A.BO_ID = B.BO_ID_2 AND A.CUSTOMER_IND = 'Y' AND B.REL_TYPE_ID IN (7, 8) AND A.BO_ID = C.BO_ID AND B.BO_ID_1 = D.BO_ID AND A.BO_ID = E.BO_ID AND E.ROLE_TYPE_ID IN (2, 3) AND B.START_DT <= %CurrentDateIn AND (B.END_DT > %CurrentDateIn OR B.END_DT IS NULL) |
| # | 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_CONTACT |
Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
| 3 | BO_NAME_1 | Character(50) | VARCHAR2(50) NOT NULL | BO Name 1 |
| 4 | BO_NAME_2 | Character(50) | VARCHAR2(50) NOT NULL | BO Name 2 |