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.