RC_BS_ACTIONSET_IDRC_ACTION_SET_V(SQL View) |
Index Back |
|---|
| SELECT DISTINCT (A.RC_BS_ACTIONSET_ID) , C.RC_ACTIONSET_NAME FROM PS_RC_ACTSET_ITEM A , PS_RC_BS_ACTION B , PS_RC_BS_ACTIONSET C WHERE A.RC_BS_ACTIONSET_ID = C.RC_BS_ACTIONSET_ID AND A.RC_ACTION_ID = B.RC_ACTION_ID AND B.ACTION_TYPE IN ('P','C') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RC_BS_ACTIONSET_ID |
Number(12,0) | DECIMAL(12) NOT NULL | Branch script |
| 2 | RC_ACTIONSET_NAME | Character(40) | VARCHAR2(40) NOT NULL | used in branch script product |