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

VIEW: APPS.OKE_K_DELIVERABLES_VLH

Object Details
Object Name: OKE_K_DELIVERABLES_VLH
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKE.OKE_K_DELIVERABLES_VLH
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Contains history data for all deliverable attributes


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.OKE_K_DELIVERABLES_VLH references the following:

SchemaAPPS
ViewOKC_STATUSES_V
SynonymOKE_K_DELIVERABLES_BH
SynonymOKE_K_DELIVERABLES_TLH
SynonymPA_PROJECTS_ALL
SynonymPA_TASKS
APPS.OKE_K_DELIVERABLES_VLH is referenced by following:

SchemaAPPS
Package BodyOKE_VERSION_COMPARISON_PKG - show dependent code