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

TABLE: OKE.OKE_K_DELIVERABLES_B

Object Details
Object Name: OKE_K_DELIVERABLES_B
Object Type: TABLE
Owner: OKE
FND Design Data: TableOKE.OKE_K_DELIVERABLES_B
Subobject Name:
Status: VALID


A deliverable is an item or service, which must be delivered or performed within a certain time frame to fulfill contract obligations. Deliverables can be specified in the contract and are derived from either a Contract Line or a Sub line. In addition you can define new internal deliverables, which are not specified in the contract.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKE_K_DELIVERABLES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDELIVERABLE_ID
OKE_K_DELIVERABLES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnK_HEADER_ID
ColumnK_LINE_ID
ColumnDELIVERABLE_NUM
OKE_K_DELIVERABLES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnK_LINE_ID
OKE_K_DELIVERABLES_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMPS_TRANSACTION_ID
OKE_K_DELIVERABLES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBILLABLE_FLAG
OKE_K_DELIVERABLES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
OKE_K_DELIVERABLES_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTASK_ID
OKE_K_DELIVERABLES_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTART_DATE
OKE_K_DELIVERABLES_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDELIVERY_DATE
OKE_K_DELIVERABLES_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINITIATE_SHIPMENT_DATE
OKE_K_DELIVERABLES_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVENTORY_ORG_ID
OKE_K_DELIVERABLES_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnITEM_ID
Columns
Name Datatype Length Mandatory Comments
DELIVERABLE_ID NUMBER
Yes Contract 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_NUM VARCHAR2 (150) Yes Deliverable Number
PROJECT_ID NUMBER

System generated project unique identifier
TASK_ID NUMBER

System generated task unique identifier
ITEM_ID NUMBER

Inventory item unique identifier
K_HEADER_ID NUMBER
Yes Contract document unique identifier
K_LINE_ID NUMBER
Yes Contract document line item unique identifier
DELIVERY_DATE DATE

Delivery date
STATUS_CODE VARCHAR2 (30) Yes Oracle Internal use only - reserved for future use
STATUS_DATE DATE
Yes Oracle Internal use only - reserved for future use
PARENT_DELIVERABLE_ID NUMBER

Oracle Internal use only - reserved for future use
DIRECTION VARCHAR2 (3)
Direction of deliverable, either inbound or outbound
SHIP_TO_ORG_ID NUMBER

Ship to organization unique identifier
SHIP_TO_LOCATION_ID NUMBER

Ship to location unique identifier
SHIP_FROM_ORG_ID NUMBER

Ship from organization unique identifier
SHIP_FROM_LOCATION_ID NUMBER

Ship from location unique identifier
INVENTORY_ORG_ID NUMBER

Inventory organization unique identifier. Depending on direction, it is either the ship-from or ship-to location
DEFAULTED_FLAG VARCHAR2 (1)
Flag indicating whether deliverable is defaulted
IN_PROCESS_FLAG VARCHAR2 (1)
Flag indicating deliverable is currently in integration process
WF_ITEM_KEY VARCHAR2 (240)
Deliverable process workflow item key
SUB_REF_ID NUMBER

Linked subcontract deliverable unique identifier
START_DATE DATE

Start date of deliverable
END_DATE DATE

Deliverable end date
NEED_BY_DATE DATE

Need by date for the deliverable
PRIORITY_CODE VARCHAR2 (30)
Oracle Internal use only - reserved for future use
CURRENCY_CODE VARCHAR2 (15)
Currency
UNIT_PRICE NUMBER

Unit price
UOM_CODE VARCHAR2 (30)
Unit of measure
QUANTITY NUMBER

Deliverable quantity
COUNTRY_OF_ORIGIN_CODE VARCHAR2 (30)
Country of origin
SUBCONTRACTED_FLAG VARCHAR2 (1)
Subcontracted indicator
DEPENDENCY_FLAG VARCHAR2 (1)
Flag indicating dependencies exist for this deliverable
BILLABLE_FLAG VARCHAR2 (1)
Billable flag
DROP_SHIPPED_FLAG VARCHAR2 (1)
Drop shipped indicator
COMPLETED_FLAG VARCHAR2 (1)
Completed indicator
AVAILABLE_FOR_SHIP_FLAG VARCHAR2 (1)
Flag indicating deliverable eligible for shipping
CREATE_DEMAND VARCHAR2 (1)
Flag indicator whether planning demand should be created or not
READY_TO_BILL VARCHAR2 (1)
Flag indicating deliverable is ready for initiating billing action
READY_TO_PROCURE VARCHAR2 (1)
Flag indicating deliverable is ready for initiating procurement action
SHIPPABLE_FLAG VARCHAR2 (1)
Shippable indicator
CFE_REQ_FLAG VARCHAR2 (1)
Customer Furnished Equipment Required indicator
INSPECTION_REQ_FLAG VARCHAR2 (1)
Inspection required indicator
INTERIM_RPT_REQ_FLAG VARCHAR2 (1)
Interim report required indicator
LOT_APPLIES_FLAG VARCHAR2 (1)
Oracle Internal use only - reserved for future use
CUSTOMER_APPROVAL_REQ_FLAG VARCHAR2 (1)
Customer approval required indicator
EXPECTED_SHIPMENT_DATE DATE

