BO_ID_BCBO_ID_REPRB_BC_REP_VW02(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 = 9 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_BC |
Number(31,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 2 | BO_ID_REP |
Number(31,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 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 |