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]

Table: AMS_DELIVERABLES_ALL_B

Product:	AMS - Marketing
Description:	This table stores the details about marketing deliverables/collaterals, collaterals are uniquely identified by deliverable name, language and version.
Implementation/DBA Data:	AMS.AMS_DELIVERABLES_ALL_B

Primary Key: AMS_DELIVERABLES_ALL_B_PK

DELIVERABLE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
AMS_DELIVERABLES_ALL_B	FND_CURRENCIES	AMS_DELIVERABLES_ALL_B.CHARGEBACK_AMOUNT_CURR_CODE
AMS_DELIVERABLES_ALL_B	AMS_USER_STATUSES_B	AMS_DELIVERABLES_ALL_B.USER_STATUS_ID
AMS_DELIVERABLES_ALL_B	FND_USER	AMS_DELIVERABLES_ALL_B.DEFAULT_APPROVER_ID
AMS_DELIVERABLES_ALL_B	JTF_AMV_ATTACHMENTS	AMS_DELIVERABLES_ALL_B.JTF_AMV_ITEM_ID
AMS_DELIVERABLES_ALL_B	AMS_DELIVERABLES_ALL_B	AMS_DELIVERABLES_ALL_B.REPLACED_BY_DELIVERABLE_ID
AMS_DELIVERABLES_ALL_B	FND_LANGUAGES	AMS_DELIVERABLES_ALL_B.LANGUAGE_CODE
AMS_DELIVERABLES_ALL_B	AMS_CATEGORIES_B	AMS_DELIVERABLES_ALL_B.CATEGORY_SUB_TYPE_ID
AMS_DELIVERABLES_ALL_B	AMS_CATEGORIES_B	AMS_DELIVERABLES_ALL_B.CATEGORY_TYPE_ID
AMS_DELIVERABLES_ALL_B	JTF_RS_RESOURCE_EXTNS	AMS_DELIVERABLES_ALL_B.OWNER_USER_ID
AMS_DELIVERABLES_ALL_B	FND_APPLICATION	AMS_DELIVERABLES_ALL_B.APPLICATION_ID
AMS_ACT_ACCESS	AMS_DELIVERABLES_ALL_B	AMS_ACT_ACCESS.ACT_ACCESS_TO_OBJECT_ID
AMS_ACT_BUDGETS	AMS_DELIVERABLES_ALL_B	AMS_ACT_BUDGETS.ACT_BUDGET_USED_BY_ID
AMS_ACT_CATEGORIES	AMS_DELIVERABLES_ALL_B	AMS_ACT_CATEGORIES.ACT_CATEGORY_USED_BY_ID
AMS_ACT_METRICS_ALL	AMS_DELIVERABLES_ALL_B	AMS_ACT_METRICS_ALL.ACT_METRIC_USED_BY_ID
AMS_CAMPAIGN_SCHEDULES	AMS_DELIVERABLES_ALL_B	AMS_CAMPAIGN_SCHEDULES.DELIVERABLE_ID
AMS_DELIVERABLES_ALL_B	AMS_DELIVERABLES_ALL_B	AMS_DELIVERABLES_ALL_B.REPLACED_BY_DELIVERABLE_ID
AMS_DELIVERABLES_ALL_TL	AMS_DELIVERABLES_ALL_B	AMS_DELIVERABLES_ALL_TL.DELIVERABLE_ID
AMS_DELIV_KIT_ITEMS	AMS_DELIVERABLES_ALL_B	AMS_DELIV_KIT_ITEMS.DELIVERABLE_KIT_ID
AMS_DELIV_KIT_ITEMS	AMS_DELIVERABLES_ALL_B	AMS_DELIV_KIT_ITEMS.DELIVERABLE_KIT_PART_ID
AMS_DELIV_KIT_ITEMS	AMS_DELIVERABLES_ALL_B	AMS_DELIV_KIT_ITEMS.KIT_PART_INCLUDED_FROM_KIT_ID
AMS_DELIV_PRODUCTS	AMS_DELIVERABLES_ALL_B	AMS_DELIV_PRODUCTS.DELIVERABLE_ID
AMS_OBJECT_ASSOCIATIONS	AMS_DELIVERABLES_ALL_B	AMS_OBJECT_ASSOCIATIONS.USING_OBJECT_ID
AMS_REQUEST_HISTORY	AMS_DELIVERABLES_ALL_B	AMS_REQUEST_HISTORY.COLLATERAL_ID
AMS_TRIGGER_ACTIONS	AMS_DELIVERABLES_ALL_B	AMS_TRIGGER_ACTIONS.DELIVERABLE_ID
IGR_I_PKG_ITEM	AMS_DELIVERABLES_ALL_B	IGR_I_PKG_ITEM.PACKAGE_ITEM_ID
IGS_RC_I_PKG_ITEM	AMS_DELIVERABLES_ALL_B	IGS_RC_I_PKG_ITEM.PACKAGE_ITEM_ID
JTF_DSP_SECTIONS_B	AMS_DELIVERABLES_ALL_B	JTF_DSP_SECTIONS_B.DELIVERABLE_ID
OZF_ACT_BUDGETS	AMS_DELIVERABLES_ALL_B	OZF_ACT_BUDGETS.ACT_BUDGET_USED_BY_ID