Expected shipment date
INITIATE_SHIPMENT_DATE DATE

Date on which shipment request should be initiated
PROMISED_SHIPMENT_DATE DATE

Date on which shipment is promised
AS_OF_DATE DATE

As of date
DATE_OF_FIRST_SUBMISSION DATE

Data item first submission date
FREQUENCY VARCHAR2 (30)
Frequency
ACQ_DOC_NUMBER VARCHAR2 (30)
Oracle Internal use only - reserved for future use
SUBMISSION_FLAG VARCHAR2 (1)
Oracle Internal use only - reserved for future use
DATA_ITEM_SUBTITLE VARCHAR2 (30)
Data item subtitle
TOTAL_NUM_OF_COPIES NUMBER

Total number of copies required for data item submission
CDRL_CATEGORY VARCHAR2 (30)
Data Item Category
DATA_ITEM_NAME VARCHAR2 (30)
Data item name
EXPORT_FLAG VARCHAR2 (1)
Export indicator
EXPORT_LICENSE_NUM VARCHAR2 (30)
Export License Number
EXPORT_LICENSE_RES VARCHAR2 (30)
Party responsible for obtaining export license
SHIPPING_REQUEST_ID NUMBER

Unique identifier of shipping request initiated from this deliverable
MPS_TRANSACTION_ID NUMBER

Unique identifier of MDS entry associated with the deliverable
PO_REF_1 NUMBER

Requisition Interface batch identifier
PO_REF_2 NUMBER

Oracle Internal use only - reserved for future use
PO_REF_3 NUMBER

Oracle Internal use only - reserved for future use
UNIT_NUMBER VARCHAR2 (30)
End item model/unit number
NDB_SCHEDULE_DESIGNATOR VARCHAR2 (10)
MRP plan name
BILLING_EVENT_ID NUMBER

Obsolete - no longer used
BILL_EVENT_TYPE VARCHAR2 (30)
Obsolete - no longer used
BILL_EVENT_DATE DATE

Obsolete - no longer used
BILL_ITEM_ID NUMBER

Obsolete - no longer used
BILL_LINE_ID NUMBER

Obsolete - no longer used
BILL_CHG_REQ_ID NUMBER

Obsolete - no longer used
BILL_PROJECT_ID NUMBER

Obsolete - no longer used
BILL_TASK_ID NUMBER

Obsolete - no longer used
BILL_ORGANIZATION_ID NUMBER

Obsolete - no longer used
BILL_FUND_REF1 VARCHAR2 (80)
Obsolete - no longer used
BILL_FUND_REF2 VARCHAR2 (80)
Obsolete - no longer used
BILL_FUND_REF3 VARCHAR2 (80)
Obsolete - no longer used
BILL_BILL_OF_LADING VARCHAR2 (240)
Obsolete - no longer used
BILL_SERIAL_NUM VARCHAR2 (240)
Obsolete - no longer used
BILL_CURRENCY_CODE VARCHAR2 (30)
Obsolete - no longer used
BILL_RATE_TYPE VARCHAR2 (30)
Obsolete - no longer used
BILL_RATE_DATE DATE

Obsolete - no longer used
BILL_EXCHANGE_RATE NUMBER

Obsolete - no longer used
BILL_DESCRIPTION VARCHAR2 (240)
Obsolete - no longer used
BILL_QUANTITY NUMBER

Obsolete - no longer used
BILL_UNIT_PRICE NUMBER

Obsolete - no longer used
REVENUE_AMOUNT NUMBER

Obsolete - no longer used
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
VOLUME NUMBER

Volume
VOLUME_UOM_CODE VARCHAR2 (10)
Volume UOM code
WEIGHT NUMBER

Weight
WEIGHT_UOM_CODE VARCHAR2 (10)
Weight UOM code
EXPENDITURE_ORGANIZATION_ID NUMBER

Expenditure organization unique identifier
EXPENDITURE_TYPE VARCHAR2 (30)
Expenditure type
EXPENDITURE_ITEM_DATE DATE

