KCRT_REQUEST_DETAILS_INT

This is a child table of KCRT_REQUESTS_INT. The KCRT_REQUEST_DETAILS_INT corresponds to KCRT_REQUEST_DETAILS tables. This table is processed through the java report that calls a PL/SQL package that can be run either from the command line or through the report job scheduler. This allows the user to immediately run the interface while allowing for scheduled processing. PL/SQL package will query this table, validate against appropriate tables and imports into the production tables. It can also release the request, depending on its status, by calling the Workflow APIs.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_PARAMETER_SET_CONTEXTS

PARAMETER_SET_CONTEXT_ID

PARAMETER_SET_CONTEXT_ID

KCRT_REQUESTS_INT

TRANSACTION_ID

PARENT_TRANSACTION_ID

KCRT_REQUEST_DETAILS

REQUEST_DETAIL_ID

REQUEST_DETAIL_ID

KCRT_REQUESTS

REQUEST_ID

REQUEST_ID

KCRT_REQUEST_TYPES_NLS

REQUEST_TYPE_ID

REQUEST_TYPE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

GROUP_ID

NOT NULL

NUMBER

System-generated identifier

TRANSACTION_ID

NOT NULL

NUMBER

System-generated record identifier

PARENT_TRANSACTION_ID

NOT NULL

NUMBER

Transaction ID of the parent table being imported

REQUEST_DETAIL_ID

NULLABLE

NUMBER

Refers to the request_detail_id in KCRT_REQUEST_DETAILS table

REQUEST_ID

NULLABLE

NUMBER

Refers to the request_id in KCRT_REQUESTS table

REQUEST_TYPE_ID

NULLABLE

NUMBER

Request type ID used by this request

PARAMETER_SET_CONTEXT_ID

NULLABLE

NUMBER

Parameter set context identifier for the configurable parameters of the request

BATCH_NUMBER

NULLABLE

NUMBER

Batch number of the request detail where this PARAMETER field is found

PARAMETER1-40

NULLABLE

VARCHAR2(200)

Request Detail Parameter

VISIBLE_PARAMETER1-40

NULLABLE

VARCHAR2(200)

Request Detail Parameter

PARAMETER41-50

NULLABLE

VARCHAR2(4000)

Request Detail Parameter

VISIBLE_PARAMETER41-50

NULLABLE

VARCHAR2(4000)

Request Detail Parameter

LOOKUP_TYPE1-50

NULLABLE

VARCHAR2(80)

Refers to the LOOKUP_TYPE in KNTA_LOOKUPS

VALIDATION_TYPE_CODE1-50

NULLABLE

VARCHAR2(30)

Refers to the VALIDATION_TYPE_CODE in KNTA_VALIDATIONS

Indexes

Index Name

Index Type

Sequence

Column Name

KCRT_REQUEST_DETAILS_INT_N1

NONUNIQUE

1

GROUP_ID

KCRT_REQUEST_DETAILS_INT_N1

NONUNIQUE

2

TRANSACTION_ID

Sequences

This table uses no sequences.