KCRT_FG_SERVICE_INT

This table stores information for importing services into the KCRT_FG_SERVICE table.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KCRT_TRANSACTIONS

TRANSACTION_ID

PARENT_TRANSACTION_ID

KCRT_FG_CMQC_APP_PROJECT

REQUEST_ID

REQUEST_ID

KCRT_TEMP_BATCH_UPDATE

REQUEST_ID

REQUEST_ID

KCRT_FG_CMDB_APPLICATION

REQUEST_ID

REQUEST_ID

FND_CONCURRENT_REQUESTS

REQUEST_ID

REQUEST_ID

KCRT_REQUESTS

REQUEST_ID

REQUEST_ID

KCRT_FG_WORK_ITEMS

REQUEST_ID

REQUEST_ID

KCRT_FG_UCMDB

REQUEST_ID

REQUEST_ID

KCRT_FG_SLA

REQUEST_ID

REQUEST_ID

KCRT_FG_SERVICE

REQUEST_ID

REQUEST_ID

KCRT_FG_CMQC_PROJECT_STATUS

REQUEST_ID

REQUEST_ID

KCRT_FG_CMQC_QC_ADMIN

REQUEST_ID

REQUEST_ID

KCRT_FG_CMQC_QC_INSTANCE

REQUEST_ID

REQUEST_ID

KCRT_FG_CMQC_TEST_PROJECT

REQUEST_ID

REQUEST_ID

KCRT_FG_CMQC_TEST_STATUS

REQUEST_ID

REQUEST_ID

KCRT_FG_DEMAND_SCHEDULE

REQUEST_ID

REQUEST_ID

KCRT_FG_IMPACT_ANALYSIS

REQUEST_ID

REQUEST_ID

KCRT_FG_MASTER_PROJ_REF

REQUEST_ID

REQUEST_ID

KCRT_FG_PFM_ASSET

REQUEST_ID

REQUEST_ID

KCRT_FG_PFM_PROJECT

REQUEST_ID

REQUEST_ID

KCRT_FG_PFM_PROPOSAL

REQUEST_ID

REQUEST_ID

KCRT_FG_PROG_ISSUE

REQUEST_ID

REQUEST_ID

KCRT_FG_PROG_REFERENCE

REQUEST_ID

REQUEST_ID

KCRT_FG_PROG_RESOURCE_REQ

REQUEST_ID

REQUEST_ID

KCRT_FG_PROG_RISK

REQUEST_ID

REQUEST_ID

KCRT_FG_PROJ_ISSUE

REQUEST_ID

REQUEST_ID

KCRT_FG_PROJ_RISK

REQUEST_ID

REQUEST_ID

KCRT_FG_PROJ_SCOPE_CHANGE

REQUEST_ID

REQUEST_ID

KCRT_FG_QC_DEFECT_INFO

REQUEST_ID

REQUEST_ID

KCRT_FG_QC_INFO

REQUEST_ID

REQUEST_ID

KCRT_REQUEST_TYPES_NLS

REQUEST_TYPE_ID

REQUEST_TYPE_ID

KNTA_SERVICES_NLS

SERVICE_ID

SERVICE_ID

KRSC_ORG_UNITS_INT

TRANSACTION_ID

TRANSACTION_ID

KNTA_USERS_INT

TRANSACTION_ID

TRANSACTION_ID

KWFL_TRANSACTIONS_INT

TRANSACTION_ID

TRANSACTION_ID

KWFL_STEP_TRANSITIONS_INT

TRANSACTION_ID

TRANSACTION_ID

KNTA_USER_SECURITY_INT

TRANSACTION_ID

TRANSACTION_ID

KRSC_ORG_UNIT_MEMBERS_INT

TRANSACTION_ID

TRANSACTION_ID

KCRT_TRANSACTIONS

TRANSACTION_ID

TRANSACTION_ID

Column Descriptions

Column Name

Null?

Data Type

Description

GROUP_ID

NULLABLE

NUMBER

System-generated identifier

TRANSACTION_ID

NULLABLE

NUMBER

Transaction ID

PARENT_TRANSACTION_ID

NULLABLE

NUMBER

Parent transaction ID

REQUEST_ID

NOT NULL

NUMBER

Request ID

REQUEST_TYPE_ID

NOT NULL

NUMBER

Request type ID

SERVICE_ID

NULLABLE

VARCHAR2(40)

Service ID

SERVICE_NAME

NULLABLE

VARCHAR2(255)

Service name

Indexes

Index Name

Index Type

Sequence

Column Name

KCRT_FG_SERVICE_INT_N1

NONUNIQUE

1

GROUP_ID

KCRT_FG_SERVICE_INT_N1

NONUNIQUE

2

TRANSACTION_ID

Sequences

This table uses no sequences.