Share this page
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 |
