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.