eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.OKE_DELIVERABLE_ACTIONS_V

Object Details

Object Name:	OKE_DELIVERABLE_ACTIONS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

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

This view gives deliverable action information for each contract.
Contains data for all deliverable actions

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Database generated row identifier
ACTION_ID	NUMBER		Yes	Contract deliverable unique identifier
ACTION_TYPE	VARCHAR2	(30)	Yes	Contract deliverable unique number
ACTION_NAME	VARCHAR2	(240)		Project unique identifier
DELIVERABLE_ID	NUMBER		Yes	Task unique identifier
PA_ACTION_ID	NUMBER			Project name
TASK_ID	NUMBER			Reserved for future use
TASK_NAME	VARCHAR2	(20)		Task name
TASK_NUMBER	VARCHAR2	(25)		Task number
TASK_DESCRIPTION	VARCHAR2	(250)		Task Description
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 to indicate if the deliverable is in any integration process
READY_FLAG	VARCHAR2	(1)		Flag to indicate if the deliverable is ready to bill
REFERENCE1	NUMBER			PO process unique identifier
REFERENCE2	NUMBER			Reserved for future use
REFERENCE3	NUMBER			Reserved for future use
SCHEDULE_DESIGNATOR	VARCHAR2	(10)		MRP plan name
INSPECTION_REQ_FLAG	VARCHAR2	(1)		Flag to indicate if inspection is required
EXPECTED_DATE	DATE			Expected shipment date
INITIATE_DATE	DATE			Initiate shipment date
PROMISED_DATE	DATE			Promised shipment date
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
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
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 ROW_ID
,      ACTION_ID
,      ACTION_TYPE
,      ACTION_NAME
,      DELIVERABLE_ID
,      PA_ACTION_ID
,      TASK_ID
,      TASK_NAME
,      TASK_NUMBER
,      TASK_DESCRIPTION
,      SHIP_TO_ORG_ID
,      SHIP_TO_LOCATION_ID
,      SHIP_FROM_ORG_ID
,      SHIP_FROM_LOCATION_ID
,      IN_PROCESS_FLAG
,      READY_FLAG
,      REFERENCE1
,      REFERENCE2
,      REFERENCE3
,      SCHEDULE_DESIGNATOR
,      INSPECTION_REQ_FLAG
,      EXPECTED_DATE
,      INITIATE_DATE
,      PROMISED_DATE
,      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
,      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
,      UNIT_PRICE
,      CURRENCY_CODE
,      QUANTITY
,      UOM_CODE
FROM APPS.OKE_DELIVERABLE_ACTIONS_V;

Dependencies

[top of page]

APPS.OKE_DELIVERABLE_ACTIONS_V references the following:

APPS: OKE_DELIVERABLE_ACTIONS; PA_TASKS

APPS.OKE_DELIVERABLE_ACTIONS_V is referenced by following:

APPS: PA_ACTIONS_PUB - show dependent code