KCRT_REQ_TYPE_ACTIVITY_LIST
This table stores the list of valid activities for a specific request type. This table is only used when the TM_SETTING_ALL_ACT column in the PPM_RESOURCE_SETTINGS table is set to N.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
KCRT_REQUEST_TYPES_NLS |
REQUEST_TYPE_ID |
REQUEST_TYPE_ID |
ITG_ACTIVITIES_NLS |
ACTIVITY_ID |
ACTIVITY_ID |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
REQUEST_TYPE_ACTIVITY_ID |
NULLABLE |
NUMBER |
System-generated identifier |
REQUEST_TYPE_ID |
NULLABLE |
NUMBER |
Request type ID. Primary key from the KCRT_REQUEST_TYPES_NLS table. |
ACTIVITY_ID |
NULLABLE |
NUMBER |
Activity ID. Primary key from the ITG_ACTIVITY_NLS table. |
Indexes
This table does not use any Indexes.
Sequences
Sequence Name |
Sequence Type |
---|---|
KCRT_REQ_TYPE_ACTIVITY_LIST_S |
REQUEST_TYPE_ACTIVITY_ID |