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.

[Home] [Help]

View: AMS_P_EVENT_DELIVERABLES_V

Product:	AMS - Marketing
Description:	This public view returns all marketing deliverables, including collaterals associated marketing events.
Implementation/DBA Data:	APPS.AMS_P_EVENT_DELIVERABLES_V

View Text

SELECT A.ROWID ROW_ID
, A.MASTER_OBJECT_ID
, E.EVENT_OFFER_NAME
, E.DESCRIPTION
, A.USING_OBJECT_ID
, D.DELIVERABLE_NAME
, D.DESCRIPTION
, D.LANGUAGE_CODE
, D.CAN_FULFILL_ELECTRONIC_FLAG
, D.CAN_FULFILL_PHYSICAL_FLAG
, D.DELIVERABLE_CATEGORY
, D.DELIVERABLE_SUB_CATEGORY
, D.INVENTORY_FLAG
, D.INVENTORY_ITEM_ID
, D.INVENTORY_ITEM_ORG_ID
, D.KIT_FLAG
FROM AMS_OBJECT_ASSOCIATIONS A
, AMS_EVENT_OFFERS_VL E
, AMS_P_DELIVERABLES_V D
WHERE A.MASTER_OBJECT_ID=E.EVENT_OFFER_ID
AND A.USING_OBJECT_ID=D.DELIVERABLE_ID

Columns

Name
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