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: OKE.OKE_DELIVERABLES_B

Object Details

Object Name:	OKE_DELIVERABLES_B
Object Type:	TABLE
Owner:	OKE
Subobject Name:
Status:	VALID

This tables stores deliverable information for project contract.
A deliverable is an item or service, which must be delivered or performed within a certain time frame to fulfill certain obligations. Deliverables can be specified in the source documents and are derived from either a source Line or a Subline. In addition you can define new internal deliverables, which are not specified in the source document.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKE_DELIVERABLES_N3	NORMAL	UNIQUE	APPS_TS_TX_IDX	SOURCE_LINE_ID
OKE_DELIVERABLES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DELIVERABLE_NUMBER SOURCE_HEADER_ID SOURCE_CODE
OKE_DELIVERABLES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_HEADER_ID
OKE_DELIVERABLES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ITEM_ID
OKE_DELIVERABLES_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DELIVERY_DATE
OKE_DELIVERABLES_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID
OKE_DELIVERABLES_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_DELIVERABLE_ID
OKE_DELIVERABLES_U2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DELIVERABLE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DELIVERABLE_ID	NUMBER		Yes	Deliverable unique identifier
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
DELIVERABLE_NUMBER	VARCHAR2	(150)	Yes	Deliverable Number
SOURCE_CODE	VARCHAR2	(30)	Yes	Source Document Code
SOURCE_HEADER_ID	NUMBER		Yes	Source document unique identifier
SOURCE_LINE_ID	NUMBER			Source document line item unique identifier
SOURCE_DELIVERABLE_ID	NUMBER			Deliverable id from source document
PROJECT_ID	NUMBER			System generated project unique identifier
DELIVERY_DATE	DATE			Delivery date
ITEM_ID	NUMBER			Inventory item unique identifier
CURRENCY_CODE	VARCHAR2	(15)		Currency
INVENTORY_ORG_ID	NUMBER			Inventory organization unique identifier. Depending on direction, it is either the ship-from or ship-to location
UNIT_PRICE	NUMBER			Unit price
UOM_CODE	VARCHAR2	(30)		Unit of measure
QUANTITY	NUMBER			Deliverable quantity
UNIT_NUMBER	VARCHAR2	(30)		End item model/unit number
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield attribute context
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield attribute
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield attribute
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield attribute
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield attribute
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield attribute
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield attribute
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield attribute
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield attribute
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield attribute
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield attribute
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield attribute
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield attribute
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield attribute
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield attribute
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield attribute

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DELIVERABLE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      DELIVERABLE_NUMBER
,      SOURCE_CODE
,      SOURCE_HEADER_ID
,      SOURCE_LINE_ID
,      SOURCE_DELIVERABLE_ID
,      PROJECT_ID
,      DELIVERY_DATE
,      ITEM_ID
,      CURRENCY_CODE
,      INVENTORY_ORG_ID
,      UNIT_PRICE
,      UOM_CODE
,      QUANTITY
,      UNIT_NUMBER
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM OKE.OKE_DELIVERABLES_B;

Dependencies

[top of page]

OKE.OKE_DELIVERABLES_B does not reference any database object

OKE.OKE_DELIVERABLES_B is referenced by following:

OKE: OKE_DELIVERABLES_B#