OKC_DELIVERABLES
OKC_DELIVERABLES 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_PK |
DELIVERABLE_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
---|---|---|---|---|---|---|
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. | Contract Terms Deliverable (ContractTermsDeliverableFlex) | ||
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contract Terms Deliverable (ContractTermsDeliverableFlex) | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contract Terms Deliverable (ContractTermsDeliverableFlex) | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contract Terms Deliverable (ContractTermsDeliverableFlex) | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contract Terms Deliverable (ContractTermsDeliverableFlex) | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contract Terms Deliverable (ContractTermsDeliverableFlex) | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contract Terms Deliverable (ContractTermsDeliverableFlex) | ||
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contract Terms Deliverable (ContractTermsDeliverableFlex) | ||
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contract Terms Deliverable (ContractTermsDeliverableFlex) | ||
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contract Terms Deliverable (ContractTermsDeliverableFlex) | ||
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contract Terms Deliverable (ContractTermsDeliverableFlex) | ||
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contract Terms Deliverable (ContractTermsDeliverableFlex) | ||
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contract Terms Deliverable (ContractTermsDeliverableFlex) | ||
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contract Terms Deliverable (ContractTermsDeliverableFlex) | ||
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contract Terms Deliverable (ContractTermsDeliverableFlex) | ||
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contract Terms Deliverable (ContractTermsDeliverableFlex) | ||
ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contract Terms Deliverable (ContractTermsDeliverableFlex) | ||
ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contract Terms Deliverable (ContractTermsDeliverableFlex) | ||
ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contract Terms Deliverable (ContractTermsDeliverableFlex) | ||
ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contract Terms Deliverable (ContractTermsDeliverableFlex) | ||
ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contract Terms Deliverable (ContractTermsDeliverableFlex) | ||
ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contract Terms Deliverable (ContractTermsDeliverableFlex) | ||
ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contract Terms Deliverable (ContractTermsDeliverableFlex) | ||
ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contract Terms Deliverable (ContractTermsDeliverableFlex) | ||
ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contract Terms Deliverable (ContractTermsDeliverableFlex) | ||
ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contract Terms Deliverable (ContractTermsDeliverableFlex) | ||
ATTRIBUTE26 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contract Terms Deliverable (ContractTermsDeliverableFlex) | ||
ATTRIBUTE27 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contract Terms Deliverable (ContractTermsDeliverableFlex) | ||
ATTRIBUTE28 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contract Terms Deliverable (ContractTermsDeliverableFlex) | ||
ATTRIBUTE29 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contract Terms Deliverable (ContractTermsDeliverableFlex) | ||
ATTRIBUTE30 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contract Terms Deliverable (ContractTermsDeliverableFlex) | ||
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 | okc_business_events_b | RELATIVE_ST_DATE_EVENT_ID |
OKC_DELIVERABLES | okc_business_events_b | RELATIVE_END_DATE_EVENT_ID |
okc_del_status_history | okc_deliverables | DELIVERABLE_ID |
okc_del_status_history_h | okc_deliverables | DELIVERABLE_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
OKC_DELIVERABLES_N1 | Non Unique | Default | BUSINESS_DOCUMENT_TYPE, BUSINESS_DOCUMENT_ID, BUSINESS_DOCUMENT_VERSION, CONTRACT_TYPE_ID |
OKC_DELIVERABLES_N3 | Non Unique | Default | INTERNAL_PARTY_CONTACT_ID |
OKC_DELIVERABLES_N4 | Non Unique | Default | EXTERNAL_PARTY_CONTACT_ID |
OKC_DELIVERABLES_N5 | Non Unique | Default | ACTUAL_DUE_DATE |
OKC_DELIVERABLES_N6 | Non Unique | Default | REQUESTER_ID |
OKC_DELIVERABLES_U1 | Unique | Default | DELIVERABLE_ID |