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

TABLE: OKE.OKE_DELIVERABLE_ACTIONS

Object Details
Object Name: OKE_DELIVERABLE_ACTIONS
Object Type: TABLE
Owner: OKE
Subobject Name:
Status: VALID


This table stores deliverable action information for each contract.
Deliverable action is the process or procedure needed to run through in order to fulfill the obligation come with the deliverable


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKE_DELIVERABLE_ACTIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnACTION_ID
OKE_DELIVERABLE_ACTIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREFERENCE2
OKE_DELIVERABLE_ACTIONS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnACTION_NAME
OKE_DELIVERABLE_ACTIONS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEXPECTED_DATE
OKE_DELIVERABLE_ACTIONS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREFERENCE1
OKE_DELIVERABLE_ACTIONS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDELIVERABLE_ID
OKE_DELIVERABLE_ACTIONS_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTASK_ID
OKE_DELIVERABLE_ACTIONS_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPA_ACTION_ID
Columns
Name Datatype Length Mandatory Comments
ACTION_ID NUMBER
Yes Deliverable action 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
ACTION_TYPE VARCHAR2 (30) Yes Action type
ACTION_NAME VARCHAR2 (240)
Action name
PA_ACTION_ID NUMBER

PA action id
TASK_ID NUMBER

System generated task unique identifier
DELIVERABLE_ID NUMBER
Yes Deliverable unique identifier
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
IN_PROCESS_FLAG VARCHAR2 (1)
Flag indicating deliverable is currently in integration process
READY_FLAG VARCHAR2 (1)
Flag indicating action is ready to be executed
INSPECTION_REQ_FLAG VARCHAR2 (1)
Inspection required indicator
EXPECTED_DATE DATE

Expected action date
INITIATE_DATE DATE

Date on which action will be executed
PROMISED_DATE DATE

Date on which action is promised
REFERENCE1 NUMBER

Reference column to store foreign key references for actions
REFERENCE2 NUMBER

Reference column to store foreign key references for actions
REFERENCE3 NUMBER

Reference column to store foreign key references for actions
SCHEDULE_DESIGNATOR VARCHAR2 (10)
MRP plan name
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 ID
PO_CATEGORY_ID NUMBER

PO category ID
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
UNIT_PRICE NUMBER

Unit Price
CURRENCY_CODE VARCHAR2 (15)
Currency Code
QUANTITY NUMBER

Quantity
UOM_CODE VARCHAR2 (30)
UOM Code
Query Text

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


SELECT ACTION_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ACTION_TYPE
,      ACTION_NAME
,      PA_ACTION_ID
,      TASK_ID
,      DELIVERABLE_ID
,      SHIP_TO_ORG_ID
,      SHIP_TO_LOCATION_ID
,      SHIP_FROM_ORG_ID
,      SHIP_FROM_LOCATION_ID
,      IN_PROCESS_FLAG
,      READY_FLAG
,      INSPECTION_REQ_FLAG
,      EXPECTED_DATE
,      INITIATE_DATE
,      PROMISED_DATE
,      REFERENCE1
,      REFERENCE2
,      REFERENCE3
,      SCHEDULE_DESIGNATOR
,      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
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      UNIT_PRICE
,      CURRENCY_CODE
,      QUANTITY
,      UOM_CODE
FROM OKE.OKE_DELIVERABLE_ACTIONS;

Dependencies

[top of page]

OKE.OKE_DELIVERABLE_ACTIONS does not reference any database object

OKE.OKE_DELIVERABLE_ACTIONS is referenced by following:

SchemaOKE
ViewOKE_DELIVERABLE_ACTIONS#