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_P_EVENT_DELIVERABLES_V

Object Details

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

View Type

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

This is a public view to expose association of deliverables to Events.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Unique identifier generated by database
EVENT_OFFER_ID	NUMBER		Yes	Unique identifier
EVENT_OFFER_NAME	VARCHAR2	(240)	Yes	Name of event offer associated with this deliverable.
EVENT_OFFER_DESCRIPTION	VARCHAR2	(4000)		Description of the event being offered.
DELIVERABLE_ID	NUMBER		Yes	Unique deliverable identifier
DELIVERABLE_NAME	VARCHAR2	(240)	Yes	Name of the deliverable associated with this event
DELIVERABLE_DESCRIPTION	VARCHAR2	(4000)		Description of the deliverable.
DELIVERABLE_LANGUAGE_CODE	VARCHAR2	(4)	Yes	Language code of the event deliverable.
CAN_FULFILL_ELECTRONIC_FLAG	VARCHAR2	(1)		Flag to indicate if event delivery can be done electronically.
CAN_FULFILL_PHYSICAL_FLAG	VARCHAR2	(1)		Flag to indicate if event delivery can be done physically.
DELIVERABLE_CATEGORY	VARCHAR2	(120)	Yes	Unique code to indicate deliverable category.
DELIVERABLE_SUB_CATEGORY	VARCHAR2	(120)	Yes	Unique code to indicate deliverable sub category
INVENTORY_FLAG	VARCHAR2	(1)		Flag to indicate inventory required.
DELV_INVENTORY_ITEM_ID	NUMBER	(38)		Unique identifier for deliverable inventory item id.
DELV_INVENTORY_ITEM_ORG_ID	NUMBER	(32)		Unique identifier to indicate what operating unit this inventory item belongs.
KIT_FLAG	VARCHAR2	(1)		Flag to indicate if this event comes with a kit.

Query Text

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


SELECT ROW_ID
,      EVENT_OFFER_ID
,      EVENT_OFFER_NAME
,      EVENT_OFFER_DESCRIPTION
,      DELIVERABLE_ID
,      DELIVERABLE_NAME
,      DELIVERABLE_DESCRIPTION
,      DELIVERABLE_LANGUAGE_CODE
,      CAN_FULFILL_ELECTRONIC_FLAG
,      CAN_FULFILL_PHYSICAL_FLAG
,      DELIVERABLE_CATEGORY
,      DELIVERABLE_SUB_CATEGORY
,      INVENTORY_FLAG
,      DELV_INVENTORY_ITEM_ID
,      DELV_INVENTORY_ITEM_ORG_ID
,      KIT_FLAG
FROM APPS.AMS_P_EVENT_DELIVERABLES_V;

Dependencies

[top of page]

APPS.AMS_P_EVENT_DELIVERABLES_V references the following:

APPS: AMS_EVENT_OFFERS_VL; AMS_OBJECT_ASSOCIATIONS; AMS_P_DELIVERABLES_V

APPS.AMS_P_EVENT_DELIVERABLES_V is not referenced by any database object