BO_IDREL_CLASS_IDBO_REL_IDRBW_BO_CL_RL_VW(SQL View) |
Index Back |
|---|---|
BO Class Rel viewClassification/Relationship instances associated with a BO |
| SELECT BO.BO_ID , RC.REL_CLASS_ID , REL.BO_REL_ID , RELT.REL_TYPE_ID , RC.NEW_BO_FLG , RC.INDIRECT_FLG , REL.BO_ID_1 , RELT.ROLE_TYPE_ID_1 , REL.BO_ID_2 , RELT.ROLE_TYPE_ID_2 FROM PS_BO BO , PS_RBW_REL_CLASS RC , PS_RBW_REL_CLS_ROL RCR , PS_BO_REL_TYPE RELT , PS_BO_REL REL WHERE (BO.BO_ID = REL.BO_ID_1 OR BO.BO_ID = REL.BO_ID_2) AND (REL.ROLE_TYPE_ID_1 = RELT.ROLE_TYPE_ID_1 OR REL.ROLE_TYPE_ID_2 = RELT.ROLE_TYPE_ID_1) AND RELT.REL_TYPE_ID = REL.REL_TYPE_ID AND RC.REL_CLASS_ID = RCR.REL_CLASS_ID AND RCR.REL_TYPE_ID = RELT.REL_TYPE_ID AND RC.ACTIVE_FLG = 'Y' AND REL.START_DT <= %CurrentDateIn AND (REL.END_DT > %CurrentDateIn OR REL.END_DT IS NULL) |
| # | 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 | REL_CLASS_ID |
Number(12,0) | DECIMAL(12) NOT NULL | Unique identifier of a Relationship Classification in Wealth Management |
| 3 | BO_REL_ID |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Relationship ID of a Business Object |
| 4 | REL_TYPE_ID | Number(12,0) | DECIMAL(12) NOT NULL | Relationship Type ID |
| 5 | NEW_BO_FLG | Character(1) | VARCHAR2(1) NOT NULL | Indicates whether a Relationship Classification should result in a new Business Object |
| 6 | INDIRECT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Indicates whether a Relationship Classification should be included in an indirect revenue roll-up |
| 7 | BO_ID_1 | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID 1 |
| 8 | ROLE_TYPE_ID_1 | Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID |
| 9 | BO_ID_2 | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID 2 |
| 10 | ROLE_TYPE_ID_2 | Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID |