[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKE_DELIVERABLE_ACTIONS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ACTION_ID |
OKE_DELIVERABLE_ACTIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | REFERENCE2 |
OKE_DELIVERABLE_ACTIONS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ACTION_NAME |
OKE_DELIVERABLE_ACTIONS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | EXPECTED_DATE |
OKE_DELIVERABLE_ACTIONS_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | REFERENCE1 |
OKE_DELIVERABLE_ACTIONS_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DELIVERABLE_ID |
OKE_DELIVERABLE_ACTIONS_N6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TASK_ID |
OKE_DELIVERABLE_ACTIONS_N7 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PA_ACTION_ID |
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 |
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;
OKE.OKE_DELIVERABLE_ACTIONS does not reference any database object
OKE.OKE_DELIVERABLE_ACTIONS is referenced by following:
|
|
|