eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: OKC.OKC_DELIVERABLES

Object Details

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

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

Columns

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.
COMPLETION_DATE	DATE
RAISE_COMPLETION_EVENT_YN	VARCHAR2	(1)
ORIG_SYSTEM_REFERENCE_CODE	VARCHAR2	(30)
ORIG_SYSTEM_REFERENCE_ID1	NUMBER
ORIG_SYSTEM_REFERENCE_ID2	NUMBER
DEL_CATEGORY_CODE	VARCHAR2	(30)
EXHIBIT_CODE	VARCHAR2	(30)
DATA_ITEM_NUMBER	VARCHAR2	(30)
PRICE_GROUP	VARCHAR2	(240)
ESTIMATED_PRICE	NUMBER
UDA_TEMPLATE_ID	NUMBER
SCHEDULE_TYPE	VARCHAR2	(30)

Query Text

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
,      COMPLETION_DATE
,      RAISE_COMPLETION_EVENT_YN
,      ORIG_SYSTEM_REFERENCE_CODE
,      ORIG_SYSTEM_REFERENCE_ID1
,      ORIG_SYSTEM_REFERENCE_ID2
,      DEL_CATEGORY_CODE
,      EXHIBIT_CODE
,      DATA_ITEM_NUMBER
,      PRICE_GROUP
,      ESTIMATED_PRICE
,      UDA_TEMPLATE_ID
,      SCHEDULE_TYPE
FROM OKC.OKC_DELIVERABLES;

Dependencies

[top of page]

OKC.OKC_DELIVERABLES does not reference any database object

OKC.OKC_DELIVERABLES is referenced by following:

OKC: OKC_DELIVERABLES#