Search Results igs_rc_i_pkg_item

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).