OKC_DELIVERABLES_H
OKC_DELIVERABLES_H stores deliverables present on a business document. Each deliverable has a due date, either a fixed due date or relative due date. A relative due date is relative to an event in the lifecycle of the business document. A deliverable can be one-time or recurring. A deliverable can be defined on a business document like Purchase Order, RFQ, RFI, Blanket Purchase Agreement or defined on a Contract Template and defaulted onto the business document from the contract template . Deliverables can be one of the three types: Contractual, Internal Purchasing and Negotiation. Each deliverable can have a responsible party (Supplier or Buyer Organization) and a contact for each. Note: Deliverables are only supported on Procurement Contracts covering the following document types: a) Purchase Order b) Blanket Purchase Agreement c) RFQ d) RFI and e) Auctions
Details
-
Schema: FUSION
-
Object owner: OKC
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
OKC_DELIVERABLES_H_PK |
DELIVERABLE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DELIVERABLE_ID | NUMBER | 18 | Yes | Unique Identifier for a Deliverable. This is also the Primary key for the table. | |
| CONTRACT_TYPE_ID | NUMBER | 18 | CONTRACT_TYPE_ID | ||
| MANUALLY_ACTIVATED_YN | VARCHAR2 | 1 | MANUALLY_ACTIVATED_YN | ||
| BUSINESS_DOCUMENT_TYPE | VARCHAR2 | 30 | Yes | Business Document Type for the Deliverable. Refers to DOCUMENT_TYPE in OKC_BUS_DOC_TYPES_B | |
| BUSINESS_DOCUMENT_ID | NUMBER | Yes | Unique Identifier for a Business Document of the Business Document Type. (Example: If BUSINESS_DOCUMENT_TYPE= `BPA` then the BUSINESS_DOCUMENT_ID with the PO_HEADER_ID from PO_HEADERS_ALL) | ||
| BUSINESS_DOCUMENT_NUMBER | VARCHAR2 | 150 | Document Number for a Business Document. Example: PO_NUMBER, AUCTION_ID . | ||
| DELIVERABLE_TYPE | VARCHAR2 | 30 | Yes | Deliverable Type for the given Deliverable. Some of the valid values are CONTRACTUAL, INTERNAL_PURCHASING and SOURCING. Refers to the deliverable_type_code in OKC_DELIVERABLE_TYPES_B. | |
| RESPONSIBLE_PARTY | VARCHAR2 | 30 | Yes | Responsible Party for the given Deliverable. Valid Values are SUPPLIER_ORG or BUYER_ORG. Refers to the RESP_PARTY_CODE in the OKC_DEL_RESP_PARTIES_B table. | |
| INTERNAL_PARTY_CONTACT_ID | NUMBER | Unique Identifier for the Internal Party contact on a Deliverable | |||
| EXTERNAL_PARTY_CONTACT_ID | NUMBER | Unique Identifier for the External Party contact on a Deliverable | |||
| DELIVERABLE_NAME | VARCHAR2 | 240 | Yes | Name for the Deliverable. | |
| DESCRIPTION | VARCHAR2 | 2000 | Deliverable description | ||
| COMMENTS | VARCHAR2 | 2000 | Notes added on the Deliverable by the internal user. | ||
| DISPLAY_SEQUENCE | NUMBER | Yes | The sequence in which the deliverable will appear on a Contract when printed. | ||
| FIXED_DUE_DATE_YN | VARCHAR2 | 1 | Yes | Flag to indicate if the deliverable has a fixed due date. Valid values are Y and N. | |
| ACTUAL_DUE_DATE | DATE | The actual date by which the deliverable is due. | |||
| RECURRING_YN | VARCHAR2 | 1 | Yes | Flag to indicate if the deliverable is one-time or recurring. Valid values are Y and N. | |
| NOTIFY_PRIOR_DUE_DATE_VALUE | NUMBER | Indicates the number of periods (period type specified by NOTIFY_PRIOR_DUE_DATE_UOM column) prior to the due date by which the Reminder notification has to be sent. | |||
| NOTIFY_PRIOR_DUE_DATE_UOM | VARCHAR2 | 30 | Indicates the period type (Days, Weeks or Months) prior to the due date by which the Deliverable Reminder notification has to be sent. Refers to LOOKUP_CODE in FND_LOOKUPS where LOOKUP_TYPE = `OKC_DELIVERABLE_TIME_UNITS`. | ||
| NOTIFY_PRIOR_DUE_DATE_YN | VARCHAR2 | 1 | Yes | Flag to indicate whether a notification needs to be sent prior to the Due Date on the Deliverable. | |
| NOTIFY_COMPLETED_YN | VARCHAR2 | 1 | Yes | Flag to indicate whether a notification should be sent upon any change in status of the Deliverable. | |
| NOTIFY_OVERDUE_YN | VARCHAR2 | 1 | Yes | Flag to indicate whether a notification needs to be sent if the Deliverable is overdue. | |
| NOTIFY_ESCALATION_YN | VARCHAR2 | 1 | Yes | Flag to indicate whether an escalation notification needs to be sent if the Deliverable is overdue. | |
| NOTIFY_ESCALATION_VALUE | NUMBER | Indicates the number of periods (period type specified by the NOTIFY_ESCALATION_UOM column) after the due date by which an escalation notification is to be sent | |||
| NOTIFY_ESCALATION_UOM | VARCHAR2 | 30 | Indicates the period type (Days, Weeks or Months) by which an escalation notification is due. Refers to the LOOKUP_CODE in FND_LOOKUPS where LOOKUP_TYPE= `OKC_DELIVERABLE_TIME_UNITS`. | ||
| ESCALATION_ASSIGNEE | NUMBER | Unique Identifier for the Internal Party contact to whom the escalation notification needs to be sent | |||
| AMENDMENT_OPERATION | VARCHAR2 | 30 | Code to indicate the type of the amendment performed on the Deliverable. Valid values are ADDED, DELETED and UPDATED. Refers to the LOOKUP_CODE in FND_LOOKUPS where LOOKUP_TYPE= `OKC_AMEND_OPN_CODE`. | ||
| PRIOR_NOTIFICATION_ID | NUMBER | System generated identifier for the Notification sent as Reminder Notification prior to the due date of the Deliverable. | |||
| AMENDMENT_NOTES | VARCHAR2 | 2000 | Notes to describe the amendment operation performed on the Deliverable. | ||
| COMPLETED_NOTIFICATION_ID | NUMBER | System generated identifier for the Notification sent upon status change of a Deliverable. | |||
| OVERDUE_NOTIFICATION_ID | NUMBER | System generated identifier for the Notification sent when a Deliverable is overdue. | |||
| ESCALATION_NOTIFICATION_ID | NUMBER | System generated identifier for the Notification sent when an overdue Deliverable is escalated. | |||
| DELIVERABLE_LANGUAGE | VARCHAR2 | 12 | Yes | Language of the Deliverable | |
| ORIGINAL_DELIVERABLE_ID | NUMBER | Yes | Identifier of the original deliverable on which amendments have been performed. This is carried forward across all the versions of that deliverable. This will be used to synchronize status of a deliverable across versions. | ||
| REQUESTER_ID | NUMBER | Unique Identifier for the Internal Party contact who requested the Deliverable. | |||
| EXTERNAL_PARTY_ID | NUMBER | Unique Identifier for the External Party on the Deliverable | |||
| RECURRING_DEL_PARENT_ID | NUMBER | Deliverable Id of the recurring Deliverable from which recurring instances are generated. | |||
| BUSINESS_DOCUMENT_VERSION | NUMBER | Yes | Business document version for a given Business Document Id | ||
| RELATIVE_ST_DATE_DURATION | NUMBER | Duration before or after the Relative Start Date. The period type is defined by the RELATIVE_ST_DATE_UOM | |||
| RELATIVE_ST_DATE_UOM | VARCHAR2 | 30 | Period type for the start date of the due date. Only applicable when the deliverable has a relative start date. Refers to the LOOKUP_CODE in FND_LOOKUPS where LOOKUP_TYPE= `OKC_DELIVERABLE_TIME_UNITS`. | ||
| RELATIVE_ST_DATE_EVENT_ID | NUMBER | Unique Identifier for the start date event. Only applicable when the deliverable has a relative start date. Refers to the EVENT_ID in OKC_BUS_DOC_EVENTS_B | |||
| RELATIVE_END_DATE_DURATION | NUMBER | Duration before or after the Relative End Date. The period type is defined by the RELATIVE_END_DATE_UOM | |||
| RELATIVE_END_DATE_UOM | VARCHAR2 | 30 | Period type for the end date of the due date. Only applicable when the deliverable has a relative end date. Refers to the LOOKUP_CODE in FND_LOOKUPS where LOOKUP_TYPE= `OKC_DELIVERABLE_TIME_UNITS`. | ||
| RELATIVE_END_DATE_EVENT_ID | NUMBER | Unique Identifier for the end date event. Refers to EVENT_ID in OKC_BUS_DOC_EVENTS_B | |||
| REPEATING_DAY_OF_MONTH | VARCHAR2 | 30 | Day of the month the deliverable will repeat. Refers to LOOKUP_CODE in FND_LOOKUPS where LOOKUP_TYPE=` OKC_DAY_OF_MONTH ` | ||
| REPEATING_DAY_OF_WEEK | VARCHAR2 | 30 | Day of the week the deliverable will repeat. Refers to the LOOKUP_CODE in FND_LOOKUPS where LOOKUP_TYPE= `DAY_OF_WEEK`. | ||
| REPEATING_FREQUENCY_UOM | VARCHAR2 | 30 | Repeating frequency for a recurring deliverable.. Used in conjunction with the REPEATING_DURATION column to define the repeating frequency. Example: 3 months. Refers to the LOOKUP_CODE in FND_LOOKUPS where LOOKUP_TYPE= `OKC_DEL_REPEAT_FREQ`. | ||
| REPEATING_DURATION | NUMBER | Duration of the repeating frequency for a recurring deliverable. Used in conjunction with REPEATING_FREQUENCY_UOM. Example: 3 months | |||
| FIXED_START_DATE | DATE | Start date of the deliverable when the start date is fixed. | |||
| FIXED_END_DATE | DATE | End date of the deliverable when the end date is fixed. | |||
| MANAGE_YN | VARCHAR2 | 1 | Yes | Flag to indicate if the deliverable is active and if it can be managed/fulfilled. Valid values are Y and N | |
| INTERNAL_PARTY_ID | NUMBER | Unique identifier for the Internal party on the deliverable. | |||
| DELIVERABLE_STATUS | VARCHAR2 | 30 | Yes | Current status of this Deliverable. Refers to LOOKUP_CODE in FND_LOOKUPS where LOOKUP_TYPE= `OKC_DELIVERABLE_STATUS` | |
| STATUS_CHANGE_NOTES | VARCHAR2 | 2000 | Notes provided by the responsible party as part of managing the deliverable | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE26 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE27 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE28 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE29 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE30 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| DISABLE_NOTIFICATIONS_YN | VARCHAR2 | 1 | Yes | Flag to indicate whether or not notifications are disabled for a Deliverable. Valid values are Y or N. By default the value is N . Used to disable notifications for e.g., on a draft bid until the bid is submitted. The value is set to Y once the bid is submitted. | |
| LAST_AMENDMENT_DATE | DATE | Last time amendment occurred on this Deliverable | |||
| BUSINESS_DOCUMENT_LINE_ID | NUMBER | Unique Identifier for a Line Item in a Business Document. (For Future use) | |||
| EXTERNAL_PARTY_SITE_ID | NUMBER | Unique identifier for the external party site. Example: Supplier Site of a Supplier | |||
| START_EVENT_DATE | DATE | Date on which the start event of this Deliverable occurred. Only applicable for a Relative due date deliverable. | |||
| END_EVENT_DATE | DATE | Date on which the end event of this Deliverable occurred. Only applicable for a Relative due date deliverable. | |||
| SUMMARY_AMEND_OPERATION_CODE | VARCHAR2 | 30 | Resultant amendment code for the amendment operations performed on a deliverable between two signed versions of the business document. | ||
| EXTERNAL_PARTY_ROLE | VARCHAR2 | 30 | Role of the external party. Valid values are SUPPLIER_ORG, CUSTOMER_ORG, PARTNER_ORG. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| OKC_DELIVERABLES_H | okc_business_events_b | RELATIVE_ST_DATE_EVENT_ID |
| OKC_DELIVERABLES_H | okc_business_events_b | RELATIVE_END_DATE_EVENT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| OKC_DELIVERABLES_H_N1 | Non Unique | Default | BUSINESS_DOCUMENT_TYPE, BUSINESS_DOCUMENT_ID, BUSINESS_DOCUMENT_VERSION, CONTRACT_TYPE_ID |
| OKC_DELIVERABLES_H_U1 | Unique | Default | DELIVERABLE_ID |