BO_ID_ORGRBW_HH_CM_BO_VW(SQL View) |
Index Back |
|---|---|
BO CM BO viewView to get the primary contact information BO for a given Household BO |
| SELECT REL.BO_ID_2 ,REL.BO_ID_1 FROM PS_RD_HOUSEHOLD HH , PS_RBW_REL_CLASS RC , PS_RBW_REL_CLS_ROL RCR , PS_BO_REL_TYPE RELT , PS_BO_REL REL WHERE HH.BO_ID = REL.BO_ID_2 AND RC.ROLE_TYPE_ID_ORG = REL.ROLE_TYPE_ID_2 AND RC.REL_CLASS_ID = RCR.REL_CLASS_ID AND RELT.ROLE_TYPE_ID_1 = REL.ROLE_TYPE_ID_1 AND RELT.REL_TYPE_ID = RCR.REL_TYPE_ID AND RC.ACTIVE_FLG = 'Y' AND RCR.USE_CM_INFO_FLG = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BO_ID_ORG |
Number(31,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 2 | BO_ID_CM | Number(31,0) | DECIMAL(31) NOT NULL | Business Object ID |