Results for “inbound_script_name”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
AMS_EVENT_HEADERS_AGENDA_V is an Oracle E-Business Suite (EBS) reporting view owned by the APPS schema within the AMS (Marketing) product family. It exposes general information about marketing event headers that pertain specifically to event agendas, returning one row per sub-level marketing event. The view is a filtered, denormalized projection over the event header data model and is intended primarily for reporting, inquiry, and integration scenarios where the agenda-level attributes of child events must be presented alongside their parent event context.
The view restricts its result set to records where EVENT_LEVEL equals 'SUB', meaning it is scoped to subordinate events tied to a parent event through PARENT_EVENT_HEADER_ID. This design makes it a convenient source for agenda dashboards, event workflow reports, and extracts that need parent/child event relationships in a single query. Because it resolved to a VALID status in both EBS 12.1.1 and 12.2.2, the object remains a stable, supported reference across these releases.
Underlying Base Objects
The view is defined over three documented base objects:
- AMS_EVENT_HEADERS_VL — referenced twice, once as EVH (the sub-event alias) and once as PEVH (the parent event alias). This is the core Marketing event header table/view carrying names, descriptions, status, agenda timing, registration, and certification attributes.
- AMS_USER_STATUSES_VL — joined on USER_STATUS_ID to resolve the user-defined status name (AUS.NAME, surfaced as USER_STATUS).
- FND_LANGUAGES_VL — outer-joined on MAIN_LANGUAGE_CODE to return the NLS language description.
The join between EVH and PEVH is an outer join (PEVH.EVENT_HEADER_ID(+)), so sub-events without a matching parent still appear, with parent columns null. The join to AMS_USER_STATUSES_VL is an inner join, and the join to FND_LANGUAGES_VL is an outer join.
Key Columns
- EVENT_HEADER_ID / ROW_ID — primary identifier and row identifier for the sub-event.
- EVENT_HEADER_NAME / DESCRIPTION — the sub-event's name and description.
- PARENT_ID / PARENT_NAME / PARENT_DESCRIPTION — the parent event identifiers, aliased from PEVH.
- EVENT_LEVEL — always 'SUB' in this view's output.
- REG_REQUIRED_FLAG, REG_INVITED_ONLY_FLAG, REG_MAXIMUM_CAPACITY, REG_MINIMUM_CAPACITY — registration control attributes.
- REG_CHARGE_FLAG (reg_charge_flag) — the column the user searched for; indicates whether the sub-event carries a registration charge.
- AGENDA_START_TIME / AGENDA_END_TIME / DAY_OF_EVENT — agenda scheduling fields.
- USER_STATUS_ID / USER_STATUS / SYSTEM_STATUS_CODE — user and system status values.
- CERT_CREDIT_TYPE_CODE / CERTIFICATION_CREDITS — certification credit detail.
- OWNER_USER_ID, COORDINATOR_ID, URL, PHONE, EMAIL — contact and ownership data.
- LAST_UPDATE_DATE, CREATION_DATE, OBJECT_VERSION_NUMBER — standard audit and concurrency columns.
Common Use Cases and Queries
Typical usage includes agenda reporting, parent/child event roll-ups, registration configuration review, and integration extracts. A representative query locating sub-events that charge for registration is:
SELECT event_header_name, parent_name, reg_charge_flag, reg_required_flag, agenda_start_time, agenda_end_time
FROM apps.ams_event_headers_agenda_v
WHERE reg_charge_flag = 'Y'
AND active_flag = 'Y';
The view may also be joined to registration and attendee tables via EVENT_HEADER_ID for capacity and attendance analysis. Because it is filtered to EVENT_LEVEL = 'SUB', callers should not expect top-level events to appear; those must be sourced from AMS_EVENT_HEADERS_VL directly.
-
This view returns the general information about marketing event headers agenda.
APPS.AMS_EVENT_HEADERS_AGENDA_V·↳ AMS_EVENT_HEADERS_VL·↳ AMS_USER_STATUSES_VL·↳ FND_LANGUAGES_VL·Explore AMS module →
-
This view returns the general information about marketing event headers agenda.
APPS.AMS_EVENT_HEADERS_AGENDA_V·↳ AMS_EVENT_HEADERS_VL·↳ AMS_USER_STATUSES_VL·↳ FND_LANGUAGES_VL·Explore AMS module →
-
View: AMS_P_CAMPAIGNS_V 12.2.2
This public view returns all marketing campaigns and related information.
APPS.AMS_P_CAMPAIGNS_V·↳ AMS_CAMPAIGNS_VL·Explore AMS module →
-
View: AMS_P_CAMPAIGNS_V 12.1.1
This public view returns all marketing campaigns and related information.
APPS.AMS_P_CAMPAIGNS_V·↳ AMS_CAMPAIGNS_VL·Explore AMS module →
-
This view returns the general information about marketing event offering agenda.
APPS.AMS_EVENT_OFFERS_AGENDA_V·↳ AMS_ACT_DELIVERY_METHODS_V·↳ AMS_EVENT_HEADERS_VL·↳ AMS_EVENT_OFFERS_VL·Explore AMS module →
-
View: ASO_I_CAMPAIGNS_V 12.2.2
View based on Campaigns
APPS.ASO_I_CAMPAIGNS_V·↳ AMS_P_CAMPAIGNS_V·Explore ASO module →
-
View: ASO_I_CAMPAIGNS_V 12.1.1
View based on Campaigns
APPS.ASO_I_CAMPAIGNS_V·↳ AMS_P_CAMPAIGNS_V·Explore ASO module →
-
View: AMS_EVENT_HEADERS_V 12.1.1
This view returns the general information about marketing events (headers).
APPS.AMS_EVENT_HEADERS_V·↳ AMS_EVENT_HEADERS_VL·↳ AMS_LOOKUPS·↳ AMS_USER_STATUSES_VL·Explore AMS module →
-
View: AMS_EVENT_HEADERS_V 12.2.2
This view returns the general information about marketing events (headers).
APPS.AMS_EVENT_HEADERS_V·↳ AMS_EVENT_HEADERS_VL·↳ AMS_LOOKUPS·↳ AMS_USER_STATUSES_VL·Explore AMS module →
-
Event level table .
-
Interface table for Event level .
-
This public view returns the campaign schedule information..
APPS.AMS_P_CAMPAIGN_SCHEDS_V·↳ AMS_CAMPAIGNS_VL·↳ AMS_CAMPAIGN_SCHEDULES_VL·↳ AMS_CHANNELS_TL·Explore AMS module →
-
View: AMS_EVENT_HEADERS_VL 12.2.2
This view returns the general information about marketing events (headers).
APPS.AMS_EVENT_HEADERS_VL·↳ AMS_EVENT_HEADERS_ALL_B·↳ AMS_EVENT_HEADERS_ALL_TL·Explore AMS module →
-
This view returns the general information about marketing event offering agenda.
APPS.AMS_EVENT_OFFERS_AGENDA_V·↳ AMS_ACT_DELIVERY_METHODS_V·↳ AMS_EVENT_HEADERS_VL·↳ AMS_EVENT_OFFERS_VL·Explore AMS module →
-
View: AMS_EVENT_OFFERS_V 12.2.2
This view returns the general information about marketing event offerings .
APPS.AMS_EVENT_OFFERS_V·↳ AMS_ACT_DELIVERY_METHODS_V·↳ AMS_EVENT_HEADERS_VL·↳ AMS_EVENT_OFFERS_VL·Explore AMS module →
-
Event level table .
-
Event Offering Level Table of Event Dimension .
-
View: AMS_EVENT_OFFERS_VL 12.2.2
This view returns the general information about marketing event offerings.
APPS.AMS_EVENT_OFFERS_VL·↳ AMS_EVENT_OFFERS_ALL_B·↳ AMS_EVENT_OFFERS_ALL_TL·Explore AMS module →
-
Interface table for Event Offering Level in Event Dimension
-
This public view returns the campaign schedule information..
APPS.AMS_P_CAMPAIGN_SCHEDS_V·↳ AMS_CAMPAIGNS_VL·↳ AMS_CAMPAIGN_SCHEDULES_VL·↳ AMS_CHANNELS_TL·Explore AMS module →
-
Stores the definition of a Marketing Event. (Master Event or Event Template)
-
Stores the definition of a Marketing Event. (Master Event or Event Template)
-
View: AMS_EVENT_HEADERS_VL 12.1.1
This view returns the general information about marketing events (headers).
APPS.AMS_EVENT_HEADERS_VL·↳ AMS_EVENT_HEADERS_ALL_B·↳ AMS_EVENT_HEADERS_ALL_TL·Explore AMS module →
-
View: AMS_EVENT_OFFERS_V 12.1.1
This view returns the general information about marketing event offerings .
APPS.AMS_EVENT_OFFERS_V·↳ AMS_ACT_DELIVERY_METHODS_V·↳ AMS_EVENT_HEADERS_VL·↳ AMS_EVENT_OFFERS_VL·Explore AMS module →
-
This view returns the general information about marketing event offerings without event header information.
APPS.AMS_EVENT_OFFERS_ONLY_V·↳ AMS_ACT_DELIVERY_METHODS_V·↳ AMS_EVENT_OFFERS_VL·↳ AMS_LOOKUPS·Explore AMS module →
-
Event Offering Level Table of Event Dimension .
-
This view returns the general information about marketing event offerings without event header information.
APPS.AMS_EVENT_OFFERS_ONLY_V·↳ AMS_ACT_DELIVERY_METHODS_V·↳ AMS_EVENT_OFFERS_VL·↳ AMS_LOOKUPS·Explore AMS module →
-
View: AMS_EVENT_OFFERS_VL 12.1.1
This view returns the general information about marketing event offerings.
APPS.AMS_EVENT_OFFERS_VL·↳ AMS_EVENT_OFFERS_ALL_B·↳ AMS_EVENT_OFFERS_ALL_TL·Explore AMS module →
-
Stores information about an Event Offering. .This table also holds the data for all the Agenda Items for the Event Offerings.
-
Stores information about an Event Offering. .This table also holds the data for all the Agenda Items for the Event Offerings.
-
Not implemented in this database·Explore BIM module →
-
Not implemented in this database·Explore BIM module →
-
Not implemented in this database·Explore BIM module →
-
Not implemented in this database·Explore BIM module →
-
Not implemented in this database·Explore BIM module →
-
Not implemented in this database·Explore BIM module →
-
Not implemented in this database·Explore BIM module →
-
Not implemented in this database·Explore BIM module →
-
VIEW: APPS.AMS_P_CAMPAIGNS_V 12.2.2
-
VIEW: APPS.AMS_P_CAMPAIGNS_V 12.1.1
-
VIEW: APPS.ASO_I_CAMPAIGNS_V 12.1.1
-
VIEW: APPS.ASO_I_CAMPAIGNS_V 12.2.2