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