KCRT_FG_MASTER_PROJ_REF

If the Master Project Reference field on Request field group is linked to a request's request header type, a row will exist in this table for the request.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KCRT_REQUEST_TYPES_NLS

REQUEST_TYPE_ID

REQUEST_TYPE_ID

PM_PROJECTS

PROJECT_ID

REF_MASTER_PROJECT_ID

Column Descriptions

Column Name

Null?

Data Type

Description

REQUEST_ID

NOT NULL

NUMBER

Request identifier

REQUEST_TYPE_ID

NOT NULL

NUMBER

Request type used by the request

REF_MASTER_PROJECT_ID

NULLABLE

NUMBER

If a value is supplied, automatically creates a reference to the specified master project. If supplied, must also specify REF_MASTER_PROJECT_NAME.

REF_MASTER_PROJECT_NAME

NULLABLE

VARCHAR2(300)

If a value is supplied, automatically creates a reference to the specified master project. If supplied, must also specify REF_MASTER_PROJECT_ID.

Indexes

Index Name

Index Type

Sequence

Column Name

KCRT_FG_MASTER_PROJ_REF_U1

UNIQUE

1

REQUEST_ID

Sequences

This table uses no sequences.