Search Results inventory_item_org_id




Overview
Explore in AI Chat

Overview

The view APPS.AST_EVENT_DELIVERABLES_V is an Oracle E-Business Suite 12.1.1 / 12.2.2 reporting object owned by the APPS schema and catalogued under the AST (TeleSales) product family. It presents deliverable records that are associated with event offers and are eligible for fulfillment at the point of customer enrollment or registration. The view joins event offer data to deliverable definitions and, where the deliverable is a physical, customer-order-enabled inventory item, to MTL_SYSTEM_ITEMS_B to expose inventory organization context.

Functionally, the view acts as a bridge between the Marketing / Advanced Marketing (AMS) offer model and the inventory item master. It is intended for consumers who need to enumerate fulfillable deliverables attached to an event offer, typically for order capture, fulfillment enablement checks, or downstream integration with order management. Because the view filters on AOA.FULFILL_ON_TYPE_CODE IN ('ON_ENROLL', 'ON_REG'), only deliverables triggered at enrollment or registration are returned. Note that a number of columns are exposed as literal NULLs (for example CONCATENATED_SEGMENTS, NON_INV_QUANTITY_ON_HAND, PRIMARY_UOM_CODE, and PRIMARY_UNIT_OF_MEASURE), which are placeholders reserved for downstream consumers and are not populated by the view definition itself.

Underlying Base Objects

The documented base objects referenced by the view are:

  • AMS_DELIVERABLES_VL (VIEW) — the source of deliverable identifiers, names, descriptions, availability dates, and fulfillment capability flags, aliased as ADAT.
  • AMS_EVENT_OFFERS_ALL_B (SYNONYM) — supplies the event offer header, aliased as EVT, joined via AMS_OBJECT_ASSOCIATIONS.
  • AMS_OBJECT_ASSOCIATIONS (SYNONYM) — the association table, aliased as AOA, linking master objects (event offers) to using objects (deliverables) with the fulfillment trigger code.
  • MTL_SYSTEM_ITEMS_B (SYNONYM) — the inventory item master, aliased as ITM, supplying ORGANIZATION_ID and enforcing customer-order eligibility.

The view is defined as a UNION of two branches. The first branch joins all four base objects and returns a valid INVENTORY_ITEM_ORG_ID from MTL_SYSTEM_ITEMS_B, restricting to items where CUSTOMER_ORDER_FLAG = 'Y' and CUSTOMER_ORDER_ENABLED_FLAG = 'Y'. The second branch omits MTL_SYSTEM_ITEMS_B and returns TO_NUMBER(NULL) for the organization identifier, covering deliverables that are not tied to an inventory item. Both branches filter on the association types 'EVEO'/'EONE' and 'DELV', the fulfillment trigger codes, and an effective-date window based on ACTUAL_AVAIL_FROM_DATE and ACTUAL_AVAIL_TO_DATE.

Key Columns

  • DELIVERABLE_ID — primary identifier of the deliverable record.
  • JTF_AMV_ITEM_ID — reference to the associated media/item record.
  • EVENT_OFFER_ID — the event offer to which the deliverable is attached.
  • INVENTORY_ITEM_ID — inventory item identifier for physical deliverables.
  • INVENTORY_ITEM_ORG_ID — organization identifier from MTL_SYSTEM_ITEMS_B; NULL for non-inventory deliverables.
  • DELIVERABLE_NAME / DESCRIPTION — descriptive attributes from AMS_DELIVERABLES_VL.
  • PRIMARY_UNIT_OF_MEASURE — exposed as NULL; not populated by this view.
  • ACTUAL_AVAIL_FROM_DATE / ACTUAL_AVAIL_TO_DATE — the availability window used in the effective-date filter.
  • CAN_FULFILL_ELECTRONIC_FLAG / CAN_FULFILL_PHYSICAL_FLAG — fulfillment capability indicators.

Common Use Cases and Queries

Typical usage includes listing fulfillable physical deliverables for a given event offer and confirming inventory item eligibility.

SELECT DELIVERABLE_ID, DELIVERABLE_NAME, INVENTORY_ITEM_ID,
       INVENTORY_ITEM_ORG_ID, ACTUAL_AVAIL_FROM_DATE
FROM   APPS.AST_EVENT_DELIVERABLES_V
WHERE  EVENT_OFFER_ID = :p_event_offer_id;

Consumers searching for primary_unit_of_measure should note that this view does not populate that column; the UOM must be sourced from MTL_SYSTEM_ITEMS_B via INVENTORY_ITEM_ID or from the item's primary UOM definition instead.

SELECT d.DELIVERABLE_ID, d.DELIVERABLE_NAME, i.primary_uom_code
FROM   APPS.AST_EVENT_DELIVERABLES_V d,
       APPS.MTL_SYSTEM_ITEMS_B i
WHERE  i.INVENTORY_ITEM_ID = d.INVENTORY_ITEM_ID
AND    i.ORGANIZATION_ID   = d.INVENTORY_ITEM_ORG_ID;