RC_TASK_IDRC_BUS_PROCESS_IDRC_TASK_REF1_V(SQL View) |
Index Back |
|---|---|
Business Project ViewCRM Common Pbject Business Project View |
| SELECT DISTINCT B.RC_TASK_ID , A.RC_BUS_PROCESS_ID FROM PS_RC_BP_TRNS_TO A , PS_RC_ACTIV_TASK B WHERE (A.SOURCE_PHASE = B.RC_ACTIVITY_ID OR A.TARGET_PHASE=B.RC_ACTIVITY_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RC_TASK_ID |
Character(15) | VARCHAR2(15) NOT NULL | Task ID used for Business Process tracking. |
| 2 | RC_BUS_PROCESS_ID |
Character(15) | VARCHAR2(15) NOT NULL | Business Process ID used in Business Process tracking. |