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.AMS_ACT_DELIVERABLES_V

Object Details

Object Name:	AMS_ACT_DELIVERABLES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_ACT_DELIVERABLES_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_ASSOCIATION_ID	NUMBER		Yes	Unique identifier
USAGE_TYPE	VARCHAR2	(30)	Yes	Unique deliverable type across systems to identify the activity deliverable
USAGE_TYPE_MEANING	VARCHAR2	(80)		Description of the usage type for this activity deliverable
MASTER_OBJECT_ID	NUMBER		Yes	Unique identifier of master deliverable objects
MASTER_OBJECT_TYPE	VARCHAR2	(30)	Yes	Unique master object type across systems
MASTER_OBJECT_TYPE_MEANING	VARCHAR2	(80)		Description of the master object type
DELIVERABLE_ID	NUMBER		Yes	Unique deliverable identifier
USING_OBJECT_TYPE	VARCHAR2	(30)	Yes	Type of the object using this deliverable
USING_OBJECT_TYPE_MEANING	VARCHAR2	(80)		Description of the object type using this deliverable
DELIVERABLE_NAME	VARCHAR2	(240)	Yes	Name of this deliverable
DLV_CATEGORY_TYPE_ID	NUMBER			Unique category identifier for this deliverable
DLV_CATEGORY	VARCHAR2	(120)	Yes	Name of the category associated with this deliverable
DLV_CATEGORY_SUB_TYPE_ID	NUMBER			Unique deliverable category subtype identifier
DLV_SUB_CATEGORY	VARCHAR2	(120)	Yes	Name of the sub category
QUANTITY_NEEDED	NUMBER	(15)		Number of deliverables required
QUANTITY_NEEDED_BY_DATE	DATE			Date by which these number of deliverables are required.
FULFILL_ON_TYPE_CODE	VARCHAR2	(30)		Indicates unique deliverable fulfill type code used across systems
FULFILL_ON_TYPE	VARCHAR2	(80)		Type of the fulfill code for this deliverable
PRIMARY_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if this deliverable is primary
OBJECT_VERSION_NUMBER	NUMBER	(9)		This column is used for locking purposes

Query Text

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


SELECT OBJECT_ASSOCIATION_ID
,      USAGE_TYPE
,      USAGE_TYPE_MEANING
,      MASTER_OBJECT_ID
,      MASTER_OBJECT_TYPE
,      MASTER_OBJECT_TYPE_MEANING
,      DELIVERABLE_ID
,      USING_OBJECT_TYPE
,      USING_OBJECT_TYPE_MEANING
,      DELIVERABLE_NAME
,      DLV_CATEGORY_TYPE_ID
,      DLV_CATEGORY
,      DLV_CATEGORY_SUB_TYPE_ID
,      DLV_SUB_CATEGORY
,      QUANTITY_NEEDED
,      QUANTITY_NEEDED_BY_DATE
,      FULFILL_ON_TYPE_CODE
,      FULFILL_ON_TYPE
,      PRIMARY_FLAG
,      OBJECT_VERSION_NUMBER
FROM APPS.AMS_ACT_DELIVERABLES_V;

Dependencies

[top of page]

APPS.AMS_ACT_DELIVERABLES_V references the following:

APPS: AMS_LOOKUPS; AMS_OBJECT_ASSOCIATIONS; AMS_P_DELIVERABLES_V

APPS.AMS_ACT_DELIVERABLES_V is not referenced by any database object