KREL_DISTRIBUTIONS

Table containing Distributions created from the Release Screen.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KREL_RELEASES

RELEASE_ID

RELEASE_ID

KNTA_PARAMETER_SET_CONTEXTS

PARAMETER_SET_CONTEXT_ID

USER_DATA_SET_CONTEXT_ID

KWFL_WORKFLOWS_NLS

WORKFLOW_ID

WORKFLOW_ID

Column Descriptions

Column Name

Null?

Data Type

Description

DISTRIBUTION_ID

NOT NULL

NUMBER

System-generated identifier

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

CREATION_DATE

NOT NULL

DATE

Date record was created

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

ENTITY_LAST_UPDATE_DATE

NOT NULL

DATE

Date a record in the entity was last updated

RELEASE_ID

NOT NULL

NUMBER

Release ID. Refers to KREL_RELEASES.

DISTRIBUTION_NAME

NOT NULL

VARCHAR2(80)

Unique name within a Release.

STATUS_CODE

NOT NULL

VARCHAR2(30)

Status within Distribution's workflow. LOOKUP_TYPE = 'WF_PARENT_STATUS'

WORKFLOW_ID

NULLABLE

NUMBER

Workflow ID. Refers to KWFL_WORKFLOWS.

FEEDBACK_FLAG

NOT NULL

VARCHAR2(1)

Whether FEEDBACK_CODE was fed back to original package lines.

FEEDBACK_CODE

NULLABLE

VARCHAR2(30)

Value to feed back to original Package Lines. LOOKUP_TYPE = 'RM - Ready for Release'

DESCRIPTION

NULLABLE

VARCHAR2(240)

Free-form description of the distribution.

USER_DATA_SET_CONTEXT_ID

NULLABLE

NUMBER

Parameter set context identifier for the user data fields

USER_DATA1-20

NULLABLE

VARCHAR2(200)

User data segment

VISIBLE_USER_DATA1-20

NULLABLE

VARCHAR2(200)

User data segment

Indexes

Index Name

Index Type

Sequence

Column Name

KREL_DISTRIBUTIONS_N1

NONUNIQUE

1

RELEASE_ID

KREL_DISTRIBUTIONS_U1

UNIQUE

1

DISTRIBUTION_ID

KREL_DISTRIBUTIONS_U2

UNIQUE

1

DISTRIBUTION_NAME

KREL_DISTRIBUTIONS_U2

UNIQUE

2

RELEASE_ID

Sequences

Sequence Name

Sequence Type

KREL_DISTRIBUTIONS_S

DISTRIBUTION_ID