[Home] [Help] [Dependency Information]
Object Name: | OKC_DELIVERABLES |
---|---|
Object Type: | TABLE |
Owner: | OKC |
FND Design Data: | OKC.OKC_DELIVERABLES |
Subobject Name: | |
Status: | VALID |
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKC_DELIVERABLES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | DELIVERABLE_ID |
OKC_DELIVERABLES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
BUSINESS_DOCUMENT_TYPE
BUSINESS_DOCUMENT_ID BUSINESS_DOCUMENT_VERSION |
OKC_DELIVERABLES_N2 | FUNCTION-BASED NORMAL | NONUNIQUE | APPS_TS_TX_IDX | UPPER("DELIVERABLE_NAME") |
OKC_DELIVERABLES_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | INTERNAL_PARTY_CONTACT_ID |
OKC_DELIVERABLES_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | EXTERNAL_PARTY_CONTACT_ID |
OKC_DELIVERABLES_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ACTUAL_DUE_DATE |
OKC_DELIVERABLES_N6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | REQUESTER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DELIVERABLE_ID | NUMBER | Yes | Unique Identifier for a Deliverable. This is also the Primary key for the table. | |
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. | ||
PRINT_DUE_DATE_MSG_NAME | VARCHAR2 | (30) | Message Code that would translate into the textual description of the Due date on a Deliverable. Refer to message_name in OKC_DEL_MESSAGES table. | |
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. | ||
LANGUAGE | VARCHAR2 | (12) | Yes | Standard MLS Column. |
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 | NUMBER | (15) | Yes | Standard Who column. |
CREATION_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column. |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed. |
ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Descriptive flexfield category column. | |
ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flexfield column. | |
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. | |
PAY_HOLD_PRIOR_DUE_DATE_YN | VARCHAR2 | (1) | Flag to indicate whether a payment hold can be initiated prior to the due date of a deliverable. | |
PAY_HOLD_PRIOR_DUE_DATE_VALUE | NUMBER | Indicates the number of periods prior to the due date to initiate payment holds. | ||
PAY_HOLD_PRIOR_DUE_DATE_UOM | VARCHAR2 | (30) | Indicates the period type (Days, Weeks or Months) prior to the due date by which the payment hold can be initiated. Refers to LOOKUP_CODE in FND_LOOKUPS where LOOKUP_TYPE = `OKC_DELIVERABLE_TIME_UNITS`. | |
PAY_HOLD_OVERDUE_YN | VARCHAR2 | (1) | Flag to indicate whether a payment hold can be initiated if the Deliverable is overdue. |
Cut, paste (and edit) the following text to query this object:
SELECT DELIVERABLE_ID
, BUSINESS_DOCUMENT_TYPE
, BUSINESS_DOCUMENT_ID
, BUSINESS_DOCUMENT_NUMBER
, DELIVERABLE_TYPE
, RESPONSIBLE_PARTY
, INTERNAL_PARTY_CONTACT_ID
, EXTERNAL_PARTY_CONTACT_ID
, DELIVERABLE_NAME
, DESCRIPTION
, COMMENTS
, DISPLAY_SEQUENCE
, FIXED_DUE_DATE_YN
, ACTUAL_DUE_DATE
, PRINT_DUE_DATE_MSG_NAME
, RECURRING_YN
, NOTIFY_PRIOR_DUE_DATE_VALUE
, NOTIFY_PRIOR_DUE_DATE_UOM
, NOTIFY_PRIOR_DUE_DATE_YN
, NOTIFY_COMPLETED_YN
, NOTIFY_OVERDUE_YN
, NOTIFY_ESCALATION_YN
, NOTIFY_ESCALATION_VALUE
, NOTIFY_ESCALATION_UOM
, ESCALATION_ASSIGNEE
, AMENDMENT_OPERATION
, PRIOR_NOTIFICATION_ID
, AMENDMENT_NOTES
, COMPLETED_NOTIFICATION_ID
, OVERDUE_NOTIFICATION_ID
, ESCALATION_NOTIFICATION_ID
, LANGUAGE
, ORIGINAL_DELIVERABLE_ID
, REQUESTER_ID
, EXTERNAL_PARTY_ID
, RECURRING_DEL_PARENT_ID
, BUSINESS_DOCUMENT_VERSION
, RELATIVE_ST_DATE_DURATION
, RELATIVE_ST_DATE_UOM
, RELATIVE_ST_DATE_EVENT_ID
, RELATIVE_END_DATE_DURATION
, RELATIVE_END_DATE_UOM
, RELATIVE_END_DATE_EVENT_ID
, REPEATING_DAY_OF_MONTH
, REPEATING_DAY_OF_WEEK
, REPEATING_FREQUENCY_UOM
, REPEATING_DURATION
, FIXED_START_DATE
, FIXED_END_DATE
, MANAGE_YN
, INTERNAL_PARTY_ID
, DELIVERABLE_STATUS
, STATUS_CHANGE_NOTES
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, DISABLE_NOTIFICATIONS_YN
, LAST_AMENDMENT_DATE
, BUSINESS_DOCUMENT_LINE_ID
, EXTERNAL_PARTY_SITE_ID
, START_EVENT_DATE
, END_EVENT_DATE
, SUMMARY_AMEND_OPERATION_CODE
, EXTERNAL_PARTY_ROLE
, PAY_HOLD_PRIOR_DUE_DATE_YN
, PAY_HOLD_PRIOR_DUE_DATE_VALUE
, PAY_HOLD_PRIOR_DUE_DATE_UOM
, PAY_HOLD_OVERDUE_YN
FROM OKC.OKC_DELIVERABLES;
OKC.OKC_DELIVERABLES does not reference any database object
OKC.OKC_DELIVERABLES is referenced by following:
|
|
|