KCRT_RT_REQUEST_RESOURCES

This table is used for storing the resources assigned to a request.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KCRT_FG_SLA

REQUEST_ID

REQUEST_ID

KCRT_FG_CMQC_QC_ADMIN

REQUEST_ID

REQUEST_ID

KCRT_FG_PFM_PROJECT

REQUEST_ID

REQUEST_ID

KCRT_FG_PFM_ASSET

REQUEST_ID

REQUEST_ID

KCRT_FG_CMQC_APP_PROJECT

REQUEST_ID

REQUEST_ID

KCRT_FG_PROG_RESOURCE_REQ

REQUEST_ID

REQUEST_ID

KCRT_FG_PROJ_ISSUE

REQUEST_ID

REQUEST_ID

KCRT_FG_CMQC_TEST_PROJECT

REQUEST_ID

REQUEST_ID

KCRT_FG_CMDB_APPLICATION

REQUEST_ID

REQUEST_ID

KCRT_FG_PROJ_SCOPE_CHANGE

REQUEST_ID

REQUEST_ID

KCRT_FG_PROG_ISSUE

REQUEST_ID

REQUEST_ID

KCRT_FG_CMQC_TEST_STATUS

REQUEST_ID

REQUEST_ID

KCRT_FG_PFM_PROPOSAL

REQUEST_ID

REQUEST_ID

KCRT_FG_DEMAND_SCHEDULE

REQUEST_ID

REQUEST_ID

KCRT_FG_MASTER_PROJ_REF

REQUEST_ID

REQUEST_ID

KCRT_FG_CMQC_PROJECT_STATUS

REQUEST_ID

REQUEST_ID

KCRT_FG_PROJ_RISK

REQUEST_ID

REQUEST_ID

KCRT_FG_QC_INFO

REQUEST_ID

REQUEST_ID

KCRT_FG_QC_DEFECT_INFO

REQUEST_ID

REQUEST_ID

KCRT_FG_WORK_ITEMS

REQUEST_ID

REQUEST_ID

KCRT_REQUESTS

REQUEST_ID

REQUEST_ID

KCRT_FG_CMQC_QC_INSTANCE

REQUEST_ID

REQUEST_ID

KCRT_FG_IMPACT_ANALYSIS

REQUEST_ID

REQUEST_ID

KCRT_REQUEST_RSC_ACTUALS

REQUEST_RSC_ACTUALS_ID

REQUEST_RSC_ACTUALS_ID

RSC_RESOURCE_ROLES

RESOURCE_ID

RESOURCE_ID

RSC_RESOURCES

RESOURCE_ID

RESOURCE_ID

KNTA_I18N_RESOURCES_NLS

RESOURCE_ID

RESOURCE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

RESOURCE_REQUEST_ID

NULLABLE

NUMBER

System-generated identifier

RESOURCE_ID

NULLABLE

NUMBER

For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update

REQUEST_ID

NULLABLE

NUMBER

REQUEST_RSC_ACTUALS_ID

NULLABLE

NUMBER

Indexes

Index Name

Index Type

Sequence

Column Name

KCRT_RT_REQUEST_RESOURCES_N1

NONUNIQUE

1

RESOURCE_ID

KCRT_RT_REQUEST_RESOURCES_N2

NONUNIQUE

1

REQUEST_ID

KCRT_RT_REQUEST_RESOURCES_U1

NONUNIQUE

1

RESOURCE_ID

KCRT_RT_REQUEST_RESOURCES_U1

NONUNIQUE

2

REQUEST_ID

Sequences

Sequence Name

Sequence Type

KCRT_RT_REQUEST_RESOURCES_S

RESOURCE_REQUEST_ID