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