RC_TRNS_FROM_VW(SQL View) |
Index Back |
---|---|
ActivityThis table stores the activities that make up a Business Process. |
SELECT DISTINCT A.RC_BUS_PROCESS_ID , B.RC_ACTIVITY_ID , B.DESCR FROM PS_RC_BP_TRNS_TO A , PS_RC_ACTIVITY 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 | Character(15) | VARCHAR2(15) NOT NULL | Business Process ID used in Business Process tracking. | |
2 | Character(15) | VARCHAR2(15) NOT NULL | Activity ID used in Business Process tracking. | |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |