KNTA_REFRESH_LINES

This is a staging table for the Environment Refresh process. It stores each request line that qualifies under the refresh logic.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KWFL_WORKFLOW_STEPS_NLS

WORKFLOW_STEP_ID

FROM_STEP_ID

KWFL_STEP_TRANSACTIONS

STEP_TRANSACTION_ID

FROM_STEP_TRANSACTION_ID

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KDLV_PACKAGES

PACKAGE_ID

PACKAGE_ID

KDLV_PACKAGE_LINES

PACKAGE_LINE_ID

PACKAGE_LINE_ID

KNTA_REFRESH_GROUPS

REFRESH_GROUP_ID

REFRESH_GROUP_ID

KWFL_WORKFLOW_STEPS_NLS

WORKFLOW_STEP_ID

TO_STEP_ID

KWFL_WORKFLOWS_NLS

WORKFLOW_ID

WORKFLOW_ID

KWFL_WORKFLOW_INSTANCES

WORKFLOW_INSTANCE_ID

WORKFLOW_INSTANCE_ID

KWFL_WORKFLOW_INSTANCE_STEPS

WORKFLOW_INSTANCE_STEP_ID

WORKFLOW_INSTANCE_STEP_ID

Column Descriptions

Column Name

Null?

Data Type

Description

REFRESH_GROUP_ID

NULLABLE

NUMBER

Refresh Group to which this line belongs

REFRESH_LINE_ID

NULLABLE

NUMBER

System-generated identifier

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

SOURCE_CODE

NULLABLE

VARCHAR2(30)

Source for the line (MANUAL, DERIVED)

PACKAGE_ID

NULLABLE

NUMBER

Identifier for the Package

PACKAGE_LINE_ID

NULLABLE

NUMBER

Identifier for the Package Line

WORKFLOW_ID

NULLABLE

NUMBER

Identifier for the Workflow to which the Package Line belongs

WORKFLOW_INSTANCE_ID

NULLABLE

NUMBER

Identifier for the workflow instance

WORKFLOW_INSTANCE_STEP_ID

NULLABLE

NUMBER

Identifier for the workflow instance step

FROM_STEP_ID

NULLABLE

NUMBER

Identifier for the workflow step that was eligible before refresh

FROM_STEP_TRANSACTION_ID

NULLABLE

NUMBER

Identifier for the workflow step transaction that was eligible before refresh

TO_STEP_ID

NULLABLE

NUMBER

Identifier for the workflow step that will be eligible after refresh

STATUS_CODE

NULLABLE

VARCHAR2(30)

Refresh status for the line (PENDING, COMPLETED, EXCLUDE)

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_REFRESH_LINES_N1

NONUNIQUE

1

PACKAGE_ID

KNTA_REFRESH_LINES_N1

NONUNIQUE

2

PACKAGE_LINE_ID

KNTA_REFRESH_LINES_N2

NONUNIQUE

1

PACKAGE_LINE_ID

KNTA_REFRESH_LINES_N2

NONUNIQUE

2

PACKAGE_ID

KNTA_REFRESH_LINES_U1

UNIQUE

1

REFRESH_GROUP_ID

KNTA_REFRESH_LINES_U1

UNIQUE

2

REFRESH_LINE_ID

Sequences

Sequence Name

Sequence Type

KNTA_REFRESH_LINES_S

REFRESH_LINE_ID