KNTA_REFRESH_LINE_DETAILS

This is a staging table used by the Environment Refresh Process. It stores exception messages for specific request lines.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_REFRESH_LINES

REFRESH_LINE_ID

REFRESH_LINE_ID

KNTA_USERS

USER_ID

CREATED_BY

KNTA_REFRESH_GROUPS

REFRESH_GROUP_ID

REFRESH_GROUP_ID

KNTA_USERS

USER_ID

LAST_UPDATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

REFRESH_LINE_DETAIL_ID

NULLABLE

NUMBER

System-generated identifier

REFRESH_GROUP_ID

NULLABLE

NUMBER

Identifier for the refresh group to which this message belongs

REFRESH_LINE_ID

NULLABLE

NUMBER

Identifier for the refresh line to which this message belongs

CREATION_DATE

NULLABLE

DATE

Date record was created

CREATED_BY

NULLABLE

NUMBER

Identifier for the user who created the record

LAST_UPDATE_DATE

NULLABLE

DATE

Date record was last updated

LAST_UPDATED_BY

NULLABLE

NUMBER

Identifier for the user who last updated the record

DETAIL_TEXT

NULLABLE

VARCHAR2(2000)

Exception message

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_REFRESH_LINE_DETAILS_N1

NONUNIQUE

1

REFRESH_GROUP_ID

KNTA_REFRESH_LINE_DETAILS_N1

NONUNIQUE

2

REFRESH_LINE_ID

KNTA_REFRESH_LINE_DETAILS_U1

UNIQUE

1

REFRESH_LINE_DETAIL_ID

Sequences

Sequence Name

Sequence Type

KNTA_REFRESH_LINE_DETAILS_S

REFRESH_LINE_DETAIL_ID