Search Results ams_deliverables_all_b

Overview

The AMS_DELIVERABLES_ALL_B table is a core data object within the Oracle E-Business Suite (EBS) Marketing (AMS) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master transactional table for storing detailed information about marketing deliverables and collateral. A deliverable is a tangible or digital asset used in marketing campaigns, such as brochures, whitepapers, or promotional items. The table's design enforces that each collateral record is uniquely identified by a combination of its name, language, and version. This structure supports the management of multi-language and versioned collateral libraries, which is critical for global marketing operations. The table's role is central to the campaign execution process, as deliverables are linked to campaign schedules and activities.

Key Information Stored

The table's primary key is the DELIVERABLE_ID, a unique system-generated identifier. Based on the documented foreign key relationships, other critical columns include DELIVERABLE_NAME, LANGUAGE_CODE, and VERSION_NUMBER, which together form the business key. Key descriptive and control attributes are stored in columns such as USER_STATUS_ID (for workflow status), OWNER_USER_ID (resource owner), and DEFAULT_APPROVER_ID. The table also holds categorization data via CATEGORY_TYPE_ID and CATEGORY_SUB_TYPE_ID links to the AMS_CATEGORIES_B table. Financial and attachment metadata is managed through columns like CHARGEBACK_AMOUNT_CURR_CODE and JTF_AMV_ITEM_ID. The REPLACED_BY_DELIVERABLE_ID column supports versioning by pointing to a newer version of the same deliverable.

Common Use Cases and Queries

A primary use case is querying active deliverables for a specific campaign or language to generate collateral kits or fulfillment lists. Administrators often run reports to audit deliverable status, ownership, and version history. Common SQL patterns include joining to the translated table (AMS_DELIVERABLES_ALL_TL) for user-facing descriptions and to campaign schedules for execution tracking. For example, to find all approved English deliverables for a campaign category, a query might filter on USER_STATUS_ID (mapped to an 'Approved' status code), LANGUAGE_CODE = 'US', and join through AMS_ACT_CATEGORIES. The user's search for "igr_i_pkg_item" suggests an interest in item or package integration, which may involve querying this table to interface deliverable metadata with other inventory or item management systems.

Related Objects

The table has extensive relationships within the AMS schema and with EBS foundation tables, as documented by its foreign keys. Key related objects include:

AMS_DELIVERABLES_ALL_TL: The translated table joined on DELIVERABLE_ID for language-specific descriptions.
AMS_CAMPAIGN_SCHEDULES: Links deliverables to specific campaign execution timelines via DELIVERABLE_ID.
AMS_ACT_METRICS_ALL, AMS_ACT_BUDGETS, AMS_ACT_CATEGORIES: These activity-related tables reference DELIVERABLE_ID as the ACT_METRIC_USED_BY_ID, ACT_BUDGET_USED_BY_ID, and ACT_CATEGORY_USED_BY_ID, respectively, for tracking metrics, budgets, and categorization against deliverables.
AMS_DELIV_KIT_ITEMS: References this table twice, for both DELIVERABLE_KIT_ID (the kit) and DELIVERABLE_KIT_PART_ID (components within the kit).
Foundation Tables: Includes FND_LANGUAGES (LANGUAGE_CODE), FND_CURRENCIES (CHARGEBACK_AMOUNT_CURR_CODE), FND_USER (DEFAULT_APPROVER_ID), and JTF_RS_RESOURCE_EXTNS (OWNER_USER_ID).

