RC_BUS_PROCESS_IDRC_SBP_REF1_V(SQL View) |
Index Back |
|---|
| SELECT B.RC_TASK_ID , A.RC_BUS_PROCESS_ID ,C.DESCR FROM PS_RC_BP_TRNS_TO A , PS_RC_ACTIV_TASK B , PS_RC_BUS_PROCESS C WHERE (A.SOURCE_PHASE = B.RC_ACTIVITY_ID OR A.TARGET_PHASE=B.RC_ACTIVITY_ID) AND B.NESTED_BP_IND='Y' AND A.RC_BUS_PROCESS_ID=C.RC_BUS_PROCESS_ID AND A.EFFDT=C.EFFDT GROUP BY B.RC_TASK_ID, A.RC_BUS_PROCESS_ID, C.DESCR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RC_BUS_PROCESS_ID |
Character(15) | VARCHAR2(15) NOT NULL | Business Process ID used in Business Process tracking. |
| 2 | RC_BUS_PROCESS_ID2 | Character(15) | VARCHAR2(15) NOT NULL | Business Process ID used in Business Process tracking. |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |