[Home] [Help] [Dependency Information]
Object Name: | OKE_K_DELIVERABLES_VLH |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKE.OKE_K_DELIVERABLES_VLH |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Contains history data for all deliverable attributes
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Database generated row identifier | |
DELIVERABLE_ID | NUMBER | Yes | Contract deliverable unique identifier | |
DELIVERABLE_NUM | VARCHAR2 | (150) | Yes | Contract deliverable unique number |
PROJECT_ID | NUMBER | Project unique identifier | ||
TASK_ID | NUMBER | Task unique identifier | ||
PROJECT_NUMBER | VARCHAR2 | (25) | Project number | |
PROJECT_NAME | VARCHAR2 | (30) | Project name | |
TASK_NAME | VARCHAR2 | (20) | Task name | |
TASK_NUMBER | VARCHAR2 | (25) | Task number | |
TASK_DESCRIPTION | VARCHAR2 | (250) | Task Description | |
ITEM_ID | NUMBER | Inventory item unique identifier | ||
K_HEADER_ID | NUMBER | Yes | Contract header unique identifier | |
K_LINE_ID | NUMBER | Yes | Contract line unique identifier | |
DELIVERY_DATE | DATE | Deliverable due date | ||
STATUS_CODE | VARCHAR2 | (30) | Yes | Obsolete column |
PARENT_DELIVERABLE_ID | NUMBER | Reserved for future use | ||
DIRECTION | VARCHAR2 | (3) | Deliverable destination type relative to the authoring organization | |
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 | ||
DEFAULTED_FLAG | VARCHAR2 | (1) | Defaulted flag to indicate if deliverable is defaulted from Authoring | |
IN_PROCESS_FLAG | VARCHAR2 | (1) | Flag to indicate if the deliverable is in any integration process | |
WF_ITEM_KEY | VARCHAR2 | (240) | Workflow item unique identifier | |
SUB_REF_ID | NUMBER | Subcontract deliverable unique identifier | ||
START_DATE | DATE | Date the deliverable activity started | ||
END_DATE | DATE | Date the deliverable activity ended | ||
NEED_BY_DATE | DATE | PO need by date | ||
PRIORITY_CODE | VARCHAR2 | (30) | Reserved for future use | |
CURRENCY_CODE | VARCHAR2 | (15) | Currency code | |
UNIT_PRICE | NUMBER | Unit price | ||
UOM_CODE | VARCHAR2 | (30) | Unit of measure code | |
QUANTITY | NUMBER | Deliverable quantity | ||
COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | (30) | Country of origin code | |
SUBCONTRACTED_FLAG | VARCHAR2 | (1) | Flag to indicate if the deliverable is subcontracted | |
DEPENDENCY_FLAG | VARCHAR2 | (1) | Flag to indicate if any dependency exists for the deliverable | |
BILLABLE_FLAG | VARCHAR2 | (1) | Flag to indicate if the deliverable is billable | |
BILLING_EVENT_ID | NUMBER | Contract billing event unique identifier | ||
DROP_SHIPPED_FLAG | VARCHAR2 | (1) | Flag to indicate if the deliverable is drop shipped | |
COMPLETED_FLAG | VARCHAR2 | (1) | Flag to indicate if the deliverable is fulfilled | |
AVAILABLE_FOR_SHIP_FLAG | VARCHAR2 | (1) | Flag to indicate if the deliverable is ready to ship with all required data populated | |
CREATE_DEMAND | VARCHAR2 | (1) | Flag to indicate if the deliverable is ready to create MDS entry with all required data populated | |
READY_TO_BILL | VARCHAR2 | (1) | Flag to indicate if the deliverable is ready to bill | |
READY_TO_PROCURE | VARCHAR2 | (1) | Flag to indicate if the deliverable is ready to create Requisition with all required data populated | |
MPS_TRANSACTION_ID | NUMBER | MRP transaction unique identifier | ||
SHIPPING_REQUEST_ID | NUMBER | WSH delivery detail unique identifier | ||
PO_REF_1 | NUMBER | PO process unique identifier | ||
PO_REF_2 | NUMBER | Reserved for future use | ||
PO_REF_3 | NUMBER | Reserved for future use | ||
UNIT_NUMBER | VARCHAR2 | (30) | Unit control number | |
NDB_SCHEDULE_DESIGNATOR | VARCHAR2 | (10) | MRP plan name | |
SHIPPABLE_FLAG | VARCHAR2 | (1) | Flag to indicate if the deliverable is shippable | |
CFE_REQ_FLAG | VARCHAR2 | (1) | Flag to indicate if customer furnished equipment is required | |
INSPECTION_REQ_FLAG | VARCHAR2 | (1) | Flag to indicate if inspection is required | |
INTERIM_RPT_REQ_FLAG | VARCHAR2 | (1) | Flag to indicate if interim report is required | |
LOT_APPLIES_FLAG | VARCHAR2 | (1) | Obsolete column | |
CUSTOMER_APPROVAL_REQ_FLAG | VARCHAR2 | (1) | Flag to indicate if customer approval is required before delivery | |
EXPECTED_SHIPMENT_DATE | DATE | Expected shipment date | ||
INITIATE_SHIPMENT_DATE | DATE | Initiate shipment date | ||
PROMISED_SHIPMENT_DATE | DATE | Promised shipment date | ||
AS_OF_DATE | DATE | As of date | ||
DATE_OF_FIRST_SUBMISSION | DATE | Date of first submission for data items | ||
FREQUENCY | VARCHAR2 | (30) | Frequency for data item submission | |
ACQ_DOC_NUMBER | VARCHAR2 | (30) | Obsolete column | |
SUBMISSION_FLAG | VARCHAR2 | (1) | Obsolete column | |
DATA_ITEM_SUBTITLE | VARCHAR2 | (30) | Data item subtitle | |
TOTAL_NUM_OF_COPIES | NUMBER | Total copies required for data item submission | ||
CDRL_CATEGORY | VARCHAR2 | (30) | CDRL submission | |
DATA_ITEM_NAME | VARCHAR2 | (30) | Data item name | |
EXPORT_FLAG | VARCHAR2 | (1) | Flag to indicate if export is required for the deliverable | |
EXPORT_LICENSE_NUM | VARCHAR2 | (30) | Export license number | |
EXPORT_LICENSE_RES | VARCHAR2 | (30) | Responsible party to obtain export license | |
CREATED_BY | NUMBER | Yes | Standard who column | |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column | ||
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
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 | |
DESCRIPTION | VARCHAR2 | (240) | Description for deliverable | |
COMMENTS | VARCHAR2 | (2000) | Comments for deliverable | |
SFWT_FLAG | VARCHAR2 | (3) | Yes | Reserved for future use |
STATUS | VARCHAR2 | (90) | Yes | Obsolete column |
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 | |
RATE_TYPE | VARCHAR2 | (30) | Foreign currency exchange rate type | |
RATE_DATE | DATE | Foreign currency exchange rate date | ||
EXCHANGE_RATE | NUMBER | Foreign currency exchange rate, primarily used for requisition creation | ||
REQUISITION_LINE_TYPE_ID | NUMBER | Requisition line type ID | ||
PO_CATEGORY_ID | NUMBER | PO category ID | ||
MAJOR_VERSION | NUMBER | (4) | Yes | Major Version |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, DELIVERABLE_ID
, DELIVERABLE_NUM
, PROJECT_ID
, TASK_ID
, PROJECT_NUMBER
, PROJECT_NAME
, TASK_NAME
, TASK_NUMBER
, TASK_DESCRIPTION
, ITEM_ID
, K_HEADER_ID
, K_LINE_ID
, DELIVERY_DATE
, STATUS_CODE
, 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
, BILLING_EVENT_ID
, DROP_SHIPPED_FLAG
, COMPLETED_FLAG
, AVAILABLE_FOR_SHIP_FLAG
, CREATE_DEMAND
, READY_TO_BILL
, READY_TO_PROCURE
, MPS_TRANSACTION_ID
, SHIPPING_REQUEST_ID
, PO_REF_1
, PO_REF_2
, PO_REF_3
, UNIT_NUMBER
, NDB_SCHEDULE_DESIGNATOR
, 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
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, DESCRIPTION
, COMMENTS
, SFWT_FLAG
, STATUS
, 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
, MAJOR_VERSION
FROM APPS.OKE_K_DELIVERABLES_VLH;
|
|
|