[Home] [Help] [Dependency Information]
Object Name: | AMS_ACT_DELIVERABLES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_ACT_DELIVERABLES_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
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;
APPS.AMS_ACT_DELIVERABLES_V is not referenced by any database object
|
|
|