Table: AMS_DELIVERABLES_ALL_B 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_DELIVERABLES_ALL_B, object_name:AMS_DELIVERABLES_ALL_B, status:VALID, 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 ,
Table: AMS_DELIVERABLES_ALL_B 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_DELIVERABLES_ALL_B, object_name:AMS_DELIVERABLES_ALL_B, status:VALID, 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 ,
Table: AMS_DELIV_KIT_ITEMS 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_DELIV_KIT_ITEMS, object_name:AMS_DELIV_KIT_ITEMS, status:VALID, product: AMS - Marketing , description: This table stores the details about marketing deliverable kits, the information captured include the collaterals included in the kit. , implementation_dba_data: AMS.AMS_DELIV_KIT_ITEMS ,
Table: AMS_DELIV_KIT_ITEMS 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_DELIV_KIT_ITEMS, object_name:AMS_DELIV_KIT_ITEMS, status:VALID, product: AMS - Marketing , description: This table stores the details about marketing deliverable kits, the information captured include the collaterals included in the kit. , implementation_dba_data: AMS.AMS_DELIV_KIT_ITEMS ,
Table: AMS_CATEGORIES_B 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_CATEGORIES_B, object_name:AMS_CATEGORIES_B, status:VALID, product: AMS - Marketing , description: This table stores the definition for categories and is used by Events, Metrics and the Deliverables area. , implementation_dba_data: AMS.AMS_CATEGORIES_B ,
Table: AMS_CATEGORIES_B 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_CATEGORIES_B, object_name:AMS_CATEGORIES_B, status:VALID, product: AMS - Marketing , description: This table stores the definition for categories and is used by Events, Metrics and the Deliverables area. , implementation_dba_data: AMS.AMS_CATEGORIES_B ,
Table: AMS_DELIVERABLES_ALL_TL 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_DELIVERABLES_ALL_TL, object_name:AMS_DELIVERABLES_ALL_TL, status:VALID, product: AMS - Marketing , description: This table stores all translated columns for marketing deliverable definition. , implementation_dba_data: AMS.AMS_DELIVERABLES_ALL_TL ,
Table: AMS_DELIV_PRODUCTS 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_DELIV_PRODUCTS, object_name:AMS_DELIV_PRODUCTS, status:VALID, product: AMS - Marketing , description: This table stores information about the products related to a existing deliverable(collateral). , implementation_dba_data: AMS.AMS_DELIV_PRODUCTS ,
Table: AMS_ACT_BUDGETS 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_ACT_BUDGETS, object_name:AMS_ACT_BUDGETS, status:VALID, product: AMS - Marketing , description: Holds the information about budget sources for a marketing activity. , implementation_dba_data: AMS.AMS_ACT_BUDGETS ,
Table: AMS_REQUEST_HISTORY 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_REQUEST_HISTORY, object_name:AMS_REQUEST_HISTORY, status:VALID, product: AMS - Marketing , description: This table captures the cover letter associated with the physical collateral requests placed from telesales. It also captures the order_id and collateral_id. , implementation_dba_data: AMS.AMS_REQUEST_HISTORY ,
Table: AMS_DELIVERABLES_ALL_TL 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_DELIVERABLES_ALL_TL, object_name:AMS_DELIVERABLES_ALL_TL, status:VALID, product: AMS - Marketing , description: This table stores all translated columns for marketing deliverable definition. , implementation_dba_data: AMS.AMS_DELIVERABLES_ALL_TL ,
Table: AMS_ACT_BUDGETS 12.2.2
product: AMS - Marketing , description: Holds the information about budget sources for a marketing activity. , implementation_dba_data: Not implemented in this database ,
Table: AMS_CAMPAIGN_SCHEDULES 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_CAMPAIGN_SCHEDULES, object_name:AMS_CAMPAIGN_SCHEDULES, status:VALID, product: AMS - Marketing , description: This table is obsoleted and no longer in use. , implementation_dba_data: AMS.AMS_CAMPAIGN_SCHEDULES ,
Table: AMS_ACT_ACCESS 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_ACT_ACCESS, object_name:AMS_ACT_ACCESS, status:VALID, product: AMS - Marketing , description: Holds access information for all marketing objects. , implementation_dba_data: AMS.AMS_ACT_ACCESS ,
Table: AMS_DELIV_PRODUCTS 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_DELIV_PRODUCTS, object_name:AMS_DELIV_PRODUCTS, status:VALID, product: AMS - Marketing , description: This table stores information about the products related to a existing deliverable(collateral). , implementation_dba_data: AMS.AMS_DELIV_PRODUCTS ,
Table: AMS_ACT_CATEGORIES 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_ACT_CATEGORIES, object_name:AMS_ACT_CATEGORIES, status:VALID, product: AMS - Marketing , description: Generic category table used to hold categories an acticity can belong to, for reporting and search capability. , implementation_dba_data: AMS.AMS_ACT_CATEGORIES ,
Table: AMS_REQUEST_HISTORY 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_REQUEST_HISTORY, object_name:AMS_REQUEST_HISTORY, status:VALID, product: AMS - Marketing , description: This table captures the cover letter associated with the physical collateral requests placed from telesales. It also captures the order_id and collateral_id. , implementation_dba_data: AMS.AMS_REQUEST_HISTORY ,
Table: AMS_ACT_ACCESS 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_ACT_ACCESS, object_name:AMS_ACT_ACCESS, status:VALID, product: AMS - Marketing , description: Holds access information for all marketing objects. , implementation_dba_data: AMS.AMS_ACT_ACCESS ,
Table: AMS_CAMPAIGN_SCHEDULES 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_CAMPAIGN_SCHEDULES, object_name:AMS_CAMPAIGN_SCHEDULES, status:VALID, product: AMS - Marketing , description: This table is obsoleted and no longer in use. , implementation_dba_data: AMS.AMS_CAMPAIGN_SCHEDULES ,
Table: AMS_TRIGGER_ACTIONS 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_TRIGGER_ACTIONS, object_name:AMS_TRIGGER_ACTIONS, status:VALID, product: AMS - Marketing , description: AMS_TRIGGER_ACTIONS stores all actions that can be peformed when a particular Trigger Fires. , implementation_dba_data: AMS.AMS_TRIGGER_ACTIONS ,
Table: AMS_ACT_CATEGORIES 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_ACT_CATEGORIES, object_name:AMS_ACT_CATEGORIES, status:VALID, product: AMS - Marketing , description: Generic category table used to hold categories an acticity can belong to, for reporting and search capability. , implementation_dba_data: AMS.AMS_ACT_CATEGORIES ,
Table: AMS_TRIGGER_ACTIONS 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_TRIGGER_ACTIONS, object_name:AMS_TRIGGER_ACTIONS, status:VALID, product: AMS - Marketing , description: AMS_TRIGGER_ACTIONS stores all actions that can be peformed when a particular Trigger Fires. , implementation_dba_data: AMS.AMS_TRIGGER_ACTIONS ,
Table: AMS_USER_STATUSES_B 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_USER_STATUSES_B, object_name:AMS_USER_STATUSES_B, status:VALID, product: AMS - Marketing , description: Stores User status information , implementation_dba_data: AMS.AMS_USER_STATUSES_B ,
Table: AMS_OBJECT_ASSOCIATIONS 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_OBJECT_ASSOCIATIONS, object_name:AMS_OBJECT_ASSOCIATIONS, status:VALID, product: AMS - Marketing , description: AMS_OBJECT_ASSOCIATIONS is the cross reference between the Campaigns or Events or Creatives the that are running. , implementation_dba_data: AMS.AMS_OBJECT_ASSOCIATIONS ,
Table: AMS_OBJECT_ASSOCIATIONS 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_OBJECT_ASSOCIATIONS, object_name:AMS_OBJECT_ASSOCIATIONS, status:VALID, product: AMS - Marketing , description: AMS_OBJECT_ASSOCIATIONS is the cross reference between the Campaigns or Events or Creatives the that are running. , implementation_dba_data: AMS.AMS_OBJECT_ASSOCIATIONS ,
Table: AMS_USER_STATUSES_B 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_USER_STATUSES_B, object_name:AMS_USER_STATUSES_B, status:VALID, product: AMS - Marketing , description: Stores User status information , implementation_dba_data: AMS.AMS_USER_STATUSES_B ,
Table: AMS_ACT_METRICS_ALL 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_ACT_METRICS_ALL, object_name:AMS_ACT_METRICS_ALL, status:VALID, product: AMS - Marketing , description: This table stores the value for a metrics being tracked against a marketing entity e.g. the current value for metrics 'ROI' for a specific marketing campaign. , implementation_dba_data: AMS.AMS_ACT_METRICS_ALL ,
Table: AMS_ACT_METRICS_ALL 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_ACT_METRICS_ALL, object_name:AMS_ACT_METRICS_ALL, status:VALID, product: AMS - Marketing , description: This table stores the value for a metrics being tracked against a marketing entity e.g. the current value for metrics 'ROI' for a specific marketing campaign. , implementation_dba_data: AMS.AMS_ACT_METRICS_ALL ,
View: AMS_DELIVERABLES_VL 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AMS.AMS_DELIVERABLES_VL, object_name:AMS_DELIVERABLES_VL, status:VALID, product: AMS - Marketing , description: This view returns the marketing deliverable information. , implementation_dba_data: APPS.AMS_DELIVERABLES_VL ,
View: AMS_DELIVERABLES_VL 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AMS.AMS_DELIVERABLES_VL, object_name:AMS_DELIVERABLES_VL, status:VALID, product: AMS - Marketing , description: This view returns the marketing deliverable information. , implementation_dba_data: APPS.AMS_DELIVERABLES_VL ,