FND Design Data [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: TableAMS.AMS_DELIVERABLES_ALL_B
Primary Key: AMS_DELIVERABLES_ALL_B_PK
  1. ColumnDELIVERABLE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
AMS_DELIVERABLES_ALL_B FK Joins to TableFND_CURRENCIES AMS_DELIVERABLES_ALL_B.CHARGEBACK_AMOUNT_CURR_CODE
AMS_DELIVERABLES_ALL_B FK Joins to TableAMS_USER_STATUSES_B AMS_DELIVERABLES_ALL_B.USER_STATUS_ID
AMS_DELIVERABLES_ALL_B FK Joins to TableFND_USER AMS_DELIVERABLES_ALL_B.DEFAULT_APPROVER_ID
AMS_DELIVERABLES_ALL_B FK Joins to TableJTF_AMV_ATTACHMENTS AMS_DELIVERABLES_ALL_B.JTF_AMV_ITEM_ID
AMS_DELIVERABLES_ALL_B FK Joins to TableAMS_DELIVERABLES_ALL_B AMS_DELIVERABLES_ALL_B.REPLACED_BY_DELIVERABLE_ID
AMS_DELIVERABLES_ALL_B FK Joins to TableFND_LANGUAGES AMS_DELIVERABLES_ALL_B.LANGUAGE_CODE
AMS_DELIVERABLES_ALL_B FK Joins to TableAMS_CATEGORIES_B AMS_DELIVERABLES_ALL_B.CATEGORY_SUB_TYPE_ID
AMS_DELIVERABLES_ALL_B FK Joins to TableAMS_CATEGORIES_B AMS_DELIVERABLES_ALL_B.CATEGORY_TYPE_ID
AMS_DELIVERABLES_ALL_B FK Joins to TableJTF_RS_RESOURCE_EXTNS AMS_DELIVERABLES_ALL_B.OWNER_USER_ID
AMS_DELIVERABLES_ALL_B FK Joins to TableFND_APPLICATION AMS_DELIVERABLES_ALL_B.APPLICATION_ID
TableAMS_ACT_ACCESS FK Joins to AMS_DELIVERABLES_ALL_B AMS_ACT_ACCESS.ACT_ACCESS_TO_OBJECT_ID
TableAMS_ACT_BUDGETS FK Joins to AMS_DELIVERABLES_ALL_B AMS_ACT_BUDGETS.ACT_BUDGET_USED_BY_ID
TableAMS_ACT_CATEGORIES FK Joins to AMS_DELIVERABLES_ALL_B AMS_ACT_CATEGORIES.ACT_CATEGORY_USED_BY_ID
TableAMS_ACT_METRICS_ALL FK Joins to AMS_DELIVERABLES_ALL_B AMS_ACT_METRICS_ALL.ACT_METRIC_USED_BY_ID
TableAMS_CAMPAIGN_SCHEDULES FK Joins to AMS_DELIVERABLES_ALL_B AMS_CAMPAIGN_SCHEDULES.DELIVERABLE_ID
TableAMS_DELIVERABLES_ALL_B FK Joins to AMS_DELIVERABLES_ALL_B AMS_DELIVERABLES_ALL_B.REPLACED_BY_DELIVERABLE_ID
TableAMS_DELIVERABLES_ALL_TL FK Joins to AMS_DELIVERABLES_ALL_B AMS_DELIVERABLES_ALL_TL.DELIVERABLE_ID
TableAMS_DELIV_KIT_ITEMS FK Joins to AMS_DELIVERABLES_ALL_B AMS_DELIV_KIT_ITEMS.DELIVERABLE_KIT_ID
TableAMS_DELIV_KIT_ITEMS FK Joins to AMS_DELIVERABLES_ALL_B AMS_DELIV_KIT_ITEMS.DELIVERABLE_KIT_PART_ID
TableAMS_DELIV_KIT_ITEMS FK Joins to AMS_DELIVERABLES_ALL_B AMS_DELIV_KIT_ITEMS.KIT_PART_INCLUDED_FROM_KIT_ID
TableAMS_DELIV_PRODUCTS FK Joins to AMS_DELIVERABLES_ALL_B AMS_DELIV_PRODUCTS.DELIVERABLE_ID
TableAMS_OBJECT_ASSOCIATIONS FK Joins to AMS_DELIVERABLES_ALL_B AMS_OBJECT_ASSOCIATIONS.USING_OBJECT_ID
TableAMS_REQUEST_HISTORY FK Joins to AMS_DELIVERABLES_ALL_B AMS_REQUEST_HISTORY.COLLATERAL_ID
TableAMS_TRIGGER_ACTIONS FK Joins to AMS_DELIVERABLES_ALL_B AMS_TRIGGER_ACTIONS.DELIVERABLE_ID
TableIGR_I_PKG_ITEM FK Joins to AMS_DELIVERABLES_ALL_B IGR_I_PKG_ITEM.PACKAGE_ITEM_ID
TableIGS_RC_I_PKG_ITEM FK Joins to AMS_DELIVERABLES_ALL_B IGS_RC_I_PKG_ITEM.PACKAGE_ITEM_ID
TableJTF_DSP_SECTIONS_B FK Joins to AMS_DELIVERABLES_ALL_B JTF_DSP_SECTIONS_B.DELIVERABLE_ID
TableOZF_ACT_BUDGETS FK Joins to AMS_DELIVERABLES_ALL_B OZF_ACT_BUDGETS.ACT_BUDGET_USED_BY_ID