Expenditure item date
DESTINATION_TYPE_CODE VARCHAR2 (30)
Destination type code for requisition creation
RATE_TYPE VARCHAR2 (30)
Foreign currency exchange rate type
RATE_DATE DATE

Foreign currency exchange rate date
EXCHANGE_RATE NUMBER

Foreign currency exchange rate, used primarily for requisition creation
REQUISITION_LINE_TYPE_ID NUMBER

Requisition line type unique identifier
PO_CATEGORY_ID NUMBER

Item category unique identifier
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_NUM
,      PROJECT_ID
,      TASK_ID
,      ITEM_ID
,      K_HEADER_ID
,      K_LINE_ID
,      DELIVERY_DATE
,      STATUS_CODE
,      STATUS_DATE
,      PARENT_DELIVERABLE_ID
,      DIRECTION
,      SHIP_TO_ORG_ID
,      SHIP_TO_LOCATION_ID
,      SHIP_FROM_ORG_ID
,      SHIP_FROM_LOCATION_ID
,      INVENTORY_ORG_ID
,      DEFAULTED_FLAG
,      IN_PROCESS_FLAG
,      WF_ITEM_KEY
,      SUB_REF_ID
,      START_DATE
,      END_DATE
,      NEED_BY_DATE
,      PRIORITY_CODE
,      CURRENCY_CODE
,      UNIT_PRICE
,      UOM_CODE
,      QUANTITY
,      COUNTRY_OF_ORIGIN_CODE
,      SUBCONTRACTED_FLAG
,      DEPENDENCY_FLAG
,      BILLABLE_FLAG
,      DROP_SHIPPED_FLAG
,      COMPLETED_FLAG
,      AVAILABLE_FOR_SHIP_FLAG
,      CREATE_DEMAND
,      READY_TO_BILL
,      READY_TO_PROCURE
,      SHIPPABLE_FLAG
,      CFE_REQ_FLAG
,      INSPECTION_REQ_FLAG
,      INTERIM_RPT_REQ_FLAG
,      LOT_APPLIES_FLAG
,      CUSTOMER_APPROVAL_REQ_FLAG
,      EXPECTED_SHIPMENT_DATE
,      INITIATE_SHIPMENT_DATE
,      PROMISED_SHIPMENT_DATE
,      AS_OF_DATE
,      DATE_OF_FIRST_SUBMISSION
,      FREQUENCY
,      ACQ_DOC_NUMBER
,      SUBMISSION_FLAG
,      DATA_ITEM_SUBTITLE
,      TOTAL_NUM_OF_COPIES
,      CDRL_CATEGORY
,      DATA_ITEM_NAME
,      EXPORT_FLAG
,      EXPORT_LICENSE_NUM
,      EXPORT_LICENSE_RES
,      SHIPPING_REQUEST_ID
,      MPS_TRANSACTION_ID
,      PO_REF_1
,      PO_REF_2
,      PO_REF_3
,      UNIT_NUMBER
,      NDB_SCHEDULE_DESIGNATOR
,      BILLING_EVENT_ID
,      BILL_EVENT_TYPE
,      BILL_EVENT_DATE
,      BILL_ITEM_ID
,      BILL_LINE_ID
,      BILL_CHG_REQ_ID
,      BILL_PROJECT_ID
,      BILL_TASK_ID
,      BILL_ORGANIZATION_ID
,      BILL_FUND_REF1
,      BILL_FUND_REF2
,      BILL_FUND_REF3
,      BILL_BILL_OF_LADING
,      BILL_SERIAL_NUM
,      BILL_CURRENCY_CODE
,      BILL_RATE_TYPE
,      BILL_RATE_DATE
,      BILL_EXCHANGE_RATE
,      BILL_DESCRIPTION
,      BILL_QUANTITY
,      BILL_UNIT_PRICE
,      REVENUE_AMOUNT
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      VOLUME
,      VOLUME_UOM_CODE
,      WEIGHT
,      WEIGHT_UOM_CODE
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ITEM_DATE
,      DESTINATION_TYPE_CODE
,      RATE_TYPE
,      RATE_DATE
,      EXCHANGE_RATE
,      REQUISITION_LINE_TYPE_ID
,      PO_CATEGORY_ID
FROM OKE.OKE_K_DELIVERABLES_B;

Dependencies

[top of page]

OKE.OKE_K_DELIVERABLES_B does not reference any database object

OKE.OKE_K_DELIVERABLES_B is referenced by following:

SchemaOKE
ViewOKE_K_DELIVERABLES_B#