KDLV_PATCH_REPORT_TMP

This temporary table is used when the Patch Application Comparison Report is run.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KDLV_PACKAGES

PACKAGE_ID

PACKAGE_ID

KENV_ENVIRONMENTS

ENVIRONMENT_ID

DEST_ENVIRONMENT_ID

KDLV_PACKAGE_LINES

PACKAGE_LINE_ID

PACKAGE_LINE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

REPORT_ID

NULLABLE

NUMBER

System-generated identifier

PATCH_NUMBER

NULLABLE

VARCHAR2(80)

Number of the Oracle Patch applied

APP_CODE

NULLABLE

VARCHAR2(80)

App code the patch was run under

PACKAGE_ID

NULLABLE

NUMBER

Identifier of the change request

PACKAGE_LINE_ID

NULLABLE

NUMBER

Identifier of the change request line

ACTION_DATE

NULLABLE

DATE

Date the migration took place

LINE_SEQ

NULLABLE

NUMBER

Sequence of the change request line

APPLIED_BY_NAME

NULLABLE

VARCHAR2(80)

A descriptor for the patch

DEST_ENVIRONMENT_ID

NULLABLE

NUMBER

Destination environment

CRH_ROWID

NULLABLE

ROWID

Row ID of the header for the Deployment Management package

LAST_WORKFLOW_STEP_ID

NULLABLE

NUMBER

The last workflow step traversed

PACKAGE_NUMBER

NULLABLE

VARCHAR2(40)

Package number

REVISION

NULLABLE

VARCHAR2(200)

The revision of the patch

Indexes

Index Name

Index Type

Sequence

Column Name

KDLV_PATCH_REPORT_TMP_N1

NONUNIQUE

1

REPORT_ID

KDLV_PATCH_REPORT_TMP_N2

NONUNIQUE

1

PACKAGE_ID

KDLV_PATCH_REPORT_TMP_N2

NONUNIQUE

2

PACKAGE_LINE_ID

Sequences

This table uses no sequences.