RC_TRNS_FROM_VW

(SQL View)
Index Back

Activity

This 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

  • Related Language Record: RC_TRNS_FRM_LNG
  • # 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_ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID used in Business Process tracking.
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description